Skip to Content
avatar image
Former Member

Reports & Microsoft SQL Server 2012 Express LocalDB support policy

Hello,

Willing to move some databases into Microsoft SQL Server 2012 (2014) Express LocalDB, I have tryed to map some reports on that database.

Using OLE DB SQL Native Client (v11) and SAP CR RunTime SP10 (>SP9), I still have trouble when using this data source:

After drawing some simple reports (standard ones with 2-3 fields from the database):

- VS designer:

+ when "checking database" or "getting a preview" of the report, it always complains about missing tables.

+ when trying to "re-map" tables from one SQL Server 2012 Express LocalDB to another one it fails, complaining about not findind resources.

- Running application (.NET 4.0, 32 or 64-bits):

+ without any change to the report configuration: CR Viewer complains with multiple error codes (17, ...) that it cannot find the tables

+ trying to change the configured database from the report: CR VIewer complains with some more error codes

=> Is Microsoft SQL Server 2012 Express LocalDB now officially supported by CR ?

=> Is changing datasource/database configuraton during execution now officially supported by CR ?

Feel free to provide an any links / howto's / white paper about how managing Microsoft SQL Server 2012 Express LocalDB with SAP CR ! 😊

Many thanks in advance.

Regards.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Aug 18, 2014 at 05:09 PM

    Hi JP,

    What is the first error code you get?

    Those errors are being reported back directly from SQL Server client/DB. So need details of the error to determine the issue.

    To connect you must use the MS SQL Native 11 client dll.

    Don

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Don Williams

      Ok, now with that rule in mind, I finally get it to work.

      What I understood so far is that LocalDB access through CR does not support the default catalog naming convention of LocalDB (which is the path to the file as we saw it).

      It must be done at least with a named catalog which reference a supported string for the "DatabaseName" in CR. I've also tryed to pass a "slashed" named in order to protect windows separators in the path but CR Viewer still complains with that kind of label.

      This can be done using an alias for the catalog while requesting the attachement of the MDF file (setting an initial catalog name in place of the default one).

      Issue we have when having that kind of restriction is that the catalog name is unique to the instance; an MDF file cannot either be attached to another instance at the same time.

      Therefore, with help of the SQL LocalDB Wrapper - Home, database changes can be done during application run and datasource changes can be then simply propagated to the Crystal Report document (which is now running fine in both scenarios).

      In case of MDF location change, and because of the instance restart requirement to do it, we should also use a named instance in order to isolate the impact only to the application related databases and not dropping other applications / windows system mounted database at the same time.

      Drawback: something/application must be run before the report (or designer) in order to start the LocalDB instance with right parameters (instance name / catalog alias / right MDF file).

      After restarting the user Windows session and/or computer, ServerName=(LocalDB)\xxxx | DBName=zzzz is no more existing. At that step, CR Designer / Viewer will not be able to gain access to the database.

      To resume, there is a solution to make it working ... but this is still not a supported scenario from CR.

      Thank you again for your time and patience.

      Regards,

      Jean-Philippe.

  • Aug 18, 2014 at 05:12 PM

    Looking at the SAP Crystal Reports, Developer Version for Microsoft Visual Studio - Supported Platforms:

    Not sure if that explicitly includes Microsoft SQL Server 2012 (2014) Express LocalDB, but I don't see why not. My suggestion would be to download CR 2013 and see what happens there:

    SME Free Trials | SME Software | SAP

    Being a stand-alone version of CR, it may give us a better error, etc.

    - Ludek

    Senior Support Engineer AGS Product Support, Global Support Center Canada

    Follow us on Twitter


    pastedImage_0.png (16.6 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Ludek,

      I've installed the CR2013 standalone designer and get same issues.

      Screenshots & evidences provided on Don thread.

      Regards,

      Jean-Philippe.