how to edit Show Sql Query option in Crystal Reports 9.0.because i want to delete the database name in sql query.

Im sure DataBase Experts can help u.
keep in touch.

Always:),
Hovik Melkomian.

what exactly are you trying to achieve by deleting the database name?

Hi, I wanna know if you did get a solution for this? Can the database name be edited at all in Crystal Reports 9? I have checked all the options to see if the Save report with Data is selected, but it isnt the case. The database name that the SQL query is pointing to is not there in History/ Favourites Database Connections either.
Thnx,
Tarini

Hi, I am also facing the same problem. I need to delete the Server name and database name from the report. Before in Crystal 8 there was an option like you can delete it from the SetLocation option. I need to delete the [DatabaseName].[dbo]part from [DatabaseName].[dbo].[StoredProcedureName] as my application may contact different server and databasenames in different location according to the settings in a .ini file. Do anyone have a solution for deleting this or making the report independant of a particular DBName or making it change dynamically?

Warm Regards,
Deepu Sreedhar