Crystal Reports: including a subreport into a grouping section?

views:

653

answers:

Crystal Reports: including a subreport into a grouping section?

I have a report which lists out a company detail. There are two sections to the company detail. The first portion lists out environmental data and the second is actually a subreport which lists out Cash flow details for every single year of the company.

I have multiple companies i need to do this for--so i grouped the report by Company. This works like a dream except for when it comes to the subreport. I'm having real issues trying to get it so that every single company has a different subreport of cash flow. Anybody know how to include a subreport into a group so that every company i have has its own data for the cash flow data?

The subreport has to take a parameter that identifies a company, which the main report will provide. Then you link the value to the parameter via the subreport properties available on the main report page.

OMG Ponies 2009-10-19 18:21:20

this does not work. the param only keeps the subreport together but does not display an individual subreport on each page. what i mean is that instead of each company displaying an individual subreport of cashflow, it is all clumped together.

2009-10-20 17:59:40

The subreport has to be within the DETAILS section, so as the company id changes, the subreport is re-run based on the company id. The setup does in fact work, it's how you've got your report laid out that is the issue.

OMG Ponies 2009-10-20 18:01:59

i have it currently in the DETAILS section and it shows up as so:CompanyAdatadata dataCompanyBdatadatadata

2009-10-20 18:28:22

Do you get the subreport duplicated for each company, including all every companys' data?

OMG Ponies 2009-10-20 18:33:48

yes i'm afraid that was the issue i was trying to explain before (i apologize if i was unclear). I just want it so that if i have company a's data showing, i only get company a's subreport for its cashflow

2009-10-20 19:40:47

If I understand correctly then, the subreport is not getting the company id, and in this situation it defaults to selecting all companies.

OMG Ponies 2009-10-20 19:45:32

The subreport should be in the group header or footer, otherwise it'll repeat once for every row of the relevant company.

CodeByMoonlight 2009-10-21 11:43:46

@CodeByMoonlight: Assuming there is a group defined. Placement is minor at the moment - The bigger issue is that the parameter isn't getting to the subreport.

OMG Ponies 2009-10-21 14:51:06

Rexem -- thank you for trying to help :) i really appreciate it. If i do find out the answer, i will post it up here!

2009-10-21 14:57:07

ansaurus

tags:

views:

answers:

Crystal Reports: including a subreport into a grouping section?

related questions