It was suggested that I ask this question under this forum topic:
It has been a while since I last used crystal Reports but I am currently creating a report that retrieves data from the database. The object of this report is to bring back data as information is added to the database (constantly populating with current data). Basically this is live data, so as more data is added, my intentions is to place a link within either a simple HTML page or ASP page and the user will then click a button, launch the report in the viewer, and print it to physical paper. The only way I have found to get it to work, is that I have to refresh while I am in the Crystal Reports application (Not the viewer but the actual app), and then the data will refresh, but once I save the report, the information seems to pretty much be static at that point. The trouble I am having is that when I open the report, it does not refresh/pull new data from the database but rather contains whatever data was in the report when I initially = saved it.
Issue:
I have read across the internet including this forum here, where people have said all you need to do is uncheck the option: File -> Save Data with Report and this should solve the problem. I have done just that and when you view the report in Crystal Reports Viewer afterwards, it then brings up a dialogue box telling you it cannot display any data and that you need to go to Crystal reports and enable "Save Data with Report". So not sure why people are saying this solves the problem when it won't work afterwards (?), but anyhow, how do I get this report to refresh data when the report is opened in CR Viewer or any app of the sort? Additionally, you cannot refresh within the viewer application so you have to open Crystal Reports itself.
Is there some options I am missing? I think when I originally worked with CR, it was through VB.Net, so I have never really worked with a standalone Report, which I need, as I need it to be portable.
Thank you