![crystal reports 2013 connecting to a sql database file crystal reports 2013 connecting to a sql database file](https://blogs.sap.com/wp-content/uploads/2013/05/database_expert_217129.png)
In essence, the dialog box has to be satisfied before it will show the SQL, so we fool it with a legitimate Data Source, just not one that would work with the SQL that is actually in the SQL Command. This is a workaround ONLY to allow you to see the SQL of a Command that a Crystal Report is based on, when you don't have the underlying database connection that the report is based on.
![crystal reports 2013 connecting to a sql database file crystal reports 2013 connecting to a sql database file](https://cdn.4uc.org/gmzo/468/8900341/download/images/gmz8341x63965zimage001.png)
This is common when dealing with example reports of functionality you wish to mimic. There are times you have just the report file, but not the associated database structure that the report uses. Viewing the SQL of a Command in a Crystal Report File (I can give more details if it helps in any way.) As long as you don't try to actually run the report (and only show the SQL) the operation wont fail. When running the 'Show SQL' option point the report to this datasource. it is some kind of valid datasource this it works fine). As long as the connection to the datasource works (i.e. If you don't have access to the original data source, just create a new 'blank' datasource (such as an ODBC connection). We experienced the same problem, but the solution is actually pretty simple.
#CRYSTAL REPORTS 2013 CONNECTING TO A SQL DATABASE FILE CODE#
So instead our plan was just to extract the SQL code generated by the report and forward that on. Likewise we can't run it as we don't even have the database set up anywhere.
![crystal reports 2013 connecting to a sql database file crystal reports 2013 connecting to a sql database file](https://www.netiq.com/documentation/noc50/sql_views/graphics/sql_crystalrep_dbexpert_new_a.png)
Effectively we used to have a database/application that has since been aquired by an external agency.Īlthough they now have the database/application they don't have access to crystal reports, so we can't just send them the old report that we used to run. I know that this is an old thread, but I encountered this same problem.