Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Avoid Printing Same data in Subreport DrillDown? Post Reply Post New Topic
Author Message
ksam
Newbie
Newbie


Joined: 10 Dec 2011
Location: United States
Online Status: Offline
Posts: 9
Quote ksam Replybullet Topic: Avoid Printing Same data in Subreport DrillDown?
    Posted: 13 Dec 2011 at 5:14pm
Hello,
I have a sub report that has drill down which is placed in report footer.When i run the report sub report displays the data but when i tried to drill down it displays the same data again.After that i can able to drill down on sub report.Is there any way to avoid
printing the same data twice.
Thanks in advance.
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 15 Dec 2011 at 6:55am
I'm not too familiar with drill downs, but this is what I remember.
 
you have a report, you click on something, a new tab opens with that item's information.
 
since you item in on a subreport, I am guessing that the first repeat is CR opening the subreport (you drilled down from the main report).  If this is the case, I don't think that there is a way to get rid of the duplication.
 
the 'obvious' answer, though probably more difficult is to get rid of the subreport.  The only way (typically) is to get your data from a stored procedure, creating the data that would be in your subreport. 
 
Now that you have all the data that you need in one line the report changes to have at least 1 more group on it and your detail becomes the subreport data...at least that is what I typically do.  Reduces the number of hits to the database, but can make for a simpler/more complex report (depends on how you view it)
 
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.