Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1891
  • Last Modified:

User panicking. Cannot save Crystal Report after 6 hours of work.

Hi.

I have a colleague who is nearly crying.

They have Crystal Reports Professional Version 11.0.0.895

They've been working on this report for hours. It looks REALLY nice. They left their machine on overnight and wanted to carry on with it today.

They can run it, change parameters, re-run it, etc. and everything is working.

When they come to save it (and they've not saved it at all, so no backup - EEK!), they get a series of errors.

Failed to save document.
Failed to save database information.
Database Connector Error: 'The specified object was not saved.'

No matter where they try to save it or if they try to send it if via email using the Send To: option, these errors appear.

No file is saved.



To try and help them, I loaded FileMon to see what was going on. A file IS created, before the first error message. After the last error message, it is deleted. No activity exists on the file between the error messages.

Grabbing the file in between doesn't produce a useful file. Using a hex editor, there is very little useful content.


I have created another report using the same database connection and successfully saved it.


I'm currently left with telling them to start again.

Or is there a way to copy the report to another one?

They've got a LOAD of formulas behind a lot of the group/section/details, so not just the on page elements.

They really are nearly crying.

TIA,

Richard Quadling.
0
Richard Quadling
Asked:
Richard Quadling
  • 4
  • 2
1 Solution
 
BostonMACommented:
So can they create a new report on the same machine and then with both reports open,  copy/paste the fields and formulas from one report to the other?
0
 
Richard QuadlingSenior Software DeverloperAuthor Commented:
There are 24 sections and formulas behind the sections themselves.

But, I suppose that will be better than nothing.

I've got a box of tissues ready.
0
 
Richard QuadlingSenior Software DeverloperAuthor Commented:
You'll be pleased to know she has is copying and saving every click.

As an aside, is there a way to "dump" a crystal report file so it all the formulas are visible?

0
Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

 
BostonMACommented:
Sounds like a good feature, but not one that I know about....
0
 
Richard QuadlingSenior Software DeverloperAuthor Commented:
I use PHP and can automate the reports using COM, I think I can access every element on the report, so I may build one. And if it could do it backwards (take a dump and make an RPT file ...) could be useful.

0
 
mlmccCommented:
Did they happen to try to export it to Crystal Report format?

mlmcc
0
 
Richard QuadlingSenior Software DeverloperAuthor Commented:
They don't know.

When she asked for help, I tried save/save as/export and all got the same error.

I dropped and reconnected and verified the database.

All the usual things.

She says she had no other message.

She has got the report saved now, so she is happy.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now