Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 403
  • 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

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

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