Question Re: Error Message: No saved Data in Technology Q&A

Error Message: No saved Data

Former Member — Fri, 23 Mar 2018 15:34:15 GMT

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.

Re: Error Message: No saved Data

vitaly_izmaylov — Fri, 23 Mar 2018 15:40:18 GMT

Is it Crystal Reports Viewer like Standalone application like

https://www.sap.com/canada/products/bi-platform/crystal-reports-viewer.html

or you mean Crystal Viewer part of BI Server or Custom application?

Re: Error Message: No saved Data

Former Member — Fri, 23 Mar 2018 15:46:31 GMT

Standalone, just the basic Crystal Viewer 2016

Re: Error Message: No saved Data

vitaly_izmaylov — Fri, 23 Mar 2018 15:54:34 GMT

Crystal Reports 2016 Viewer does not have an engine to refresh report. The only option is to save data with the report in Crystal Reports Designer.

What you can do is to move the records selection formula with parameters to "Saved Data":

Copy and cut the content of
Report > Selection formulas > Record...

and paste it to
Report > Selection formulas > Saved Data

Refresh the report in CR Designer and Save with Data, then open it in CR Viewer it should prompt for parameters.

Re: Error Message: No saved Data

Former Member — Fri, 23 Mar 2018 17:30:36 GMT

Vitaly, I tried exactly what you said. I am still receiving the same error.

I made sure to save it with the Data and I moved the code from Record into Saved Data.

Any other ideas?

Re: Error Message: No saved Data

vitaly_izmaylov — Fri, 23 Mar 2018 17:32:52 GMT

The only explanation if there are no Saved data.

When you open the report in CR Designer, does it open with data?

Re: Error Message: No saved Data

Former Member — Fri, 23 Mar 2018 17:39:52 GMT

I am using ODBC to access the data.

In designer there is no data until I run the report, enter the parameters and receive the report with the data contained.

I have included the report for reference here:

https://www.dropbox.com/s/53kc9la0lytfk9f/Test.rpt?dl=0

Re: Error Message: No saved Data

vitaly_izmaylov — Fri, 23 Mar 2018 17:45:23 GMT

You need to refresh the report in CR Designer, then

Click File and make sure there is a Check next to " Save Data with Report"

then Click "Save"

There should not be a problem saving data with ODBC connection.

Re: Error Message: No saved Data

Former Member — Mon, 26 Mar 2018 12:25:56 GMT

Anyone got any ideas? Thanks

Re: Error Message: No saved Data

vitaly_izmaylov — Mon, 26 Mar 2018 14:19:38 GMT

did you try what I suggested previously:

1. refresh the report in CR Designer, then

2. Click File and make sure there is a Check next to " Save Data with Report"

3. Click "Save"

4. Test the new copy in CR Viewer

Re: Error Message: No saved Data

Former Member — Mon, 26 Mar 2018 14:37:15 GMT

Vitaly,

Yes, I made sure that "Save Data with Report" is checked. I did that both in the original report and in the one where you had me move the code in the Records Selection Formulas. In both cases I receive the same error.

I included a link above with the report in it.

Thanks.

Re: Error Message: No saved Data

Former Member — Mon, 26 Mar 2018 15:55:42 GMT

Vitaly,

I included a link above with the report in it.

Thanks.

Re: Error Message: No saved Data

former_member292966 — Mon, 26 Mar 2018 16:31:32 GMT

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

Re: Error Message: No saved Data

Former Member — Mon, 26 Mar 2018 17:25:52 GMT

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?

Re: Error Message: No saved Data

Former Member — Mon, 26 Mar 2018 17:56:53 GMT

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.

Re: Error Message: No saved Data

former_member292966 — Mon, 26 Mar 2018 20:56:56 GMT

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

Re: Error Message: No saved Data

Former Member — Tue, 27 Mar 2018 12:32:51 GMT

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.

Re: Error Message: No saved Data

former_member11696 — Wed, 28 Mar 2018 21:25:11 GMT

No, that was never the plan for CR Viewer.

Only option is to host your own web site and write an application for them to use.