Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Sub report , shared variables etc Post Reply Post New Topic
Author Message
Pascale
Newbie
Newbie


Joined: 01 Mar 2007
Online Status: Offline
Posts: 1
Quote Pascale Replybullet Topic: Sub report , shared variables etc
    Posted: 01 Mar 2007 at 2:59pm

Frustrated, and ready to quit!!

I have created two reports in which both i have had to manipulate a field to be able to have a unique field which can now be common in both. (Ie Process id).
One report shows paid, the other remitted; both are based on parameter date range.
 
I would like to now collate the two reports, that is show them as one single report and then group by process id in order to calculate the total paid and remitted per process id.
 
I have placed the paid report in Detail A section and remitted report in Detail B section , i would now like to ammalgate the two in Detail C section do a group by and summary. Is this possible.
 
The result may be such that there are paid with no remittances and remittances with no paid, therefore i need a full outer join to ensure all records are captured in the Detail C section.
 
I appreciate some directino on this issue, as conceptually it sounds easy but implementation is driving me crazy!
 
Thanks again in advaceAngry
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 01 Mar 2007 at 3:36pm
Sounds like you are asking too much of Crystal Reports. Yes, you can put subreports in detail section A and B, but you will NOT be able to then aggregate the data and group it in Detail Section C for grouping. What I recommend is to use a command object and instead of doing a full outer joing, use the SQL UNION statement to aggregate the data on your database server and then pull that into your report. (In fact, I just wrote about this in my data sources chapter last night!).

I think this will get you what you want.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
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.031 seconds.