Skip to Content
avatar image
Former Member

API to Migrate crystal dictionary(dc5) to xml schema

Hi Experts,

I want to make a tool which will convert Crystal 8.5 dictionary file(dc5) to xml schema.

Is there any API available in Crystal SDK, if available then what is the methods and how to call it?

Regards,

Amit

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 23, 2008 at 12:27 PM

    Hi Amit,

    Unfortunately there are no APIs for use with Dictionaries.

    Jason

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Amit,

      There are a few threads about this same issue. There is ABSOLUTELY NO WAY to get the linking info in any of our report engines new and old.

      Here's why:

      We were well aware of the limitations to get the info from our Dictionaries at the time they were deprecated using our SDK's but it was determined it was simply easier to re-build the reports than to create a conversion tool and a new set of API's. The reason is the Dictionary Designer was simply a View designer and could be considered a stand alone application. CR had no direct interaction with the SQL the DD created, we simply waited for the result set to be returned.

      What CR would have to do is create look up tables for ALL databases so we could map their tables and functions to our SQL generator. Of course this would have been a VERY LARGE project which would create all sorts of issues in the future. If the DB driver changed the functionality of the SQL generated we would have to follow. Way too much to manage and impossible to maintain.

      The DIRECT replacement for using DC5's is using the Command Object in CR Designer, again it's a way to directly enter in SQL and CR simply passes that SQL directly to the server to process. Unforetunately for the reason I stated above we have no field and table mapping functions built into CR when using Command objects either if you want to change the report to use the tables directly, so there is no mapping functionality and the reports would have to be re-built.

      Knowing this the Developers did add the ability to copy and paste report objects from one report designer/report to another one that's open.

      Thank you

      Don