Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: SubReport Error Post Reply Post New Topic
Author Message
dcirk
Newbie
Newbie
Avatar

Joined: 02 Nov 2009
Online Status: Offline
Posts: 1
Quote dcirk Replybullet Topic: SubReport Error
    Posted: 02 Nov 2009 at 4:00am
Hi
 
Hope you can help i'm having problem with a subreport...
 
(Report 1) -  report uses a Add Command querie with one Parameter passed {?LPID}.
 
(Report 2)  - report uses a similar Add Command querie with one parameter passed {?LPID}.
 
both queries reference the same SQL Database and there is no linking.
 
(Report 2) was inserted into (Report 1) as a sub report as standard using menu insert \ subreport .
This works fine in Crystal X1 Development.
if run as the report in production i get the 'This Field is not known'
'Error in Formula' .
However if i run the Reports as two separate main reports in production they work fine so the formula's etc.. must be Ok
 
Is ther something i'm missing when inserting a sub report
 
any pointers would be great  Dead
 
 
 
dcirk
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 03 Nov 2009 at 6:39am
did you link the subreport to the main report? did you fill in the parameter?
 
I am not a big fan of using the Command query to gather data for a report, as I don't believe that is what it was designed to do, and as such, it may not work reliably.  I believe that it was designed to assist in the population of dynamic parameters, not to gather data for the report.
 
This may be where the issue is, but I also don't believe in subreports as they incur a roundtrip to the DB everytime they are displayed, so performance suffers.  I prefer stored procs or views which return everything that you need for the report (including the subreport) then it is only a matter of formatting the data, or at the worst, creating a subreport that utilizes the same data, and doesn't need to go to the DB.
 
HTH
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.