Crystal Reports

[iambrutus]

Anyone know crystal reports?

I have some reports that are using a trusted database connection, i want to change those to prompt for the login.

anyone know how?

 

[AKAK]

Been a while... but... I'm guessing you're going to have to "rebuild" the report without selecting the "Trusted connection" option.

Short of that... and.. I don't know how easy or hard that would be... sometimes you can curveball Crystal by killing a precoded connection (Say if you're using a FoxPro table... whatever... ) and building a 'custom' ODBC connection that looks just like the one you're using... (or renaming an existing ODBC connection... I don't know... like I said, its been a while... and have no idea what you're connecting to.. and I don't have Crystal handy to poke around anymore)

 

[Mike80]

Anyone know crystal reports?

I have some reports that are using a trusted database connection, i want to change those to prompt for the login.

anyone know how?

Do you mean just prompt for credentials of the user attempting to make the report or going to an entirely different database connection?

If it's the first, you need to go to your Control Panel and then Admin Tools and change the log on based in the ODBC connections category....

If not, you might be rebuilding something.....

My experience in building reports is minimal but I've used it quite a bit.

 

[OCBucksFan]

Hrm... We use it with MS SQL 2K but I believe our permissions for the report are actually set at the database level, meaning there's no prompt but if you don't have access to the tables you can't run the report. I am not 100% sure on that, I would need to ask our DBA's but I believe that's the way since everytime someone gets promoted to manager I need to adjust thier database properties so they can run reports.

 

[iambrutus]

i want the report to ask me so that i can change the database server in the report, without recreating the report, but from what i've found, i dont think it can be done - once that fucking box is checked the only way to "uncheck" it is to rebuild the report

 

[AKAK]

once that fucking box is checked the only way to "uncheck" it is to rebuild the report

That may indeed be the case...

What I wanted to look at (and can't) is whether "trusted" means trusted no matter what kind of connection to your db server would be (in which case you're screwed)... or... just the one you built for the report is trusted... in which case you might be able to rebuild the connection with a little trickeration.

 

[iambrutus]

duh! i removed the server connection from my local odbc connections and then crystal prompted me because it didn't know what to use!

 

[bkochmc]

Hrm... We use it with MS SQL 2K but I believe our permissions for the report are actually set at the database level, meaning there's no prompt but if you don't have access to the tables you can't run the report. I am not 100% sure on that, I would need to ask our DBA's but I believe that's the way since everytime someone gets promoted to manager I need to adjust thier database properties so they can run reports.

You would be correct. If the user doesn't have permissions to access a table in the report then the report will fail... most likely an error message stating the user does not have permissions will be returned.