Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: How to hide a row of data when no data is present Post Reply Post New Topic
Author Message
jimisayss
Newbie
Newbie


Joined: 29 Aug 2012
Online Status: Offline
Posts: 5
Quote jimisayss Replybullet Topic: How to hide a row of data when no data is present
     Posted: 29 Aug 2012 at 9:28am
Hello I have a wrote a report with Met/cal database
the report pulls up the asset number, company info, model serial, description and the due date.

Some Asset numbers do not have a due date or is blank in the database, i want the report to not show the rest of the information if the due-date is blank but i cannot figure out how do to that. any help would be greatly appreciated!
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 29 Aug 2012 at 10:14am

are you trying to hide 1 row of data or a group?

IP IP Logged
jimisayss
Newbie
Newbie


Joined: 29 Aug 2012
Online Status: Offline
Posts: 5
Quote jimisayss Replybullet Posted: 29 Aug 2012 at 10:24am
The report sorts the companies by groups. I'd like to hide the row that doesn't have and due date information. I'm sorry if this is confusing its hard for me to word it.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 29 Aug 2012 at 10:30am
you can hide sections (liek a detail row) by
opening the select expert
select the section you want to hide
click on the formula button (x-2) next to the Suppress (no drill down option)
enter your boolean suppression formula here, somehting like:
isnull({table.duedate})
 
IP IP Logged
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