Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Sub report not showing in ERP system Post Reply Post New Topic
Author Message
crnick
Newbie
Newbie


Joined: 15 Sep 2013
Online Status: Offline
Posts: 7
Quote crnick Replybullet 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

Edited by crnick - 17 Sep 2013 at 2:28am
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet 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
IP IP Logged
crnick
Newbie
Newbie


Joined: 15 Sep 2013
Online Status: Offline
Posts: 7
Quote crnick Replybullet 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.
IP IP Logged
crnick
Newbie
Newbie


Joined: 15 Sep 2013
Online Status: Offline
Posts: 7
Quote crnick Replybullet 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
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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 :(
IP IP Logged
crnick
Newbie
Newbie


Joined: 15 Sep 2013
Online Status: Offline
Posts: 7
Quote crnick Replybullet 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
IP IP Logged
crnick
Newbie
Newbie


Joined: 15 Sep 2013
Online Status: Offline
Posts: 7
Quote crnick Replybullet Posted: 25 Sep 2013 at 9:53pm
Still stuck help
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet 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
IP IP Logged
crnick
Newbie
Newbie


Joined: 15 Sep 2013
Online Status: Offline
Posts: 7
Quote crnick Replybullet 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.
IP IP Logged
crnick
Newbie
Newbie


Joined: 15 Sep 2013
Online Status: Offline
Posts: 7
Quote crnick Replybullet 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

Edited by crnick - 30 Sep 2013 at 2:03am
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.016 seconds.