Crystal Reports: 3 New Uses For Sub Reports
page 2 of 5
by Jason Dove
Average Rating: 
Views (Total / Last 10 Days): 21413/ 34

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.


View Entire Article

User Comments

Title: RE: But Crystal could do this better   
Name: Ray S.
Date: 2010-11-23 11:39:27 AM
To: Bill Geake

I'm sure others will weigh on the capability of passing
parms from Main report to subreports based on SQL commands.
Here's what I do:

1) In the subreport, when you are setting up the command
in the "Modify Command" window, create a parameter,
that has the same type as the calling parameter in the
Main report.

2) From the Main report, right click on the subreport
and select "Change subreport links...". Then link
the Main report's parameter to the subreport's

Is this what you had intended to do? If not, sorry for
confusing the issue.

Title: My Thoughts   
Name: PA
Date: 2010-11-23 5:37:51 AM
Hi All,

With due regards and respect to the ideas that have been discussed, I failed to understand the "hatred" factor and the "3 New Uses For Sub Reports" concept.

1. Report Header:
This is generally achieved with report templates

2. Reconciling Conflicting Groups:
A single report cannot contain grouping based on multiple logics and combinations , so this is the obvious use of a sub report. I failed to understand, what's new?

3.Conditional Data Targets:
As an alternative, this could be achieved by providing hyperlinks to individual reports by enabling the hyperlink(s) based on condition(s)

Your comments are appreciated.

Title: But Crystal could do this better   
Name: Bill Geake
Date: 2010-11-23 4:38:36 AM
If only there could be a way of making it easy to pass values from the main report through to the sub report SQL. Jason hates sub reports; I hate selection formulae, and these hatreds are connected. The performance hit on sub reports isn't just the extra query per sub report instance - it's also the failure to filter data on the server and the increased network traffic that results.

Perhaps it's just my ignorance, but I've never been able to pass parameters to Oracle SQL in sub reports. If SAP could sort this out with an intuitive GUI it would make rich reports so much easier.
Title: Mr   
Name: David WHite
Date: 2010-11-23 3:55:37 AM
Amazing! They say the best ideas are really simple. I would never have thought of holding common components in a subreport. What a brilliant idea!
Title: Mrs.   
Name: Preetha Raju
Date: 2010-11-22 9:25:33 PM
Really, very useful tips. Specially header concept with the sub report, which I never thought.

Thank you very much, looking forward for more tips from you.

Product Spotlight
Product Spotlight 

Community Advice: ASP | SQL | XML | Regular Expressions | Windows

©Copyright 1998-2024  |  Page Processed at 2024-06-22 10:19:23 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search