I can connect Jet Express to my database and create custom reports but can't figure out how to connect the Pre Built Reports to my database. I'm using MS Dynamics GP.
Date
Votes
8 comments
-
Jet Reports Historic Posts Hello MCL,
You do not "connect" specific reports to your database.
All that you need to do is open the report and refresh it as long as you have your data source configured.
Is there a specific report that you are trying to refresh and are you encountering an error in trying to do so?
Best regards,
MWilson -
Jet Reports Historic Posts Following error when refreshing Trial Balance
PivotTable3 could not be refreshed. The following error was reported:'Reference isn't valid'.
Trial Balance versus Prior Year
PivotTable1 could not be refreshed
The following error was reported:'Reference isn't valid'
Trial Balance by Month
PivotTable1 could not be refreshed
The following error was reported:'Reference isn't valid'
etc -
Jet Reports Historic Posts Hello MCL,
The reason that you are encountering these errors is because the NL(Table) function(s) which those PivotTables are based off of did not run properly.
To find out why they didn't run you will need to do as follows.
1) Refresh the report.
2) Right click on the sheet tabs at the bottom of the screen and choose "Unhide".
3) Unhide all of the hidden sheets.
4) If you scroll through those sheets you will likely see a #VALUE where the NL(Table) function would be while in Design Mode.
5) If you select that #VALUE function and press "Debug" then an error should be revealed as to why the NL(Table) function did not run.
If you attach the various errors and let me know which sample report you are using I may be able to guide you to fix the issue.
Best regards,
MWilson -
Jet Reports Historic Posts Thanks MWilson
Report NAV009-Trial Balance
Invalid Table '15 G/L Account'.
NAV012 - Trial Balance vs Previous Year
Retrieving flow fields is not supported in this type of data source.
NAV014 - Trial Balance by Month
Retrieving flow fields is not supported in this type of data source.
NAV015 - Profit and Loss Variance
Exception of type 'Jet.Shared.JetReportsException' was thrown.
NAV016 - GL Monthly Income Statement
Exception of type 'Jet.Shared.JetReportsException' was thrown.
NAV019 - AP Summary
The pivot table 'PivotTable2' could not be refreshed.
The following error was reported: 'Reference isn't valid.'.
Invalid Table '23 Vendor'.
NAV020 - AP Details
The pivot table 'PivotTable1' could not be refreshed.
The following error was reported: 'Reference isn't valid.'.
Invalid Table '25 Vendor Ledger Entry'.
NAV027 - GL Activity Detail Report
The pivot table 'PivotTable1' could not be refreshed.
The following error was reported: 'Reference isn't valid.'.
Invalid Table 'G/L Entry'.
Thanks,
Mike -
Jet Reports Historic Posts Hello Mike,
It appears that all of the reports you are tying to run are sample Dynamics NAV reports, not sample Dynamics GP reports as noted in all of their names.
e.g.
Report NAV009-Trial Balance
If you are connected to a Dynamics GP data source then you should be running sample GP reports.
My assumption is that you downloaded these sample reports recently.
The Jet Reports website was recently updated and the link to the sample reports on the Express for GP page went to the wrong download (NAV sample reports).
This has been fixed so that it takes you to the correct set of GP sample reports now.
Please navigate to the following link and download the sample reports again.
You should see a list of reports that looks like below.
Best regards,
MWilson -
Jet Reports Historic Posts Hello MWilson,
That's exactly what happened. The reports are working.
Thanks,
Mike -
Jet Reports Historic Posts MWilson,
Is there a way to get rid of the NAV reports in the Report Player?
Thanks -
Jet Reports Historic Posts Hello Mike,
The report player stores all of its reports in your "My Documents" folder "C:\Users\username\Documents\My Reports\Reports" (where "username" is your Windows username).
You should be able to navigate to that folder and delete all of the NAV reports.
If you wish, just for cleanup, you can also navigate to the "My Documents" folder "C:\Users\username\Documents\My Reports\Images" and delete all of the .png files that refer to the NAV reports.
Best regards,
MWilson
Please sign in to leave a comment.