Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Mutlitple detail sections with totals right below them

Status
Not open for further replies.

ginaburg

Technical User
Jul 14, 2004
62
US
I have a report with multiple detail sections and a group total for each detail section.
Right now is shows:
detail section
detail section
group total section
group total section

Is there any way to link the detail section to the group total to show on the like this:
detail section
group total section

detail section
group total section
 
Try posting specifics, such as:

Crystal version
Database/connectivity used
Example data
Expected output

Your post is far too generic to address intelligently, but it sounds like you have 2 different sets of data, which might mean using a subreport.

-k
 
Ths is actually realted to the last question I posted about the sales,cost and margin using a subreport.

I tried a different approach.
I took the sales and cost tables and created a sql view to combine the two tables.
I have 1 detail section with sales data, 1 detail seciton with cost data.
I have 2 groups one for the sales total and one for the cost total. The total are working but I want to show them on my report as
sales detail section
sales group 1 total seciton

cost detail section
cost group 2 total seciton

can you link a group total section to print right below a specific detail section
 
I think you should have stayed with your original thread. Readers benefit from seeing the entire context. Please see my suggestion there.

-LB
 
Still a bit vague, and you didn't answer the questions asked. As LB appropriately pointed out, most won't be interested in going and finding your original post because you decided to start over.

It sounds like you would just use Insert->Group and place the Group field in there, and then turn off the group header, display the details and in the group footer use an aggregate, but it's hard to say.

-k

 
Actually this wasn't a continuation from the last thread. I was just making reference to it because synapsevampire mentioned about using a subreport (which was my approach in the last thread) This is a totally different way that I am trying to do the report.

I'm not sure how else to ask it.
I want to show the 2 detail sections, but I want to have the report show the group footer below each detail section.
Detail section a:
Project Sales 1 500.00
Project Sales 2 300.00
Group Footer a:
Total Project Sales 800.00

Detail section b:
Project cost 1 200.00
Project cost 2 150.00
Group Footer b:
Total Project cost 350.00
 
This is the same report you are trying to do, isn't it? I think that what you are describing can only be done with subreports--fairly simply, too. Please see your former thread...

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top