Crystal 9 - database logon prompt

[Former Member]

Hi,

We have used crystal reports for our invoices the for last 5 years, but recently we have changed the datasource (to another server) to point the reports at. Although we have setup the ODBC manager and set the logon details in the report, the report continues to prompt for the logon from the user. Once entered by the user (which we dont want them to do) it is valid until that session ends, then prompts again.

We want the report not to prompt for the log on at all.

Please help?

Thanks,

Ally

[former_member11696]

Please re-post if this is still an issue to the Legacy Application Development SDKs Forum or purchase a case and have a dedicated support engineer work with you directly

This is the way it should work. For security purposes you don't want anyone to run your reports.

[Former Member]

It could be that the query that is generated by the report still has the old ODBC / connection name

(Database > Show SQL Query)

You could try editing the reports and adding the Overridden Qualified Table Name as follows:

Database menu > Set Datasource Location

Expand the database connection (Yellow)

Then expand the table / view / SP that is the datasource for the table

Click Overridden Qualified Table Name to select (highlight)

Press F2 to edit

Then at the end of the field, type in the name of the table / view / SP

So it would look like this

MyDataConnection
   +Properties
   +MyTable
      -Properties
         Table Name: MyTable
         Table Type:Table
         Owner: MyOwner
         Overridden Qualified Table Name: MyTable

This would mean the the generated SQL query will not have any owner prefix on it

Something like

Select MyField from OldOwner.dbo.Mytable

would end up as

Select MyField from MyTable

When the dbo part is removed the query might be able to operate without looking for a log in

Hope this helps

Patrick

[Former Member]

Hi Pat,

Many thanks for your reply to this, I am very grateful.

I have opened up the database location, but there is no option in the properties to add or amend the Overridden Qualified table name - please can you help?

Thanks,

Ally

[Former Member]

Can you even see Overridden Qualified Table Name?

If you can, then a single click to hightlight and then press F2

Also, what type of database are you connecting to?

I have used CR9 against SQL Server 2000 and now user CR 2008 against Oracle 10g

In both cases i have this option, i thought it was standard but maybe it is not available for all datasources

[Former Member]

using SQL 2005, however there is no property of that value?

Any ideas?

Thanks,

Ally

[Former Member]

I have CR9 and SQL 2005 in another office i can look into it later for you.

In the meantime can you Database > Show SQL query

Copy the query into a New Query Window in SQL 2005 Management Studio and connect to your database

Will the query run in there?

That might offer some hint to the problem, it might rule this out as the problem also

[Former Member]

yes the query works fine, however when I save the report and load it back up, it asks for the datasource logon again - it is only valid when I have crystal open?

Our users access the report via the web and prompts them also for a logon

Any ideas, thanks again

Thanks,

Ally