Hi - You will have to do it the other way around.

You can add your Sub Reports to a Report Designer AddIn (RDA) Union Report.

The RDA Task Pane formulas need the data from the hidden sheets that get generated when you run the report.

Is this report an in house report or will you need to import it to a client?

It's an in house report. Ok. I will try that. Thanks

This is what i get. I have no totals and I don"t see the comparison between this report and the previous report (prior screen shot).

Can you take a screen shot of the Union report - Union Sub Reports tab. The one that looks like this:

The reason why it's not working is your sub reports are going to sheet1 and that's where the sub report "Report Designer Add-In - Accounts 1-0" is going.

You will need to add a new sheet to the template and put it in the 9th position.

Open the Template in Design Mode.

Unhide all of the Hidden sheets.

Add a new sheet to the left of the Settings 1-0 sheet which should be position 9.

Save/Link the template back to the report in Report Manager.

Then change your ShareCode1,2,3 to output to that sheet's position (9).

Now the GL Formulas should work.

The reason why it's not working is your sub reports are going to sheet1 and that's where the sub report "Report Designer Add-In - Accounts 1-0" is going.

You will need to add a new sheet to the template and put it in the 9th position.

Open the Template in Design Mode.

Unhide all of the Hidden sheets.

Add a new sheet to the left of the Settings 1-0 sheet which should be position 9.

Save/Link the template back to the report in Report Manager.

Then change your ShareCode1,2,3 to output to that sheet's position (9).

Now the GL Formulas should work.

Nice. It Works!  Thank you so much. Now i just have to work my excel magic to creat the report for my bosses! thank you again!

You are welcome.

Add a new sheet to the RIGHT of the Settings 1-0 sheet which should be position 9.

ok. I will.

OK. I will.