Watch three easy but important tips to improve your Crystal Reports Subreport development. Start your Crystal Reports Online Training today and watch more training videos!
Grouping with Specified Order
The Specified Order option lets you pre-set the order the groups are printed on your report. We walk through an example of how to use the Specified Order option and customize the group names. Get Flash to see this player.
Using an Array in a Subreport For Hidden Calculations – Part 3 of 3
This is part 3 of a 3 part video. In this video, you see how to use a subreport to populate an array with data and the array is then printed on the main report. The subreport is hidden so that the user never sees the how the calculations are derived behind the scenes. Get […]
Using Arrays to Prevent Duplicate Data – Part 2 of 3
This is part 2 of a 3 part video. In this video, you see how to only print unique values in a set of data. Thus, you are preventing duplicate data from printing. It uses an array to track the data that has already been printed. Before a new element is printed, a formula first […]
Add Parameters Walk Through
Using Parameters in Crystal Reports allows developers to create reports in which users can dynamically filter the results. We will create a parameter and then use that parameter to select the records to display in the report. We will start with a simple list from the Orders table. The Orders table is also linked to […]
Conditionally Suppressing Group Footers
In the last article, we created an Expense Report grouped by cost center using the “Specified Order” option in the Group Expert to change the order and group names (002-Direct, 001- Reimbursable, 003-Non-Reimbursable). Now, we will take a look at using Running Totals and conditional suppression of sections to display different subtotals. For this report, […]
Tips for Using Specified Order of Groups
In Crystal Reports, using the Group Expert can help you do much more than just organizing the data on the page. Grouping in reports provides powerful functionality to allow report developers to order, display, aggregate, and transform data displayed in reports. The “Specified Order” functionality can be used in several different ways to affect the […]
Crystal Reports Online Resources
When you are surfing the web looking for more information about Crystal Reports, here is a list of my favorite Crystal Reports bookmarks. While the following list certainly isn’t comprehensive, this gives you ample resources to learn more tips and tricks about Crystal Reports. I have a question for you: What are your favorite Crystal […]
Designing a Simple Reports Using Command Objects – Part 2
In the previous post, we looked at the Command Object and how it works. In this second part, we’ll look at how to add parameters to the Command object and how to use it in your reports. Before you create/Add a command, you should be logged on to the database that the command will be […]
Designing a Simple Report Using Command Objects – Part 1
The typical report uses the database expert to select which database tables to print from and link them together. Behind the scenes, the database expert creates the SQL statements that are used to query the database server and return the data to your report for printing. Did you know that Crystal Reports also lets you […]
