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

Posted on 2008-11-14
Last Modified: 2013-12-25
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?
Question by:IpZero
    1 Comment
    LVL 3

    Accepted Solution


    I am pretty sure that if you go to

    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


    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
    This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now