Hi Folks, I am new to Jet Reports. I have created a report that is connected to Dynamics GP. There are no parameters for the user to enter/select. However, everytime I open the excel file, the reports begins to calculate/refresh itself, even though I have saved the file after it finished generating the previous time. I am using Excel 2003 on a terminal server with Jet Reports version 7.1.2 Build 1830.
Other existing similar reports do not do this.
Please advise what needs to change for this behavior to stop.
Thanks,
Haresh Melwani
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi Haresh,
You need to be sure that you have Auto+Hide+Values in cell A1 of at least one sheet on the report. Then when you run the report, the formulas will be replaced with values. So if you save it after running it, and close and reopen it, it won't recalculate. Does that work for you?
Regards,
Hughes -
Jet Reports Historic Posts Yes, That works! Thanks for the prompt reply.
Haresh
Please sign in to leave a comment.