Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Hiding cross-tab sub headers.... Post Reply Post New Topic
Author Message
rupen
Newbie
Newbie
Avatar

Joined: 08 Mar 2007
Online Status: Offline
Posts: 2
Quote rupen Replybullet Topic: Hiding cross-tab sub headers....
    Posted: 08 Mar 2007 at 10:37am
Posted - 03/06/2007 :  7:25:52 PM  Show%20Profile  Email%20Poster  Edit%20Topic  Send%20rupen%20a%20Yahoo!%20Message  Reply%20with%20Quote

have to print cross tab Monthly through CR 9.
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

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..


Edited by BrianBischof - 08 Mar 2007 at 11:07am
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 08 Mar 2007 at 11:08am
Hmmm... I don't think this is possible. Anyone have some comments?
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
rupen
Newbie
Newbie
Avatar

Joined: 08 Mar 2007
Online Status: Offline
Posts: 2
Quote rupen Replybullet Posted: 09 Mar 2007 at 3:05am

I got below hint...but can not understand...

------------------------------------------------------------------------------

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

------------------------------------------------------
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.