Dear Crystal Gurus,

I created a project income/expenditure account for all projects. All project transactions are recorded in our project journal on a transactional basis so the report groups all income and expenditure transactions by project number. In order to be able to select between active/inactive/all projects within a certain period, i created a new parameter/Flag with the three respective options.

As the condition for a project to be active/inactive is formula based, i created a subreport for each case and supressed the respective  footer sections based on which flag is selected. (My subreports are in the footer section)

In each of the subreports, the unwanted data is supressed i.e. in the active subreport, the inactive projects are supressed and vice versa. The problem arises in the running total field. I would like to sum up the the totals from the subreports. However, the criteria defining an active and inactive project, is a formula that derives some of its data from an existing running total field and hence cannot be selected as a field/formula for a new running total field. I'm guessing the reason for this would be a similar case to a circular reference in excel.

How would i best solve this? Is it possible to use a formula to declare what an active/inactive project is and using a true/false flag evaluate in the running totals field?

Your assistance is highly appreciated.

regards,
cb

Thanks for the tip. Do you happen to know where i can write the sql expressions in crystal and how i can run it?