I am a Report Designer and have created a report that is pulling GL accounts, GL descriptions, current/prior year/budget amounts. This report is to be used by a Report Viewer and I have included Auto+Hide+Values in cell A1 and added a report options tab for the viewer to change the years and periods as needed.
Currently when the Report Viewer opens the spreadsheet and runs the report from the Report options window, the report does not update with a new GL account that was created in GP earlier in the day. When the Report Viewer tries the Refresh button the new account does not appear. If I (the Report Designer) goes into the spreadsheet and runs the report, the new account appears.
Does the Report Viewer have the ability to Refresh the spreadsheet so the new account will appear or is this something a Report Designer can only do? Is there anything else the Report Designer needs to do in order for the report to function properly for a Report Viewer?
Thanks,
Jacki
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi Jacki,
That sounds like it is either that the report viewer has not closed and reopened Excel since the new account was added or else a permissions issue (the Report Viewer does not have permissions in GP or SQL server to see the new account). Can the report viewer open GP and see the new account in GP? Also, if they completely close all instances of Excel and reopen it, does this help?
Regards,
Hughes
Please sign in to leave a comment.