Sub Reports Alongside Main Data

[ganjass]

CR8
Sql2000

I have a report that consists of 1 main report and 2 subreports. The subreports have a common link AccNo. What i'd like to do is display the 2 subreports lined up with the main reports data ie

Acc No X Y Z (Sub1 X Y Z) (Sub2 X Y Z)

and to have it export like this as well, is this possible?

Thanks

 

[Madawc]

I've done such reports in Crystal 8.5. It is best to set printer landscape to Landscape, which lets you line up several subreports along-side main-report data. If the subreport size is variable, don't put anythign below it in the same section, start a new section if you need it.

It is also a good idea to do a test like isnull({account}) within the subreport, and say if nothing was found. You know then whether the link was failing or there was no data.

Export to Excel does work, though it didn't look very need.

Madawc Williams (East Anglia)

 

[ganjass]

I've created a section above the details section and have ticked the underlay tick box in the section format, and well its not looking the prettiest, Plus it takes forever to export as both sub reports have 120,000 records each which are used to provide calculations for 450 rows each.

Is this the only way to achieve this in crystal?

 

[Madawc]

Can you cut down on the number of reads the subreports do?

Failing that, a Stored Procedure written in SQL can be a great saving. I managed to learn how to write it in the course of doing things with it, and there is also a forum where you can ask advice from SQL experts.

Madawc Williams (East Anglia)