I have downloaded the Example reports for Jets express and Dynamics NAV.
After connecting to our NAV (using web services) successfully, I was able to refresh the "Top Customer Overview" report example which I opened from the report player.
The Slicers for the Sales person still has the old data in it (names such as John Roberts etc.).
I take it that this is because it is a sort of Pivot data.
So my question is how can I change the slicer data?
Thank you
Dave K.
Date
Votes
3 comments
-
Jet Reports Historic Posts Hello Dave,
When opening the report you should be able to Refresh the report and enter your desired Date Filter which will automatically update the Slicers.
"Slicers are used in this report as a method of filtering pivot table data. Slicers will not work in versions prior to Excel 2010. As an alternative, you can drag fields to the Filters area in the Pivot Table Field List. "
Regards,
MWilson -
Jet Reports Historic Posts I refresh, and I see my data in the spread sheet apart from in the slicers.
I am guessing that the pivot data must have some hard coded fields somewhere.
If so, how do I change them?
Thanks. Dave K. -
Jet Reports Historic Posts Hi Dave,
Right-click on the Slicer and pick Slicer Settings…
Deselect the box next to "Show items deleted from the data source"
Steve
Please sign in to leave a comment.