Crystal XI - Conditionally showing/hiding Text boxes ...

building reports crystal reports
1

Greetings Fellow Bobjs,

I’ve recently started working with Crystal again after an absence of a few years of not using product and I’m struggling with getting Crystal to conditionally hide/show Text boxes. I can’t recall if I was able to do it previously in Crystal because the last time I used Crystal it was using Crystal with VB at the time and I’m originally a VB man, so I would have probably tried to do everything programmatically using VB (I’m guessing) and this time around I’m only using Crystal not Crystal and VB

What I am trying to achieve at the end of the day is …

… “if a value for a database field shown on the report happens to be NULL for whatever reason, I do not want to show this Text box or the associated Label for the Text box. But if is it NOT NULL then I want to show the Text box and the associated label for that Text box on the report.”

My preference is not to create a new section header, ie and show/hide that (if that works). However, if there is no alternative then I guess I will look at that. I’m not sure if that would work? Anyone??

Thanks in advance!!

Bobbafett

bobbafett (BOB member since 2007-10-18)

2

Did you look at the format expert and try the formula editor to make the text box dissappear or become invisible?

Hope that helps.

khajasamiuddin (BOB member since 2006-06-23)

3

Thanks for the reply.

Yes, I tried to use Formula editor yesterday, but I had difficulty figuring out what the properties that I could interrogate were.

I was hoping to do something like …

.visible=true

Is there a particular property that I can access programmatically via Formula Editor to make a Textbox visible/invisible?

Thanks in advance!

bobbafett (BOB member since 2007-10-18)

4

Good day my mandalorian armoured friend.

Right click > Format Text, then youll see a tick box labelled suppress. On its far right there is a formula button, into which you can put a condition that returns a boolean. True = Suppressed, False = Not Suppressed.

ABILtd :uk: (BOB member since 2006-02-08)