Skip to Content
0

Crystal Reports print detail section before next detail section

May 01 at 10:23 PM

29

avatar image
Former Member

Is it possible to print out a full detail section before the next detail section? Example: if I have "Details a" and "Details b", I would like to print out "Details a" and then "Details b". It should look like the following if there are 3 records in each table:

Details a

Details a

Details a

---------------

Details b

Details b

Details b

Of course, the default behavior prints out like the following.

Details a

Details b

Details a

Details b... and so on

The reason for this is that records in "Details a" are stored in a different table than records in "Detail b" and they both have the same parent table.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Vitaly Izmaylov
May 01 at 10:26 PM
0

I think subreport is an easy solution for the problem

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member May 02 at 06:13 PM
0

Hi Vitaly, thank you for your response. I should have mentioned that this is a sub-report. If only we could have sub-reports in sub-reports.

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Not possible simply for performance. For example

Main report query returns 1000 values linked to the subreport, for each value ( 1000 ) a connection and query is sent to the database Server, from that subreport the query returns another 1000 values which results in:

1st Sub runs 1000 times each with it's own query and opens a connection per subreport

2nd subreport runs 1000 times each with it's own query and opens a connection per subreport

All happening at once = 1+ 1000 + 1000 connections opened.

From a Server side that is going to consume a lot of DB Processing, now lets for example say 100 users are running this same report...

I think you get the picture... from a performance perspective it's not practicle to allow subreports in subreports...

Groups are easier to use to filter collections.

Don

0
Former Member

Don - thank you for your response.

I am aware that sub-reports within sub-reports is not possible for the reasons you explained.

However, my issue still persists. I am currently working on a solution to put all the records in an array and print it out in the footer. There is a small issue of when the footer prints though.

Any other suggestions would be great.

0