Jane has attended:
No courses
Pivot Table report
I have created a query from which I then viewed it in Pivot Table view and saved it.
How can I set this pivot table as a report to be viewed from the switchboard?
many thanks
Jane
RE: Pivot Table report
Hi Jane,
The Pivot table once saved as a report can be run from a macro.
You therefore need to create a macro that opens the pivot report. I suggest using the OpenReport Action in the macro. This then allows you to assign the macro to the Switchboard
Regards