Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > .NET > Other .NET > Crystal Reports
Password Reminder
Register
| FAQ | Members List | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #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.
Reply With Quote
  #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
Reply With Quote
  #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.
Reply With Quote
  #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
Reply With Quote
  #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.
Reply With Quote
  #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
Reply With Quote
  #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!

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 10:51 PM.


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