I am new with Jet and have recently managed to install Jet on my machine. I have accessed the report player report NAV035 but whenever i try to refresh this report it gives me an error on the NL Function
=NL("CubeValue";"Sales";"[Measures].[Sales Amount]";"Filters=";$D$4:$E$6;"[Posting Date].[Date YQMD].[Day]";$E$61;"DataSource=";Datasource). IF I edit the function and evaluate, I get the error Invalid Filter "Startdate.. End Date", which is a date range to be used in my report. The cell outputs #VALUE for all such cells. I have checked my regional settings for the date format and all that seems to be consistent with the date format on my machine. Urgently assist as i am needing to deploy reports to users.
Date
Votes
4 comments
-
Jet Reports Historic Posts Hello nkaruwo,
I modified the report for you which should work now.
Analysis Services is looking for an mm/dd/yy rather than mm/dd/yyyy filter.
I fixed the date filters so that they would return the format that Analysis Services is looking for.
You will need to update your Pivot Table Data Source with the instructions on the "Before Running This Report" sheet before running the report.
Best regards,
MWilson -
Jet Reports Historic Posts Thanks Wilson, the report refreshed on one click. So what changes did you do to the report, so that I can be able to do the same with some other reports with the same problem.
-
Jet Reports Historic Posts Hello nkaruwo,
The changes were made to the following cells on the "Dashboard" sheet.
E61: =TEXT($E$60,"mm/dd/yy")&".."&TEXT(TodaysDate,"mm/dd/yy")
E62: =TEXT($E$58,"mm/dd/yy")&".."&TEXT(TodaysDate,"mm/dd/yy")
E67: =TEXT($E$66,"mm/dd/yy")&".."&TEXT($E$64,"mm/dd/yy")
E68: =TEXT($E$65,"mm/dd/yy")&".."&TEXT($E$64,"mm/dd/yy")
Best regards,
MWilson -
Jet Reports Historic Posts Hi Wilson;
Thank you very much , this worked for this report and other similar reports. Fantastic.
Please sign in to leave a comment.