I have a crystal 9 report that displays 7 row #'s and 1 column #. When I run this report, it only displays data for one employee even though more than one row is read from the database. I went into Cross-tab expert, Customize Style and un-checked the Suppress Column Grand Totals check mark. When I went back into the Preview, all rows were displayed. If I re-run the report, again I only get one row. Why is this happening ? This report worked before, one small change has been made to the Select Expert formula and now it doesn't work. Is there such thing as Refresh cross-tab or something similar to that ?

{VIEW_EMPLOYEE_BALANCE.BAL_NAME} in ["CALL BACK BANK", "OVERTIME/LIEU BANK", "PAID HOLIDAY BANK", "VACATION BANK"] and
{EMPLOYEE.EMP_STATUS} in ["A", "L", "S"] and
{EMPLOYEE.EMP_VAL2} = "47" - added new

What I don't understand is that when I go into the cross-tab expert and uncheck suppressing of one of the totals, click ok and then go back into the preview all data is showing correctly in the cross-tab. 8 pages in total not just one employee.

The statement was correct, they are just narrowing down the data to get certain benefit program. This is a huge time keeping database, they store data in generic pre-existing fields, EMP_VAL2 etc. I thought it had something to do with the cross-tab.