cancel
Showing results for 
Search instead for 
Did you mean: 

Crystal Reports Viewer not showing saved data

Former Member
0 Kudos

The problem I am having is that the crystal reports I would like to display in the viewer have saved data, I want to display that saved data so far I found everyone wants the opposite. I am using Crystal reports 2011 Visual studio 2010 VB and crystal runtime 13.0.2 on a windows server 2008 64-bit. Thank you all in advance.

Accepted Solutions (1)

Accepted Solutions (1)

former_member188030
Active Contributor
0 Kudos

Open the report in CR 2011 designer.

Preview it.

Go to file menu and check 'Save data with report' option.

Save the report.

Now View this report from your application without refreshing it. (rd.refresh or viewer.refresh).

It should work.

- Bhushan

Senior Engineer

SAP Active Global Support

Follow us on Twitter

Got Enhancement ideas? Try the SAP Idea Place

Getting started and moving ahead with Crystal Reports .NET applications.

Former Member
0 Kudos

Bhushan,

The reports already have preview data saved with it, since these reports are
generated from peopelsoft. I can open the reports in CR designer and I can run
the web app on my local machine for testing through visual studio and it will
show me that saved data correctly. The problem occurs when I try to open the
same reports through the web application on the server it does not work. Thank
you for your response.

former_member183750
Active Contributor
0 Kudos

Hi Savane

How do you know the reports have saved data? To me the following:


I can open the reports in CR designer and I can run

the web app on my local machine for testing through visual studio and it will

show me that saved data correctly. The problem occurs when I try to open the

same reports through the web application on the server it does not work.

indicates that when:

"...CR designer and I can run the web app on my local machine for testing through visual studio...",

you more than likely are making a trusted / integrated db connection and thus the report connects to the database, gets the data and displays it. And thus this looks like the report has saved data. On the web server, you do not have trusted / integrated authentication, the report does not have saved data and thus it either errors out, or prompts for db logon.

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow us on Twitter

Former Member
0 Kudos

Ludek,


I do not have any connection to the database. The reason I
say it has saved data because when I open the report in the designer it opens
already into the preview tab with the data. I do not reload/refresh the report,
since I do not have the database connection I cannot rerun the preview anyway. When
I run the report on the server it says its missing parameters this is because I
have the parameter prompt to false, I want it to stay false because I want it
to show the data it shows when I open it in the designer without rerunning.

Also when I load the report into the viewer the properties show that it has saved data.

I hope that make sense. Thank you

former_member183750
Active Contributor
0 Kudos

And in your code, when running the report on the server, you do not have any CR database connection APIs?

If that is the case, can you attach the saved data report here? (rename it to *.txt, then reply and hit the "Use advanced editor" link. Attach there.

- Ludek

Former Member
0 Kudos

No, I do not have any database connection APIs. I'm sorry I
cannot attach the report here. Is there anything else you can suggest?

former_member183750
Active Contributor
0 Kudos

Nope. Can you not create a report with dummy data that will demo the same thing?

Umm, I have attached a report here that is with saved data. There is no magic in this report. See if you can run it on your server.

- Ludek

Former Member
0 Kudos

Ludek,

I ran the report you sent and it did run successfully. I am
working on getting a report with dummy data. I think the issue may be with
the report version used for peopelsoft. Since prior to this I did have a
problem with these reports needing the u2lbar.dll. I appreciate your help

former_member183750
Active Contributor
0 Kudos

If a UFL is missing (e.g. u2lbar.dll) and the report needs it, you will get issues. Though I'd expect errors along the lines of; file <UFL lname> missing, not a db logon prompt. But if the reports need this dll, ensure that it is available in any case. Even a saved data report will need it.

- Ludek

Former Member
0 Kudos

That is correct, I was able to address that issue by copying over the dll as
suggested in another discussion. I am no longer having that issue, I just
brought it up just in case it is relevant to this issue as well. By next week I
should have the sample report to put on here. Thank you

Former Member
0 Kudos

Ludek,

I have attached a sample of the report.

former_member183750
Active Contributor
0 Kudos

When I try to open the report - in the CR designer - I get this error:

That indicates that either there is a formula in the report that has an error, or more likely there is a formula in the report that is dependent on a UFL.

- Ludek

Former Member
0 Kudos

Yes, that is correct there is a formula that is dependent on the u2lbar.dll the function is StringToPostnet

Answers (0)