Skip to Content
author's profile photo Former Member
Former Member

Export Report Definition - output incomplete (CR 2008 v 12.3.0.601)

Hey there,

So I have a bunch of Crystal reports which are getting data from a soon-to-be deprecated backend system. What I'd like to do is change field definitions to the new system. Unfortunately, the mapping for some field definitions from the old system to the new system is somewhat murky. That is, say there is a field in the old system called foo_bar, in the new system it might be called foo, bar, foobar, or it may not exist entirely. Since there will be multiple people working on this, I wanted to create a list for the team to use to refer to so when they're ready to convert a report, they can just open up this list and know what the mapping is (so for example, they can open up the list, find Report2, and know that foo_bar maps to foo).

I hope that background info helps to understand the following problem: some of these reports are HUGE, like 200 fields and such. Rather than waste time typing out each field into the list, I decided to make use of the Export -> Export Report -> Report Definition option, which in conjunction with another program, will make a nice CSV list of the field defs used in any particular report. The problem is, however, that the report file that Crystal generates is incomplete! For example, if I have a field called foo_bar2 in the report (and IS being used), it simply doesn't come out in the Reports Definition file. I can't figure out what logic it uses do decide which fields export and which don't, it just seems random! There is no set of preferences associated with that report either, so nothing is set wrong. It's hugely annoying since it's cutting into my time savings - for each report, while I don't have to sit there and type out all the fields (thankfully), I still have to verify that Crystal spit out all the necessary fields (and in some cases, add missing fields)!

Anybody know what's going on? Any help would be greatly appreciated!

Message was edited by: Jugal Shah (added version number to title)

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Jun 11, 2012 at 02:46 PM

    See if this KB helps to explain the behavior. Note that the KB discusses formulas, but would apply to fields also. E.g.; fields in suppressed sections, unused fields, etc. (I actually found an enhancement request for fields). Looking at the ADAPT in the KB and the enhancement for fields, leads me to the conclusion that this enhancement has not been done and chances of it ever being done are pretty slim after being on the books for 4 + years...

    - Ludek

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.