-
Title
When running a report in Knowledge Portal's "Subreports" folder, an error message is received: "A -
Description
When running a report in Knowledge Portal's "Subreports" folder, an error message is received, such as the following error message samples:
Sample 1:
Reporting Services Error
An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Query execution failed for data set 'MainDataSet'. (rsErrorExecutingCommand) Get Online Help
Invalid object name 'T_QCWP_TEMP_fc248723_4485_406f_8f60_d3ab42229a64_Sessions'.
Sample 2:
Reporting Services Error
An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Query execution failed for data set 'MainDataSet'. (rsErrorExecutingCommand) Get Online Help
Invalid object name 'T_QCWP_TEMP_881dbf37_a05b_430f_96b6_0ba22ae837ffEvents'. Invalid object name 'T_QCWP_TEMP_881dbf37_a05b_430f_96b6_0ba22ae837ffcanonicalNmaes'.
Sample 3:
Reporting Services Error
An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Query execution failed for data set 'MainDataSet'. (rsErrorExecutingCommand) Get Online Help
Invalid object name 'T_QCWP_TEMP_4dc926cf_1df9_44a7_952e_b939ad23e372_SESSION'. -
Cause
None of the subreports are designed to be executed as regular reports. They are designed to use some temporary data pre-selected by a main ("Summary") report they "belong to" and to be run only by clicking links in summary reports.
None of the reports from the Subreports folder can be viewed in any way other than from it parent report at all. -
Resolution
Please do not run any subreports either manually in Knowledge Portal or through a job or task in InTrust Manager.