Scroll down the driver list to Microsoft Access Driver (*.mdb), select it and click the Finish button. On the User DSN tab, click the Add button. (you can get to the ODBC Administrator quickly from Start > type ODBC in the Search) Once you have the file saved, open the ODBC Administrator and create a New Data Source. (You won't ever actually open this file, but just connect to it.) If you don't have one, google for a sample mdb file and download it, saving it with a name and location you can remember. I placed mine with the path C:\A_test\test.mdb to make it easy to find. mdb file saved in a simple location will suffice. If you don't already have a Data Source on your computer set up that you can connect to, you will need to build one first.Ī simple Microsoft Access. This allows advanced SQL functions to be utilized. When a Crystal Report is based on a record set that is too complex for the table linking functionality within Crystal Reports, the report can instead be based on a SQL Query, usually developed/tested in another editor tool and pasted into the command. Why does a report use a command? Doesn't Crystal Reports have the ability to link tables? 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. 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. 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. 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. Now the Crystal Reports report file is ready to be used in your application.I know that this is an old thread, but I encountered this same problem. RPT report file into your application folder. RPT report file in the Visual Studio Solution Explorer (shown as CrystalReport.rpt in the example below). Step 6: Configure the Crystal Reports report. Step 4: Select “Crystal Report” and specify the file name of the report file. Step 3: Right-click “C:\.\WebSite1\” and select “Add New Item”. Step 1: In Visual Studio 2005, select New à File àWeb Site. Since Visual Studio 2005 does not come with the Crystal Reports application development tool, you must create Crystal Reports report files with Visual Studio 2005 by following these steps: For Crystal Reports XI Release 2, we recommend using Crystal Reports itself to create Crystal Reports report files instead of Visual Studio.Ĭrystal Reports 10 comes with Visual Studio 2005. This may conflict with the DLLs within the application’s \bin folder. When Crystal Reports files are created using Visual Studio 2005, Visual Studio 2005 embeds the Crystal Reports assembly information in your application’s Web.config file. Creating a Crystal Reports Report File Creating a Crystal Reports Report File
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |