Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 531
  • Last Modified:

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?
0
IpZero
Asked:
IpZero
1 Solution
 
CootserCommented:
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

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

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