combine crystal reports with multiple subreports

[Myra21]

Hi,

I have 8 crystal reports with six sub reports in six detail section of each reports .
The detail A is same for all the reports. Only rest of sub reports differ in each report.
I want to combine them in one report.

I would like to know a way to combine the reports.

 

[Turkbear]

Hi,
There is not enough information to determine how to help.

How many tables are involved and how do they relate to each other?
What are you reporting on that needs such an odd arrangement?
( In my 10-15 years or so of using Crystal, I have never used 6 subs in one report)

If the A detail is the same , why 8 reports?

Help us help you.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Myra21]

The reports are variation of each other.
The reports handle different types of cases filed.
Depending on the type of the case sub reports are displayed related to that case.

There is slight variation in the sub reports too. Depending on the cases

I am using a Oracle procedure as a data source . All the table joins are taken care of in the procedure.

The report will be called by an java web application. I am trying to pull reports related to all cases together instead of calling them separately.

 

[lbass]

You might be able to insert a group on case type in the container report, place one set of subs in the group section linked on the case type and then adapt the subs to accomodate differences between the case types.

Or you could handle it by using a parameter on casetype and then build one report that handles variations through using the parameter in conditional formulas, etc.

-LB

 

[Myra21]

Thanks for the input LB.

I am trying to use only 2 parameters start date and end date to pull all the reports in that date range.

I will try the grouping but adapting the sub reports can be tricky with the specific variations on cases.

Considering using conditional suppress on some of the sections with sub reports not related to the case.

Will that work well or is there a better way to do it?

Thanks

 

[lbass]

Yes, that makes sense.

-LB

 

[Myra21]

Thanks LB.

I have one more question.

Some reports are generated blank when no data is returned by the Oracle procedure.


I would like to display a 'No Data Found !' message instead of a blank report.

what is the best way to do that in Crystal 2008 ?
Report is called by Java web application through BO.

Thanks.

 

[lbass]

In File->report options, make sure that "Suppress Printing If No Records" is NOT checked, and then create a formula like this for your report header:

if isnull({table.field} then
"No Data Found"

Make sure that you use a recurring field--one that is found in each record when there is data, i.e., one which is never null when there is data in the report.

-LB