Print Page | Close Window

how to hide balnk spaces

Printed From: Crystal Reports Book
Category: General Information
Forum Name: Self-Publishing
Forum Discription: Thinking about writing your own book or already have something to sell? Let me give you advice from my experiences.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=12727
Printed Date: 01 Apr 2025 at 2:56pm


Topic: how to hide balnk spaces
Posted By: subash141
Subject: how to hide balnk spaces
Date Posted: 28 Mar 2011 at 12:28am
Hi,
     How do I hide blank rows in crystal xi based on a certian criteria but still include the values in my grand totals.
 
Thanks,
Subash


Replies:
Posted By: sudh
Date Posted: 13 Jul 2011 at 4:14am
Hi..
 
following steps might reach out your requirement:
 
1.Goto report menu-->selection formula-->record--> formula workshop will be opened.
 
2.write the follwing formula:
  not (isnull({Customer.Address2}))
note:before write that formula, select an option default values for nulls which placed beside comment(//) option.
 
3.click ok.
 
Thanks,
Sudh.
 

Posted By: hirecrishecom
Date Posted: 04 Dec 2011 at 7:44pm
ngadde dude, can I see your formula, so I can help you out. Have you try to do some suppressing in "Section Expert", try to check "Suppress Blank Section", to go to there right click on the details section choose "Format Section". Or maybe you can implement your formula in the Format Section suppressing.

Good Luck hope it helps. Let me know the progress so I can help you more.

-------------
http://www.axistechnolabs.com/programmers/asp-dotnet-programmers.aspx - hire asp.net developers , http://www.axistechnolabs.com/programmers/php-programmers.aspx - hire php developers


Print Page | Close Window