Subreport linking to Group 1

[shelby55]

Hi

I am using Crystal 9.0 reporting from an Access 2002 database.

I have a report that has two groups - fiscal year and then "element B" which could be discharge month or quarter depending on the selection of boolean paramters DMonth and Qtr.

I want to add a subreport to report data in a different database. I created one subreport for the fiscal year group and the subreport was built in the "report footer" (but placed in Group 1) and is working fine.

I created as second report to include in Group 2. The parameters are working but it shows both values after each other and not syncing to the main report i.e.

[tt]2009/10 15 30 87
Qtr 1 10 15 89
84
Qtr 2 5 15 89
84[/tt]

The last data element is the one(s) coming from a subreport.
What I want is:

[tt]2009/10 15 30 87
Qtr 1 10 15 89
Qtr 2 5 15 84[/tt]


I'm sure there is something simple that I'm missing - thanks!

 

[lbass]

The second report needs to be linked on both fiscal year and element B.

-LB

 

[shelby55]

HI LB

Of course...how stupid am I! I knew it would be something simple.

Thanks!

 

[shelby55]

HI LB

I must be slow or something because it's still not working.

The subreport is sitting in ElementB of the main report. ElementB is based on the boolean query of Dmonth or Qtr.

In the subreport I have it also grouped with a Data Element B so that it will group as per the main report selection. I also have a hidden Group A which is fiscal year just like the Main Report.

But it's not working...what am I doing wrong? Thanks.

 

[shelby55]

Hi

Sorry...big brain fart. I wasn't linking on elementB so once I did that all is good.

Thanks LB!