Is there a way to have multiple table builder reports in one Excel files, in separate tabs? I tried doing this by copying my second table builder report to the first file and just adding it as another tab but when I clicked on Refresh, the second tab basically turned into just a copy of my first tab, which has the first table builder report.
Date
Votes
1 comment
-
Harry Lewis Hello Lyn -
I have not been able to duplicate what you describe. Here are the steps I took.
I have two reports ("First Report" and "Second Report").
In First Report, I used the Table Builder to report on the Customer table from Dynamics NAV.
In Second Report, I used the Table Builder to report on the Item table in Dynamics NAV.

I then selected the function in Second Report and copied them.

and pasted that in a new sheet in First Report

When I run First Report, my original sheet has Customer data and my new sheet has Item data:


What do I need to do to duplicate the situation you describe?
Please sign in to leave a comment.