Sub Report

[ptrifile]

I have a Blank report that is just a container report for a few sub reports. All 3 of the subreports have a subreport in them as well.

The subreport within the subreport is not showing any data when running the report. I know this is not alot of information to go on but is there something obvious that would be preventing this?

Thanks for any help

Paul

 

[ptrifile]

I should add that if i run the report without putting it in the "Container" report it runs fine. Both report and subreport show data. I only have the problem when i place the report into the container report as a subreport.

Paul

 

[Madawc]

Crystal doesn't allow subreports within subreports, one of its limits.

You can get something of the same effect by passing details up using Shared Variables and then down again using Edit . Subreport Links.

It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options. But I don't think any of them allow sub-sub-reports

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP

 

[ptrifile]

Thanks Madawc, Let me ask this question then...there may be a simple answer but i cant seem to figure it out and was the reason i was trying to use so many sub reports...

If i have a database that shows number of calls based on certain areas i need to have a report show me number of calls(along with other data, but to keep this simple ill use just calls to an area) for a subset of areas.

So if all of the areas are that im "Selecting" are the following:

Repair t1
Repair t2
Repair t3
Repair t4
Repair t5
Repair t6
sales t1
sales t2
sales t3
sales t4
sales t5
sales t6

So i have the "Select Expert" choose the above areas but i dont want to calculate "total calls" based on all of them, i want to show "Total sales calls" which would only include "sales t1 thru Sales t6" and then a total for just "total Repair calls" for "repair t1 thru repair t6"

The desired result would look something like:

Area Calls
Sales t1 5
Sales t2 10
Sales t3 7
Sales t4 11
Sales t5 2
Sales t6 1
Total 36


Area Calls
Repair t1 5
Repair t2 3
Repair t3 10
Repair t4 15
Repair t5 2
Repair t6 4
Total 39

If this is something extremely simple i appologize but i just cant seem to figure it out. any help is appreciated.

Thank you

Paul

 

[hilfy]

You could do this two ways:

1. Use a running total for each and set the "Evaluate On" formula to only add the numbers for Sales or Repair calls depending on which one the running total is calculating.

2. Create formulas something like this and then Sum them:

{@RepairCall}
If InStr({table.area}, 'Repair') > 0 then 1 else 0

{@SalesCall}
If InStr({table.area}, 'Sales') > 0 then 1 else 0

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[lbass]

If you have a field that returns repair and sales, then you could insert a group on this field and then another group on the t field, and then drag the group #1 groupname into group #2 header. Then insert summaries at each group level.

Or is 'repair t1' all one field? If so, you could split it and still do the grouping like this.

-LB

 

[ptrifile]

Thank you to you both, hilfy, when i create those formulas i only return zeros for my data.

lbass, the name is all one field, how would i split them as you suggest?

Thank you

Paul

 

[hilfy]

Have you created a summary to sum the formulas to get your totals?

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.