Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1926
  • 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 DeveloperAuthor 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 DeveloperAuthor 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
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
BostonMACommented:
Sounds like a good feature, but not one that I know about....
0
 
Richard QuadlingSenior Software DeveloperAuthor 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 DeveloperAuthor 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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