My dashboard tab has a "Refresh" button in the header that is activated OnScreenLoad. After playing around with a copy of the dashboard, I traced the error message to a specific report "Report4". This particular report shows activities by "AssignedTo" (ie. by username).
Upon login as the manager, as expected, the first 3 reports are generated but are not populated with anything because the manager does not have a sales rep ID. I do see the report frameworks - they're just not populated with data - again, which is how it should be. However, the 4th one doesn't generate, and the report area is blank. Once I use a hyperlink to activate the sales rep dropdown and select a sales rep, the 4 reports are then populated with the sales results and/or activities for the selected sales rep.
Now, I can see the report4 in the Report Designer, and I see the activities by for every week in the year week in the pivot grid. The report itself only shows activities for the past 4 weeks.
So, all reports work, the numbers are fine, it's just that the 4th report does not initially generate. It only works after I seleck "OK" for the error message, then select a sales rep and then navigate to the tab for the 4th report.
Any suggestions offhand as to how this could happen? Again, I'm seeing this for the first time and the error hasn't popped up before.