Topic: Sub report not showing in ERP system Posted: 16 Sep 2013 at 8:10pm
hello,
I have a problem with sub reports in crystal reports when I am using crystal reports in the ERP system we are using. When I am previewing the report in crystal reports it is showing the sub report as it is suppose to be but when viewing in the ERP system the sub report is not showing. When I use the sub report on its own everything is working fine.
I hope someone is able to help me.
Many thanks,
Nick
thanks for responding and yes i mean in the application. i was thinking the same thing. i am new to crystal reports so it might be some simple mistake. I have made some reports before and they were showing the sub reports in the application.
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 19 Sep 2013 at 3:46am
I know this is basicaly the same answer as Lockwelle but it is the most likely issue...do you change the ODBC connection? One for development and one for production? make sure the ODBC connection for the subreport is pointing to your production set. Also drill into the source data and make sure their is not an alias being used.
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Posted: 26 Sep 2013 at 5:01am
since neither DBlank nor myself can think of anything else, the other alternatives are to:
1) create a new report just like the current report...sometimes for reasons unknown CR just gets stuck
2) create you dataset in such a way that the subreport is not needed. This is easiest to do with a stored procedure.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum