Skip to Content
avatar image
Former Member

Automatically assign db logon to DC, DF, BE, BV or LOV

Hello

Crystal Reports Server 2008 (XI3.0)

I am able to upload Crystal Reports (2008 Dev) reports to the BO repository in 3 ways:

a.) File > Save As from CR Dev

b.) Publishing Wizard (on the server)

c.) CMC > Add reports to a folder

When the reports are uploaded I can then enter database logon credentials for the reports.

But...

When I try to run the report in Infoview it looks for a database logon and password.

When the reports are uploaded a Data Connection, Data Foundation, Business Element, Business View and LOV are all automatically created.

(I can see these in Business View Manager)

These represent the parameters in the report. (The report parameters lists are SQL Commands in each report)

These objects do not have database logon info when created during the report upload.

I believe that what is happening is that when the report is run it must log on to the DB to load data into the LOV

At the moment to configure the db logon info for these objects (DC, DF, BE, BV or LOV) i need to edit the properties of each DC and load in the DB username and password.

Is there any way that i can configure the db logon info for all data connections at once?

Best regards

Patrick

Edited by: PATRICK COOTE on Sep 5, 2008 10:11 AM

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 08, 2008 at 09:59 PM

    Patrick,

    As you have noticed, whenever you publish a report that contains Dynamic prompts that were created within the report a BV and it's dependancies is created. The Data Connection is getting it's information from the report. Therefore I would recommend creating the LOVs within the Business View Manager itself. This will save you much administration time and headache as you can create 1 data connection per database server, fill in the connection info and set it to never prompt, use it for as many data foundations as you wish and reuse the data foundation, elements, and BVx rather than having a new one created everytime you publish a report with Dynamic prompts.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Will

      Thank you very much for your help in this.

      Now I, at least, know what direction to take and have not replied sooner because i have been trying to get my head around Java, because i think the best approach is a program to update the connections

      Also, the pointer on how to access the Query Builder from AdminTools has been very helpful

      Again, thanks for the help man, much appreciated

      Patrick