crystal 9.2 - removing "database"."dbo".... from a report Show SQL Query

hi,
I have migrated reports from Crystal6 to crystal 9.2

When I view the queries it shows correct SQL that is without "databasename"."dbo" .
But when I change this query, say adding a sort order in this query, then automatically "databasename"."dbo" is prepended to all table names.

Any way to get rid of this info?

Aditya
aditya_kulkarniAsked:
Who is Participating?
 
frodomanCommented:
Teongkl's link should do it for you.

Good luck - from 6 to 9.2 is quite a jump!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.