Technical Questions: Hiding cross-tab sub headers....

Print Page | Close Window

Hiding cross-tab sub headers....

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=295
Printed Date: 07 May 2024 at 3:51pm

Topic: Hiding cross-tab sub headers....

Posted By: rupen
Subject: Hiding cross-tab sub headers....
Date Posted: 08 Mar 2007 at 10:37am

Posted - 03/06/2007 : 7:25:52 PM http://p2p.wrox.com/pop_profile.asp?mode=display&id=30437">

javascript:openWindow%28pop_mail.asp?id=30437%29">

http://p2p.wrox.com/post.asp?method=EditTopic&REPLY_ID=57292&TOPIC_ID=57292&FORUM_ID=109">

http://edit.yahoo.com/config/send_webmesg?.target=rupen%5Fa%40yahoo%2Ecom&.src=pg">

http://p2p.wrox.com/post.asp?method=TopicQuote&TOPIC_ID=57292&FORUM_ID=109">

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

Replies:

Posted By: BrianBischof
Date 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>

Posted By: rupen
Date 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

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

Print Page | Close Window