WebJan 21, 2002 · You can only have 1 recordset per report or subreport. You will have to either combine the 2 recordsets into one before the data is passed to the report, or create a subreport and pass the first recordset to the main report and the second recordset to the subreport. you can use UNION in your SQL statement to append them to each other. WebMar 29, 2010 · 2. Using the wrong ODBC driver. ODBC drivers are how Crystal Reports attaches to the database. There is usually a variety of ODBC drivers which will work for any particular make of database and some are better than others. The only way to really test this is to run the report with all the suitable ODBC drivers and see which is the most efficient.
How to increase the performance of Crystal Reports.
WebJan 17, 2002 · Crystal Professional 8.5. I'm doing a weekly commission report. I am using running totals to calculate a commission amount. I would like to summarize or sub total this commission calculation by salesrep and district. This formula field (commission) is not showing up in my report field options when I try to run a summary of this field. Webthe parent report tables/field – Great for showing related detail in various ways. Unlinked sub-report Unrelated objects not linked. Linked sub-report ... Tips and Tricks Ensure the crystal report’s database data link is up to date. Tips and Tricks Ensure the table links are valid. Tips and Tricks Working with NULL or blank values. ct gov job search
Crystal report taking lot of time to run - Stack Overflow
WebJul 28, 2016 · 1. Use a Stored Procedure: running your Crystal Report based off a stored procedure will improve speed by the simple... 2. Avoid Using Formulas or Crystal … WebTips and Tricks: Crystal reports Printing To print Crystal reports (which includes both Print to Screen and Print PDF file to Screen), you must have the free Adobe® Reader® … WebCrystal Reports Tips and Tricks 1/12 Part 1 - YouTube Presenter : Justin Hill1. Testing for NULL2. Breaking a page for each Group3. Offloading selection logic into separate formulas Presenter :... earth from mars rover