>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

---

Hi, Nancy and Gnana.

Nancy, I want to know if Cross-Tab can Shift the empty Column and print leftward
just like Delete line if not print horz.

---

Gnana, back to your question, you'd better to use a LOCAL VIEW to SKIP any unprinted Records!!

If you need to Wk 4 to Wk 6, use a View and add a where clause:

Week >= 4 and Week <= 6

Then, only needed record is filter out to report, and you can print more accurately!! ^_~

Since View allow calculated fields, you can freely add some additional sum up field for report use!!

---

for you beginning question, you can add a report variable with using formula to transform it into different type.

e.g. myDate contains [Date: ] + DTOC(MyView.Inv_Date)
Then, whole myDate is a String Variable!!

but it is impossible to modify the value by report variable to data env. data.
Especially, you want to change the DATATYPE of field..

Only TABLE DESIGNER with Exclusive Access can modify field's datatype.. ~_~

but using View Designer, you can add any new calculated field with above example to change to appro. datatype on use! (;p~ sorry for my poor English!)

^_~ Good luck!