There are two possible ways of doing this.
1. Use a command instead of tables. A command is a SQL statement that will run in the database. With the exception of parameters, it will follow the SQL syntax for your database instead of the Crystal formula syntax. You could put an "exists" condition in your where clause to get only the records that you want. Use this if your "Balance" calculation covers multiple records or if you need to look at multiple tables to get the balance.
2. Add a second copy of the table to your report. Crystal will tell you that the table already exists and ask if you want to rename it - click on 'Yes'. You'll see a second copy of the table with '_1' at the end of the name.
- Link from the original table to this one on whatever fields get you to the Group level for your report.
- Set the select formula on the report to only select those records in the original table where the balance is 0.
- On the Database menu, you may need to turn on 'Select Distinct Records'.
- Group on the fields from the original table.
- Use the table with the '_1' alias for your details.
-Dell
IP Logged
