Click here to Skip to main content
15,670,482 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I created a crystal report in my application, there are 2 section in crystal report and each section contain 2 field, first section field is "test1name" and "test1detail" second section field is "test2name" and "test2detail" i want to show only section which field's is not blank. how can i do that?

Please help.
Thanks in advance.

1 solution

Go to the "section expert" found under "report" in the menu. Here, click on the section you need to supress and tick the "suppress if empty" checkbox.
They may actually be called differently, I'm translating from a Dutch version of CR. Anyway, I think you'll find it :)

I think this is only true if you're actually designing in Crystal Reports. Not sure for Visual Studio...

You could also check these links if my suggestion doesn't work, or you want to suppress based on some condition:
Suppress blank section of data field and the label[^]
Crystal Reports XI, how to suppress blank row(s) in detail section of the report?[^]

Good luck!
Share this answer
varuncodee 26-Feb-12 5:11am    
In English version of visual studio it says "Suppress Blank Section" i don't know why but it doesn't work, i see your links and put this code in "Suppress(No Drill-Down)" and click on "X-2" button Formula workshop {patientdetail.test2name}="" and it works...... :D

Thank alot for helping me :)
Sander Rossel 26-Feb-12 5:17am    
No problem, glad you got it working! :)
thatraja 26-Feb-12 13:36pm    
Sander Rossel 26-Feb-12 13:53pm    
Thanks! :)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900