How to replace subreport's "database"."dbo"

I have migrated from Crystal Reports 8.5 to XI. Migrated subreports work OK. But when I add a new subreport then "database"."dbo" is added to FROM part of the sql statement. How to get rid of these? Or how to replace then with correct db?
IpZeroAsked:
Who is Participating?
 
CootserConnect With a Mentor Commented:
Hello

I am pretty sure that if you go to

Database
Set Datasource Location
Then expand until you find the Overridden Qualified Table Name for your table (the subreports are usually at the end of the list)
If you highlight and then press F2 you can edit this.

Type in the exact table name

That will usually remove the database.dbo bit from the query

Best regards

Cootser
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.