Hello Folks,
I have been trying to create a custom report for below mentioned query.
SELECT v_R_System.Netbios_Name0 AS 'Computer Name',
v_GS_Autodesk320.ProductName0 AS 'Product Name',
v_GS_Autodesk320.Release0 AS 'Release',
v_GS_Autodesk320.SerialNumber0 AS 'Serial Number',
v_GS_Autodesk320.InstallType0 AS 'Deployment Type',
v_GS_Autodesk320.KeyName0 AS 'Key Name'
FROM v_R_System INNER JOIN
v_GS_Autodesk320 ON v_R_System.ResourceID =
v_GS_Autodesk320.ResourceID
WHERE v_GS_Autodesk320.SerialNumber0 is not NULL
ORDER by v_GS_Autodesk320.ProductName0
Now, when I run this query in report builder or SQL Server Management Studio, I get the desired output.
I have created a report for the same in SCCM 2012 console.
When this report is ran from console, I get the following error message.
Microsoft.Reporting.WinForms.ReportServerException
An error has occurred during report processing. (rsProcessingAborted)
Stack Trace:
at Microsoft.Reporting.WinForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WinForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WinForms.AsyncMainStreamRenderingOperation.RenderServerReport(ServerReport report)
at Microsoft.Reporting.WinForms.AsyncRenderingOperation.PerformOperation()
at Microsoft.Reporting.WinForms.ReportViewer.AsyncReportOperationWrapper.PerformOperation()
at Microsoft.Reporting.WinForms.ProcessingThread.ProcessThreadMain(Object arg)
-------------------------------
Microsoft.Reporting.WinForms.ReportServerException
Query execution failed for dataset 'DataSet1'. (rsErrorExecutingCommand)
Stack Trace:
at Microsoft.Reporting.WinForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WinForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WinForms.AsyncMainStreamRenderingOperation.RenderServerReport(ServerReport report)
at Microsoft.Reporting.WinForms.AsyncRenderingOperation.PerformOperation()
at Microsoft.Reporting.WinForms.ReportViewer.AsyncReportOperationWrapper.PerformOperation()
at Microsoft.Reporting.WinForms.ProcessingThread.ProcessThreadMain(Object arg)
-------------------------------
Microsoft.Reporting.WinForms.ReportServerException
For more information about this error navigate to the report server on the local server machine, or enable remote errors
Stack Trace:
at Microsoft.Reporting.WinForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WinForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WinForms.AsyncMainStreamRenderingOperation.RenderServerReport(ServerReport report)
at Microsoft.Reporting.WinForms.AsyncRenderingOperation.PerformOperation()
at Microsoft.Reporting.WinForms.ReportViewer.AsyncReportOperationWrapper.PerformOperation()
at Microsoft.Reporting.WinForms.ProcessingThread.ProcessThreadMain(Object arg)
-------------------------------
Any help\suggestions\recommendation to fix this would be appreciated.
Thank You !