Click here to Skip to main content
Click here to Skip to main content
Technical Blog

Tagged as

Crystal Reports: 3 New Uses For Sub Reports

, 30 Aug 2011 CPOL
Rate this:
Please Sign up or sign in to vote.
Crystal Reports: 3 New Uses For Sub Reports

I hate sub reports and always consider them the last resort in any reporting solution. The negative effect on performance and maintainability is just not worth the easy ride they give the report writer. Nine times out of ten, reporting requirements can be met using a little forethought and planning (and a solid understanding of formulas).

That said, there are a few novel ways of using sub reports which will not affect performance and actually prove a boon to the developer.

1. Report Header

Any information, graphics, logos or special fields (Date report was run, etc.) which will appear in every report can be built into a sub report which is then added to the main report.

The performance hit is minimal, and a small amount is shaved off the development time, plus, it can go a long way to standardising your reports. But the real benefit comes when the business decides to update its logo or corporate color, etc. As long as the sub report is set to “Re-import When Opening” (via the sub report’s Format Editor), only one sub report needs to be changed to impact across the entire report library.

2. Reconciling Conflicting Groups

Often there is a requirement to show the same information summarised by logically conflicting groups. For example: showing the total sales for each week within a month and totals sales per team in a month.

A typical sub report can be used to load the data again then group it by the second value, and this is the typical way to use a sub report. But accessing the database again for data you have is a waste of resources which can be crippling with bigger reports.

The most efficient way to handle this is to load the information you want into one or more arrays and pass them through to the sub report to format and group as you want.

It is possible to display the array in the main report and forego the need for a sub report at all, but if you are reporting against a lot of data there is a chance the report will finish before the array has been fully displayed.

3. Conditional Data Targets

I come across this issue quite often: a report is needed which always shows the same set of data, plus one of two (or more) other sets of data depending on the user’s choice or the results returned from the first set of data.

Because a single report can only have one set of linked tables, multiple sub reports must be used.

For example: A sales report shows revenue for a particular office, if the office has met its target the managers want to see how they compare to the rest of the offices, but if they fail to meet their target they want to see the sales broken down by each rep to identify any problem areas.

A report based on sales reps and one based on nation office sales require completely different tables. The most efficient way to solve this problem is to create a sub report for each. Whichever is not needed is suppressed and given Record Selection criteria which will return an empty report. The required sub report runs as normal.

Summary

Sub reports can kill a report’s performance, but when used with a little imagination they can be a helpful tool in expanding Crystal Reports functionality in a way that cannot be realised by any other method.


License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

JasonDove
Scry Business Intelligence
United Kingdom United Kingdom
Jason Dove is a senior consultant at Scry Business Intelligence and instructor who has specialised in Crystal Reports and Business Intelligence his entire career, utilising it for everything, from selling paint to counter-terrorism. He has provided Business Intelligence consultancy for some of the world’s leading companies and is currently making the same service available to smaller businesses. He is also the author of 'Crystal Reports Formulas Explained', a step by step guide to creating and using formulas for the industry leading BI reporting software.

Comments and Discussions

 
QuestionHow to change subreport's datasource or report file in runtime ? PinmemberKPRANAV_Dot_Net5-Feb-13 19:07 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web01 | 2.8.141223.1 | Last Updated 30 Aug 2011
Article Copyright 2011 by JasonDove
Everything else Copyright © CodeProject, 1999-2014
Layout: fixed | fluid