have to print cross tab Monthly through CR.
e.g.
      ------------------------------
      | Week 1 | Week 2 | Week3 | <-- Main Heading
      |Pro1|Pro2|Pro1|Pro2|Pro1|Pro2| <-- Sub Heading
---------------------------------------
Sales | 23 | 34 | 23 | 45 | 12 | 56 | <-- Main Data

Now, my question:
How do i hide Pro2 sub heading if there is no data in perticular Month?
Say for a Month Prod2 is not sold it shoud subpress Pro2.

OR

May for a Month 1st and 2nd week no sale for prod1 but it has sale in week 3, so we have to supress heading & data for prod1 in week 1 and 2, it should look like..
      ------------------------------
      | Week 1 | Week 2 | Week3 | <-- Main Heading
      |Pro2 | Pro2 |Pro1|Pro2| <-- Sub Heading
---------------------------------------
Sales |34 | 45 | 12 | 56 | <-- Main Data

Any idea....
Thanks in advance..

Rupen Anjaria.:)
------------------
We CAN'T avoid problems, but can solve it.

create a formula which gets the count of details for each sub category.
then
right click the sub heading and near supress section enter the following
evaluateafter(ur count formula name goes her)
ur variable name goes here = 0

Thaks,,,i do have some hope now...
If we divide this in 2 parts viz. 1)Creating Formula & 2)applying to subheading, I afraid to say m confuse in first part.

In my report either field will return NULL or a value.(if it has value it should be printed)

Please give a sample formula (CR syntax or Basic Syntax).

Thanks in advance.

Rupen Anjaria.:)
------------------
We CAN'T avoid problems, but can solve it.

give me ur email me the report with save data i can work on it

(Great Thanks...but My company's IT policy wont allow it but will try to send it from some outside PC..I m so poor to have my own..)
(Say if week number is 3 then only we have to show sub heading)
if i right click the heading and under Supress option, if i write some condition which checks for week number
e.g.
------------------
if dbRecord.Week = 3 then false else true
------------------
I guess supress = true mean hide and vice-versa....right?

Should it work, currently it is not working w/t this formula, it always evaluates as "flase".


Many Thanks..


Rupen Anjaria.:)
------------------
We CAN'T avoid problems, but can solve it.

yes. i think that will work

Works for me to...

Thanks for your help!