View Single Post
 
Old March 6th, 2007, 03:25 PM
rupen rupen is offline
Registered User
Points: 1,897, Level: 17
Points: 1,897, Level: 17 Points: 1,897, Level: 17 Points: 1,897, Level: 17
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Apr 2005
Location: Mumbai, Maharastra, India.
Posts: 352
Thanks: 14
Thanked 0 Times in 0 Posts
Send a message via Yahoo to rupen
Default Hiding sub headers....

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.