R-Tag Documentation and Search allows you to search, compare and generate documentation for your reports. ($749 for 1 user + $99 for each additional user)
#Crystal reports 2013 edit sql query registration#
The initial download will actually work for 3 days and beyond that the free registration is required. The registration Email must come from a business Email address. Report Runner Documentor requires registration but is otherwise free. These standard reports can be exported to most of the export formats supported by CR. The standard reports include a report overview and several cross-reference reports showing which reports use which tables, fields and formulas. You can then run the standard reports or you can connect Crystal Reports to the database to create your own reports (about your reports). You can import individual reports or entire folders which translates the primary report properties into a SQL Server database.
This is a simple tool that has been released for free. But again this has to be generated one report at at time.ģ) Report Runner Documentor by Jeff-Net (Free) So compiling these text files would allow you to search for database information and formula information. Other Formulas (that are physically placed on the report) This is a text document that lists the key settings in the report such as: One of the exports that are available in Crystal is the “Report Definition”. Note that tables linked within the report but not USED in the report will only be included in the SQL if the table bridges the gap between two other tables that are used. But creating and maintaining this document would be time consuming. You could also look for outer joins or specific criteria (like “Customer”.”Dept” =). So if you copy the SQL from each report and put them all in a document you would have a quick way to determine which reports use which tables or database fields. It lists exactly which tables and fields are used by the report. And there is one thing this query does for you that most people miss. It may look awkward (with lots of usually unnecessary quotes and aliases) but it is workable. You can open any report that connects to SQL Based data and view the SQL that the report sends to the database. There are two features in all versions of Crystal Reports that allow you to accomplish (in a rough way) the first of the three challenges mentioned above.ġ.
#Crystal reports 2013 edit sql query trial#
I recommend that you use this review to narrow your search, and then use the free trial before making a decision.įirst lets talk about what you can do for free.
So if you plan to purchase one of these tools, you will want to confirm with the vendor that it will do what you want in a way that works for you. In most cases I have not used these tools so I must rely on the vendor for information. I have also posted a more detailed feature matrix (xls) that shows some of the specifics for comparison, including prices. All of these tools can be found in the LINKS page of my site under RPT Management Utilities.īelow is a brief rundown on the core features of each product as well as what sets each product apart. The more reports you have, the more likely that you will face these challenges, and you can solve problems like these with the tools in this article. 1) Find all the reports that use a particular table, field or calculation?Ģ) Compare two versions of a report to see what was changed?ģ) Make the same change to a group of reports?