Error Message: No saved Data

[Former Member]

I am having a major problem and I am hoping someone can help. I create a report that works great in Crystal Reports 2016. If I run the report from the designer it works fine. I have parameters that I request and it prompts and runs great. As soon as I try to open up that same report in Crystal Viewer I receive this message:

To get data into the report please open and re-save it in the Crystal Reports designer application with the "Save Data with Report" option selected.

I dont want to save the data with my report. I want Crystal Viewer to prompt me for the parameters and than display the report.

I need to deploy this report out for users to utilize. They need to be able to open it in Crystal viewer, input the parameters and get the results.

Can anyone help me out? I am going crazy.

[former_member292966 · Accepted solution]

Hi Kris,

Can we try something simple? Can you create a simple report with 1 table and a couple of fields.

Make sure Save Data with Report is unchecked before you preview it.

Once you previewed the report to the last page, turn on Save Data then save the report. I think this is the step that's been missed. The report needs to generate all the pages before Save Data will work properly.

Run it in the viewer. Can you see the data.

If that works, repeat the steps with your report and make sure you go to the last page before you save the report.

By the way, I did download your report to look at and there definitely is no data in it.

Good luck,

Brian

[Former Member · Accepted solution]

Brian,

I think I may see the problem, Can you answer this question for me?

This report needs to have conditions and access a live (Constantly Changing) database to pull the results.

The Designer does this fine. Is the viewer able to prompt for parameters, go into a live database, pull the data and than produce a report with the new data at the time you run the report through viewer? Or is the viewer only for looking at previously pulled data?

[former_member292966 · Accepted solution]

Hi Kris,

The view cannot connect to the database and retrieve data. It can only show the static data the last time the report was run in the Designer. That's what the Save Data with Report option is for. The viewer is not designed to connect to your database and refresh the data.

The viewer is a very archaic tool that I think outlived its purpose years ago. It is a great way to send someone a report back in the days before exporting to PDF was possible. Back before the internet was efficient and fax machines ruled document transmission.

If you want your report to refresh, there are a couple of options. The first is to develop an application that can open your report, connect to the database and display it. The second is to do a search for a viewer that can do this for you. Have a look at Ken Hamady's site for some suggestions. Some of them are free.

Good luck,

Brian

[Former Member · Accepted solution]

Thanks Brian, that is my problem than. Thanks for getting back to me.

Seems ridiculous that Crystal Viewer would not have this capability. That is the whole point of Crystal. Hopefully they fix that some day. Having someone run the report in designer every time is really not ideal. But we will make do with what we have. Thanks for the help.