Excel Report Builder

(0) Share

Report

Posted on by Michael Byrne

1,075

Is it possible to create two excel reports using excel report builder(one for sales, another for financial) and merge the sheets together onto one book? Will the data be refreshable per sheet or does excel allow only one data connection per work book?

Thank you,

Mike

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

Re: Excel Report Builder

Hi Mike,

Yes, excel allows multiple connections per Excel Sheet. We can create a separate connection for each workbook in an Excel sheet.

However, you will need to manually merge the sheets after publishing. After publishing the reports, open the both reports in excel. Right Click on workbook name and use the Move or Copy Option in the workbook merge two excel sheets. This will also move the data connection of the sheet to destination excel sheet. You can see the connections on Data tab in excel sheet.

If you make any changes in reports in GP and re-publish them, you will need to merge the sheets again.

Rubal,

http://dynamicsgphelp.com/