cancel
Showing results for 
Search instead for 
Did you mean: 

Problem with Save data with report

Former Member
0 Kudos
256

Post Author: ramprosoft

CA Forum: General

Hi,

I am new to CR and using Crystal Reports XI with SQL Server 2000.

I'm not able to remove the saved data in a report. I have played around different options, but unfortunately I'm not able to remove the data. I have checked variouse places in web above this issue not able to find a solution, so decided to open a new post. The problem is :

I have created a simple report and saved with-out data (1st version) the file size was 16KB. After few changes I have saved the same report with Data, the file size become 1065 KB. Its perfect and I can view the report in Report Viewer. Great Stuff!. Now the Testing completed, I would like to move this report to production environment, I notice that I'm unable to remove the data. I have played around various tricks like below, but it didnt work well.

Trick 1:

Uncheck: File->Options->Reporting (tab)->Save Data With Report.

Check: File -> Options -> Reporting (tab)->Discard Saved data on Open,

Uncheck: file-> Report Options -> Save Data With Report.

File -> Save Data with Report (Not selected)

Opened the report and try "save" and also tried "save as", still the size is 1065.

Trick 2:

I enabled all "Save Data with report" feature. Deleted all the rows in the table related to the query, previewed the report and Saved the report with "Save Data with report" featuer. But now, the funny part happen, the file size increased to 1070kb, instead of reducing. Worst Stuff!!!

Trick 3:

Updated the latest version of Patch and tried above tricks, still i'm not able to remove the data.

Appreciate, if you could help me to fix the problem.

thanks in advance

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Post Author: salmanq

CA Forum: General

Hi, This

post is very informative, however I would like some specific information. If

someone can help me then please send me a private message. Best Regards,

Wholesale Pages UK Dropshippers

| Wholesale Suppliers

Australia Wholesalers and

Dropshippers | Dubai Property and Real Estate

Former Member
0 Kudos

Post Author: ramprosoft

CA Forum: General

Hi Bryan,

As i mentioned, with the image the size of the reports was 16bk only.

You can also try save a report with data and try to remove the data. See if the reports size goes back to original size after you save 0 rows.

thanks

ramesh

Former Member
0 Kudos

Post Author: bryanflora

CA Forum: General

Did you put any picture in your report?The picture will be stored as BMP which causes rpt file very bi.

Former Member
0 Kudos

Post Author: ramprosoft

CA Forum: General

Hi Yangster,

Got stuck with some other important work, couldn't check this post.

answer to your question:

basically i tried bogus values to return 0 rows, it didnt work well so i tried physically deleting of all the rows in table, so the query will return 0 rows.

Regards,

Ramesh

Former Member
0 Kudos

Post Author: yangster

CA Forum: General

What do you mean by deleted all rows in trick 2.Have you tried running the report with a bogus value for your parameter which would return 0 rows? For example if you have a date parameter pick a date of 1900 when you know your db wouldn't return any results.Is the size of your report still 1meg vs the 16kb you are hoping for?