Skip to Content
avatar image
Former Member

Crystal Reports 10 and multiple Databases

Hi,

I have a report that I built with 1 database source, now I must give this report to many clients, all with different Database names, but same tables names, now the problem is that all my report is stick to a unique DB (ie: Database.dbo.TableN), now in older versions I was able to delete de database.dbo string, so the report would work on any DB, now I cant find this option nor can edit it. Is there a new way to do it?

I'm calling the report from an application built in VB6.

I'm using the Crystl32.ocx not RDC.

Thanks in advice.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 09, 2008 at 06:26 PM

    ok, thanks for the support, but I still have a question, and is that even if I use the RDC method, how could I use the same report on different database names?

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 02, 2008 at 03:55 PM

    Can you confirm you are using CR 10? The Crystl32.ocx last shipped with CR 8.5...

    Ludek

    Add comment
    10|10000 characters needed characters exceeded

    • well, CR 10 does not ship with crystl32.ocx and before we even get to square one, I must know what SDK you are using. Download the modules utility from here:

      https://smpdl.sap-ag.de/~sapidp/012002523100006252802008E/modules.zip

      Run your app and get a report processed. Do not close the app and start modules. Go to the File menu, select New list -> memory modules.

      Then expand the "By process" node. Find your app exe, click on it. The go to the View menu and select Details. You should be able to see all the dlls the app is loading, including the Crystal reports dlls. What version are these dlls and what directory are they loading from?

      Ludek

  • avatar image
    Former Member
    Sep 10, 2008 at 07:36 PM

    ok man, thanks for the support and info. I'll try to use that RDC for my problem, seems that is the only way to do it.

    Add comment
    10|10000 characters needed characters exceeded