Default viewing behavior (database)

server administration XI Server Discussion
1

I will be releasing a lot of reports into our production environment in the upcoming months. We use .biar files to move content that was tested in DEV into testing environments and then PROD. Developers build and test in DEV. The reports are put in a .biar file and imported into a test environment. If they pass, that same .biar file is imported into PROD. If they don’t pass testing, they go back to DEV. Ultimately, all of the report code needs to be set in DEV.

Once I release reports into a new environment, I have to go into each reports Process–>Database area and change “prompt the user for database logon” to “Use the same database logon as when report is run” for viewing. Is there a relatively easy way (edit xml, change a registry value, etc) so that the default behavior is to use the same database logon as when a report is run rather than having to manually change that?

This is XIR2 SP5 on Solaris with Tomcat.

dcartwright (BOB member since 2008-11-01)

2

This seems strange to me, what type of reports are they?

Are you exporting the connections as well… :?

I wouldn’t be using the same BIAR, I would be going:-

Dev–>BIAR–>Test—>BIAR–>Prod

Mak 1 :uk: (BOB member since 2005-01-06)

3

It’s strange to me as well and not what I would recommend, but it’s also the process I’ve got to live with. It’s how they manage code for their other applications. They’re Crystal Reports that run through a universe to get their data–also not my first choice. :slight_smile:

dcartwright (BOB member since 2008-11-01)

4

Ah, they are Crystal…

Not my bag, but try a search, I’m sure I have seen this discussed before.

I think you can set something in the CMC, the upgrade path seems a bit iffy IMO…:).

Mak 1 :uk: (BOB member since 2005-01-06)