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?

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:

Hi Manny, If you do not see the Task Pane once you run the report then follow steps in the KB article 18616 to reinstate the Task Pane, aka Excel Add-In https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=18616&sliceId=1&isLoadPublishedVer=&docType=kc&docTypeID=DT_Article&stateId=22028&cmd=displayKC&dialogID=954337&ViewedDocsListHelper=com.kanisa.apps.common.BaseViewedDocsListHelperImpl&openedFromSearchResults=true

Sandra

thanks for the info. I do get the task pane. I'm just not getting any data. If i run this report without the sharecode sub reports I get data. If I run a report with just the Sharecode subreports I get data. But if I run them together, as I did in this report, I get no data. Any idea?

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.