Using Command Object causes database Logon prompt?

[bluecjh]

Crystal and BOE XI

Help please!

When viewing a report which uses an SQL 'Command' object users are prompted to login to the 'database source'.

A report which does not use a 'command' object will not
cause this prompt.

I can hard code a login for the 'connection in 'Business Views' (this is impractical) I want Windows Authenticated users not to have to login, how can i engineer this?

grateful for any help?



BlueCJH

 

[Wholsea]

Are you updating the database information in the CMC?

You should be able to set the database source and password for the report in the CMC so the user will not be required to submit a username and password to review the report.

(Near the submit button there should be a checkbox that says "Use same database logon as when report is run", just make sure this option is checked, otherwise the user will be prompted...)

ASP, VB, VBS, Cold Fusion, SQL, DTS, T-SQL, PL-SQL, IBM-MQ, Crystal Reports, Crystal Enterprise

 

[bluecjh]

Wholesea,
Yes I'm using the CMC. When i look at all the usual
reports (which work fine and we have many) they are all set by default to 'prompt user for database logon'

but they are never actually prompted??

In the case of this problem report (with a Commmand object)
if i set the flag in CMC to 'use same database logon as when report is run'

they either get prompted for a database logon
or they get an error message
'list of values failure, failure to get values'
?


BlueCJH

 

[Wholsea]

The list of values failure/failure to get values sounds like a query problem. I am assuming you are able to run the report in developer with no problems?

ASP, VB, VBS, Cold Fusion, SQL, DTS, T-SQL, PL-SQL, IBM-MQ, Crystal Reports, Crystal Enterprise

 

[Wholsea]

Also, is there more than one data source listed on the databas properties window? If so, you need to make sure the username/password is defined for all of them...

ASP, VB, VBS, Cold Fusion, SQL, DTS, T-SQL, PL-SQL, IBM-MQ, Crystal Reports, Crystal Enterprise

 

[bluecjh]

Well it runs fine in Cystal Reports XI.

It would seem as if some how i have to get the 'connection' for the list of values to 'use same logon as when report is run' i just don't know how to do this?

the data source listed in the 'database' in CMC is as
per other reports, it lists the server and Database but User and Password are blank, this is usual.



BlueCJH

 

[Wholsea]

Try to input the usrname and password for the database in those blank fields and re-submit the report.

Make sure the 'use same database logon as when report is run' option.

ASP, VB, VBS, Cold Fusion, SQL, DTS, T-SQL, PL-SQL, IBM-MQ, Crystal Reports, Crystal Enterprise

 

[bluecjh]

but if i hard code my windows authentication
won't i have to keep updating it? isn't that
a bad idea?

BlueCJH

 

[bluecjh]

still get error message, yet if i go into
Business Views and edit the connection for the 'list of values' and set the user/password it works fine.

But again surely this is a bad idea, this changes all the time?



BlueCJH

 

[bluecjh]

I mean if SQL Server is set to Windows Authentication
then I'm stuck?

Help! :-(

BlueCJH

 

[Wholsea]

Honestly, I'm not sure abotu this one.

In our environment, our reports are generated with a generic "Read only" database user that is statically hard-coded in the CMC...

ASP, VB, VBS, Cold Fusion, SQL, DTS, T-SQL, PL-SQL, IBM-MQ, Crystal Reports, Crystal Enterprise

 

[Wholsea]

And it was for the reason you states specifically that we did it that way (So we don't have to constantly change the database connectivity information)

Its either you create a generic account, or require your users to log in every time they want to run the report...

Unless someone else has an idea...

ASP, VB, VBS, Cold Fusion, SQL, DTS, T-SQL, PL-SQL, IBM-MQ, Crystal Reports, Crystal Enterprise

 

[bluecjh]

Wholsea,

Maybe this is it. IN 'Business View' if you double click the connection for the 'list of values'/command then there is an option 'use single sign on when viewing'. according to the help:


"If, instead, you choose to enable Single Sign On, you configure the Data Connection to log on to the data source with the BusinessObjects Enterprise logon credentials of the users who try to view the report. If the users are successfully logged on to BusinessObjects Enterprise, they will not be prompted to log on to the data source when they click to view the report."

So I guess that if you have implemented Windows Authentication against Business objects (assuming that's possible) then your home and dry.

They don't make it easy do they?

BlueCJH