How to stop the prompt of database username and password?

system · February 2, 2011, 12:08pm

Hi

I have created a report using Crystal reports 2008. Inside of the SQL I used parameter (Date). When I upload it to the Business Objects and try to view it in the InfoView it prompts database username and password.
I have already set “Use same database logon as when report is run” in the “Database configuration”. More, other reports (SQL doesn’t include any parameter) don’t prompt database username and password

Thanks in advance,
Elshan

serifelsen (BOB member since 2011-01-24)

system · February 2, 2011, 7:34pm

Go to the Object in CMC and check the settings of Database Options for this object.

Choose the appropriate options and Click ‘Update’, next time when you run it should not prompt for the user and passwd.

BO_Chief (BOB member since 2004-06-06)

system · February 2, 2011, 10:57pm

Are you talking about the fact that you’ve already set the database username and password and you make a change, re-save the report and it loses it? If so, then you need to go to (in XI 3.x) the report object and right-click and choose ‘Refresh Options’. In here, untick the option to refresh default database username/password and then click Update.

chesl73 (BOB member since 2008-05-15)

system · February 3, 2011, 8:05am

I did everything as You said but still does not work. More i have dynamic parameters in the report. I am using them to filter data.

serifelsen (BOB member since 2011-01-24)

system · February 3, 2011, 8:32pm

I had a similar problem. Here is what resolved it for me. Hopefully it will work out for you too-

Go to Database Configuration
Select Use custom database logon information specified here
Select your database driver type
Provide credentials
Use default table prefix
Select Use same database logon as when report is run

Abhi719 (BOB member since 2010-12-10)

system · February 4, 2011, 5:27am

Does not work. :x

serifelsen (BOB member since 2011-01-24)

system · February 4, 2011, 4:32pm

I think you need to select specify a custom driver - click the checkbox and select the default value. It will be something like - crdb_xml

Abhi719 (BOB member since 2010-12-10)

system · February 4, 2011, 9:49pm

Dynamic Parameters use Business Views that need to be Managed using the Thick-Client BUSINESS VIEW MANAGER.

Search this site for BUSINESS VIEW MANAGER and Dynamic Parameters…all the info is there.

The current method of handling Dynamic Parameters in BO Enterprise (even in the new 4.0) is fugly, and I advise clients to avoid them wherever possible.

There is supposed to be a “magical” fix where Business View features are rolled-in to the new COMMON SEMANTIC LAYER in some future 4.x release - but it’s been on the “coming soon” list for at least 5+ years.

MJRBIM (BOB member since 2007-03-23)

system · February 7, 2011, 7:38am

I don’t have BUSINESS VIEW MANAGER

serifelsen (BOB member since 2011-01-24)

system · February 7, 2011, 12:29pm

It’s on the “Client Tools” install package that you can download from SAP for your version of BOE.

MJRBIM (BOB member since 2007-03-23)

system · December 20, 2012, 7:35pm

Is there a way to choose “Use same database logon as when report is run” as a default option for all reports?

Marfi (BOB member since 2006-12-18)

system · August 11, 2015, 7:42am

You can use …Dynamic Login to Crystal Reports

Brian

brianmanee (BOB member since 2015-08-11)

system · August 13, 2015, 6:47am

in CMC you can set username and password so that it won’t ask again and again when you run the report… instead of using your user details use some generic which will be helpful to entire organization… as default uid/pwd…

surya.g (BOB member since 2009-11-24)