Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Sub report displaying redundant records Post Reply Post New Topic
Author Message
joshimuralikris
Newbie
Newbie
Avatar

Joined: 25 Aug 2009
Location: India
Online Status: Offline
Posts: 18
Quote joshimuralikris Replybullet Topic: Sub report displaying redundant records
    Posted: 23 Sep 2009 at 12:07am
Dear Experts,

i've designed a crystal report and embedded a sub report in it, the sub report needs to display some 7 records (i.e 7 lines), the design goes this way

i've few detail sections then the sub report is inserted in a detail section followed by few detail sections, the issue here is when i check preview the report detail sections are displayed perfectly when comes to question of sub report its display 2 records repeatedly for pages together(approx 5 pages) and at the 5th page its dispalying all the records perfectly, later the same pages are repeated again.

i'm using the same stored procedure in both the main and sub report.

if some one has come across this sort of issue plz let me know how to overcome, i will be happy to explain you the problem in detail if some one is interested.

Thanks in advance

Murali..
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 23 Sep 2009 at 6:37am
if you are using the same data source, you can probably get rid of the subreport.  Subreport, in general, are IMO unnecessary.  They are a performance degrader causing more hits to the DB (if you have 100 lines of detail and each has a subreport you will hit the DB 101 times).  The data is already in the main report, it may just be a matter of restructing it.
 
I know sometimes it is not possible, but in the 3 years I have been writing CR I have created reports with subreports, maybe twice.
 
HTH
IP IP Logged
joshimuralikris
Newbie
Newbie
Avatar

Joined: 25 Aug 2009
Location: India
Online Status: Offline
Posts: 18
Quote joshimuralikris Replybullet Posted: 23 Sep 2009 at 7:11am
Thanks for ur reply lockwelle..

i'm forced to use the subreport in this spl case, so i'm trying to know weather i can restrict sub report from getting replicated after every detail section.

is there any work around to achieve the functionality?? if soo please let me..

Thanks
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 24 Sep 2009 at 6:08am
The subreport should only run in the 1 detail section it is in.  If there are many more rows than expected, the only thing that comes to mind is that subreport is not filtering the data correctly for the detail section that it is reporting on.  Perhaps a better link/more links are needed.
 
Sorry I can't be of more help.
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.