I have the following issue:
I am trying to create a report with subreport this way:
1) create report
2) create subreport. Set parameter @AccountName in the SQL query (...WHERE account.name = @AccountName) and in the parameters collection - AccountName, data type string
3) place the subreport into the report and set parameters AcountID = =Fields!name.Value, so that the WHERE clause in the subreport should filter the content according to the field Fields!name.Value.
So far, I suppose this should work. Nevertheless, I get this result in Visual Studio .net:
An error occurred while executing the subreport 'subreppp': An error has occurred during report processing.
Cannot read the next data row for the data set DatasetXYZ.
When I publish the reports into our CRM, I get the main report but the subreports shows: "#Error: The subreport could not be shown".
What can I do to make this work properly?
Any help would be VERY appreciated as I have already wasted several hours with this issue.
Thank you a lot!
View Complete Post