Crosstab Rows Are Not Appearing If There Is No Info in the Sum Field

[sprog]

Hi

I am struggling with this one and cannot get my report finished.

I have a crosstab where my row names come from a formula, splitting payment types into six areas, (ie; Wages, Annual Leave, Sick Leave, Training etc)
My columns along the top are pay period dates.

I need these six rows to appear everytime I run my report.
If there has never been any sick leave (for example), this row completely drops out of my report and then only gives me 5 rows of information.

I need the 6 rows to stay there, and if there is no dollar figure in the summarised field, then leave the cell empty or with a zero dollar figure.

Any help would be appreciated a.s.a.p.

Thanks

 

[kenhamady]

Unfortunately, Cross-tabs dont work that way. It doesn't know what rows you want. It only knows what rows exist for each group, and that is what it prints. You could do a manual cross-tab, but you would have to hard code every cell in the cross-tab to have all of the rows stay in place when they are empty.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com