Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > Crystal Reports
| Search | Today's Posts | Mark Forums Read
Crystal Reports General discussion about Crystal Reports. For discussions specific to the book Professional Crystal Reports for VS.NET, please see the book discussion forum for that book.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Crystal Reports section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old March 6th, 2007, 03:25 PM
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.
  #2 (permalink)  
Old March 6th, 2007, 03:36 PM
Authorized User
 
Join Date: Dec 2004
Location: flushing, ny, USA.
Posts: 80
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
  #3 (permalink)  
Old March 8th, 2007, 09:26 AM
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

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.
  #4 (permalink)  
Old March 23rd, 2007, 03:05 PM
Authorized User
 
Join Date: Dec 2004
Location: flushing, ny, USA.
Posts: 80
Thanks: 0
Thanked 0 Times in 0 Posts
Default

give me ur email me the report with save data i can work on it
  #5 (permalink)  
Old March 23rd, 2007, 03:21 PM
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

(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.
  #6 (permalink)  
Old March 23rd, 2007, 03:43 PM
Authorized User
 
Join Date: Dec 2004
Location: flushing, ny, USA.
Posts: 80
Thanks: 0
Thanked 0 Times in 0 Posts
Default

yes. i think that will work
  #7 (permalink)  
Old May 14th, 2007, 04:56 AM
Registered User
 
Join Date: May 2007
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Works for me to...

Thanks for your help!



Similar Threads
Thread Thread Starter Forum Replies Last Post
CheckBoxList Headers Ric_H C# 0 June 26th, 2006 10:29 AM
"headers already sent" - one cure tks001 BOOK: Beginning PHP5, Apache, and MySQL Web Development ISBN: 978-0-7645-7966-0 1 February 20th, 2006 07:05 PM
WHat is "http headers"? gilgalbiblewheel Classic ASP Databases 1 September 14th, 2005 11:59 AM
Help With PHP Headers!! majingohan Beginning PHP 1 April 17th, 2005 04:16 AM
Headers skicrud Beginning PHP 2 October 10th, 2003 02:21 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.