Skip to Content
author's profile photo Former Member
Former Member

Crystal reports 7 report with Crystal for VS 2013

When using an old Crystal reports 7 report within a new Visual studio project and Crystal reports For VS 2013, we are not able to change the data source no matter what we try. We removed parameters from the report and cleared all the check boxes related to saving data with the report without success. The report always displays the data that the original SQL query retrieves. The data set we provide through the code has no effect whatsoever. There is no way, as was previously possible, to change the SQL query directly.

The query in question accesses 10 tables and we provide a single data set with the result stored in a single table object. Attempting to change the table object name to one of the database table names causes the application to hang.

Any ideas?

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jan 08, 2016 at 12:19 AM

    Hi Yaron

    My prefered way to test these reports would be to see if they work in the CRystal Reports 2013 9v. 14.1.x) designer before provceeding to work with the report in a .NET app. An eval of CR 2013 designer can be downloaded from here:

    SME Free Trials | SME Software | SAP

    However as Brian mentioned, doing such a huge version skip update may be quite futile...

    - Ludek

    Senior Support Engineer AGS Product Support, Global Support Center Canada

    Follow me on Twitter

    Got Enhancement ideas? Use the SAP Idea Place

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 07, 2016 at 05:11 PM

    Hi Yaron,

    That is a huge jump from 7 to 13 and the possibility of it working are pretty small but maybe not impossible. The database engine has changed a lot between those versions and I believe that is part of the problem.

    A couple of things you can try but I'm not sure if it will help:

    1) Make sure Save Data with Report is not set in the report. This is a common reason why reports keep returning the same records, even after the dataset is changed.

    2) If you have a stand alone version of Crystal Reports, any version other than the Visual Studio version, open the report in there and try to change the tables and resave the report.

    3) Make a gradual upgrade of the report to accommodate the in between versions. Go from 7 to 9, 9 to XI, XI to 13. This is a bit more difficult because you'd have to have those versions.

    4) Make sure you have verified the database in the report. That usually fixes most issues but I'm skeptical about that too.

    Good luck,

    Brian

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.