I have a report that has a sub-report. The sub-report receives a parameter to filter out the DATA needed. At design time, both reports are working just perfect. When I run the report through my web application, I get the following error msg :
Error in File C:\DOCUME~1\46746\LOCALS~1\Temp\Region_Project_Docs {1A4E0AC3-9103-4969-89A4-C2086BBD49A3}.rpt: Invalid group condition.
As it seems, it is because of calling the Sub-Report which receives a parameter value. Do I have to do something extra in the web form dealing with the parameter passed in order to run both reports in my application giving that both reports are using the
same query? If so, how? If not, then what is the problem?
Notice: I have other reports working through my web application just perfect!
1. Validate your SQL statement you have used for report or perticular query.
2.There could be Dataset change.it can cause problems. Try updating the XSD file with the latest dataset structure if you are using any.Relink your database to it.
3.If you have any links to a database do Verify Datasource to make sure all is still linking correctly.
4.If any of the above does not work then try breaking down the report to the basics. Have no parameters or grouping. Then add one at a time and test each time.
Hope this will help you.
Marked as answer by Noorstudio on Apr 22, 2012 04:05 PM
Thank you. This is my first time I do a sub-report.
I understood from your reply that once a master report is running well on a web application, then, there is no further step to do in the code behind in order to run a sub-report, and I started from there.
I changed my sub-report logical design and it worked.
How I solved the problem:
The data needed to be displayed in the sub-report was also in a group section. It seems that there was kind of recursive calls (maybe)! So, I changed the logic and made simple sub-report and have the data displayed on the details section of the sub-report.
(And life is good!)
I still don’t understand how CR was able to figure out the table/query needed for the sub-report at run time of the web application!!
Could you please explain how?
Thanks
Marked as answer by Noorstudio on Apr 22, 2012 04:05 PM
Noorstudio
Member
130 Points
243 Posts
Invalid group condition
Apr 22, 2012 07:35 AM|LINK
Hello!
I have a report that has a sub-report. The sub-report receives a parameter to filter out the DATA needed. At design time, both reports are working just perfect. When I run the report through my web application, I get the following error msg :
Error in File C:\DOCUME~1\46746\LOCALS~1\Temp\Region_Project_Docs {1A4E0AC3-9103-4969-89A4-C2086BBD49A3}.rpt: Invalid group condition.
As it seems, it is because of calling the Sub-Report which receives a parameter value. Do I have to do something extra in the web form dealing with the parameter passed in order to run both reports in my application giving that both reports are using the same query? If so, how? If not, then what is the problem?
Notice: I have other reports working through my web application just perfect!
Thanks
avinash_bhud...
Contributor
2881 Points
517 Posts
Re: Invalid group condition
Apr 22, 2012 08:02 AM|LINK
You can try following to solve your problem.
1. Validate your SQL statement you have used for report or perticular query.
2.There could be Dataset change.it can cause problems. Try updating the XSD file with the latest dataset structure if you are using any.Relink your database to it.
3.If you have any links to a database do Verify Datasource to make sure all is still linking correctly.
4.If any of the above does not work then try breaking down the report to the basics. Have no parameters or grouping. Then add one at a time and test each time.
Hope this will help you.
Noorstudio
Member
130 Points
243 Posts
Re: Invalid group condition
Apr 22, 2012 04:04 PM|LINK
Hello!
Thank you. This is my first time I do a sub-report.
I understood from your reply that once a master report is running well on a web application, then, there is no further step to do in the code behind in order to run a sub-report, and I started from there.
I changed my sub-report logical design and it worked.
How I solved the problem:
The data needed to be displayed in the sub-report was also in a group section. It seems that there was kind of recursive calls (maybe)! So, I changed the logic and made simple sub-report and have the data displayed on the details section of the sub-report. (And life is good!)
I still don’t understand how CR was able to figure out the table/query needed for the sub-report at run time of the web application!!
Could you please explain how?
Thanks