Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: conditional suppression in subreport Post Reply Post New Topic
Author Message
bobsn
Newbie
Newbie


Joined: 19 Mar 2007
Online Status: Offline
Posts: 27
Quote bobsn Replybullet Topic: conditional suppression in subreport
    Posted: 05 Jun 2007 at 8:27am

Hello all,
  I have a main report with a certain grouping order. There is a sub report which contains fixed data around 300 rows(comes from a table in the database). Now there is the same grouping order in sub report too. I would like the subreport to display only one row which pertains to the group match in main and subreport.

Eg: If the Rep ID (group 1) in the main report matches with the Rep ID in the sub report, show that particular row in the subreport and suppress the rest of the 299 rows.

Is this possible?

 

IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 05 Jun 2007 at 10:43am
That's easy to do. On the main report, in design mode, right-click on the subreport and choose Change Subreport Links. Then in the Report Links dialog box, pick the field from each report that they will be linked on. When you are done, CR will filter out the data in the subreport so that it matches the group in the main report.
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
bobsn
Newbie
Newbie


Joined: 19 Mar 2007
Online Status: Offline
Posts: 27
Quote bobsn Replybullet Posted: 05 Jun 2007 at 11:52am
Originally posted by BrianBischof

That's easy to do. On the main report, in design mode, right-click on the subreport and choose Change Subreport Links. Then in the Report Links dialog box, pick the field from each report that they will be linked on. When you are done, CR will filter out the data in the subreport so that it matches the group in the main report.
 
I tried doing that. It didnt work out before too.
 
The subreport comes out empty wherever it has been put.
 
i cant understand why its doing that
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 05 Jun 2007 at 1:50pm
I would create a second detail section and put the subreport in the second one. That way you know that the main detail has already printed. If still nothing prints, I would check that the subreport is actually getting the correct data passed to it. Put the parameter field in the header so you can see what data is being passed. On the other hand, if the subreport isn't printing at all, then something else is going wrong. Can you double click on the subreport to open it in a new window? I had this problem once and I installed SP3 for CR and then it started working fine. So you might want to download the latest service pack if your problem is similar to what I had happen.
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.047 seconds.