Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Cannot open RPT without saved data Post Reply Post New Topic
Author Message
kcbrent
Newbie
Newbie


Joined: 25 May 2012
Location: United States
Online Status: Offline
Posts: 9
Quote kcbrent Replybullet Topic: Cannot open RPT without saved data
    Posted: 26 Jul 2012 at 7:50am

It has been mentioned several places that when you create a brand new report, you need to uncheck "Save with data". Then, save the report first, before you run it for the first time.

 

I have done both of these steps and have ran the report within Crystal Reports which runs beautifully and all data populates correctly. BUT when I run the stand alone RPT file outside of Crystal Reports inside a report viewer (such as Crystal Reports viewer) it tells me it cannot find any saved data. The error message I get right when it opens the file states the following:

No Saved Data – This report file does not contain saved data and cannot be viewed. – to get data into the report please open and re-save in the Crystal Reports designer application with the 'Save Data Report' option selected.

 

The problem with this is that if the checkbox to save data is checked, it saves the data (obviously) but that data then becomes static, it wont refresh from SQL, so whatever data the report had in it when it was saved out of Crystal Reports, it is now permanent.

I am finding conflicting statements. Other users tell me not to have this checked if I want the report to auto grab data from SQL but the report viewer tells me it needs to be checked to display data.

 

All I want to do is have a user open the RPT file (via some RPT Viewer app) and then it automatically grab fresh data from the SQL server. It sounds simple but the RPT file wont do it.

 

Does anyone know how I can get this task done?

 
Thank you.
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 26 Jul 2012 at 12:28pm
Most viewers that I have heard of do not allow refreshing of the data.  I know that you can create a Visual Studio app or use one of SAP's products that allow refreshing of data.
IP IP Logged
kcbrent
Newbie
Newbie


Joined: 25 May 2012
Location: United States
Online Status: Offline
Posts: 9
Quote kcbrent Replybullet Posted: 26 Jul 2012 at 6:54pm

I have wrote software which opened and printed a RPT file before but the idea behind this is to allow users to point to and open a simple RPT file and print it to paper (or pdf) without the need of having to open it through a software application (other than the viewer itself). Can this not be done at all? If I can tell a program to  update and print a RPT file why can’t a viewer have the built in code to do the same? And then what is the point and purpose of a viewer then?

 

thanks

IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 27 Jul 2012 at 11:42am
Which SDK and viewer are you using to develop this?
 
-Dell
IP IP Logged
kcbrent
Newbie
Newbie


Joined: 25 May 2012
Location: United States
Online Status: Offline
Posts: 9
Quote kcbrent Replybullet Posted: 27 Jul 2012 at 8:23pm
I am using the Crystal Reports app and Crystal Reports viewer.

thank you.
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 29 Jul 2012 at 11:34am
How are you calling the viewer?  Are you just installing the viewer app on the desktop or is it, for example, embedded in a web page?
 
-Dell
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.