Hi, Gnana-
I don't know how your data is structured, of course, but it sounds to me like you are trying to print a cross-tab report of your data? Have you looked at the cross-tab wizard to get you started?
>I need to print a monthly purchase report distributed among the weeks(4/5/6 weeks for that month) Format is like
>
>
>Item 1Wk 2Wk 3Wk 4Wk 5Wk& 6Wk (if exists)
>Code (1-2) (3-10) (11-17) (18-24) (25-31)
>
>I001 10 02 03 04 05
>I002 01 03 06 07 04