aditya_kulkarni
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Good luck - from 6 to 9.2 is quite a jump!