I have a report from Crystal Reports that is a statement run, i.e. prints hundreds of statements.
However, many statements have a zero opening balance and zero transactions, so I would like to filter them using the Select option.
I have tried to Select Group, and I can filter on the opening balance, but I cannot filter on the formula field that checks if have any transactions.
I understand the reason, because the formula is calculated after the select process.
Other than rewriting the stored procedure that initially collects the data to filter the dataset, is there anyway to achieve this in Crystal Reports?