• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 404
  • Last Modified:

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
0
aditya_kulkarni
Asked:
aditya_kulkarni
1 Solution
 
TeongklCommented:
0
 
frodomanCommented:
Teongkl's link should do it for you.

Good luck - from 6 to 9.2 is quite a jump!
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now