on 04-22-2014 4:39 PM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
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
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
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.