Print Page | Close Window

Sub report not showing in ERP system

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=20023
Printed Date: 05 May 2024 at 4:31pm


Topic: Sub report not showing in ERP system
Posted By: crnick
Subject: Sub report not showing in ERP system
Date 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


Replies:
Posted By: lockwelle
Date Posted: 17 Sep 2013 at 4:45am
by showing in the ERP, you mean through the application?

It might be that the datasource for the subreport is not set correctly by the application...

just a thought

Posted By: crnick
Date Posted: 17 Sep 2013 at 8:14pm
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.

Posted By: crnick
Date Posted: 19 Sep 2013 at 12:32am
Still haven’t got it working. The database was set correctly. So that isn't the problem. Pls help

Posted By: DBlank
Date 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.
I have done that mistake too many times :(

Posted By: crnick
Date Posted: 19 Sep 2013 at 4:55am
I dont use multiple connections. I just use the same connection as the main report.

http://imageshack.us/content_round.php?page=done&l=img14/2650/e3lg.jpg

Posted By: crnick
Date Posted: 25 Sep 2013 at 9:53pm
Still stuck help

Posted By: lockwelle
Date 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.

DBlank might have some other ideas

HTH

Posted By: crnick
Date Posted: 29 Sep 2013 at 9:42pm
Thanks for the tip! Just made the whole report again and now it is working fine! Was getting pretty tired of it. I think i tried everything twice.

Posted By: crnick
Date Posted: 30 Sep 2013 at 2:02am
I just figured out what was wronge.. seems like the date parameters in the subreport links were giving problems.. now working with a daterange


Print Page | Close Window