>i have a balance table with fields: empno, effectdate, vl, sl
>
>i have a report with columns from jan to june, 2 columns for vl and sl under each month..
>
>effectdate in balance table are dates from jan-jun (mm/yyyy).
>
>any idea on how can i create a report with this kind of layout?
I'm not sure I understood:)
Under each vl,sl column create the same expression (empno ? vl-sl?). In 'print when' of them enter something like :
month(effectdate=1) && For vl-sl under Jan column
Cetin