Notifications
Announcements
Dear reader,I created a few reports but I want ti hide a discount rule when no dscount is given. Could somebody explain me how to hide a field tab when there no value?Many thanks in advance.Looking forward receiving an answer.Kr,Glenn Triepels
Maybe you can add a sample layout of your report showing what you want to hide will make it easier for us to help you?
RDLC or word layout? The latter will require a report extension. Former could be done with an if statement on the column. Sum the column. If 0 then hide else show.
This type of guidance will help you: social.msdn.microsoft.com/.../is-it-possible-to-showhide-dynamically-columns-in-rdlc-form
Hi, if you are talking about RDLC layout, you can add an iif function to Visibility to determine whether it is displayed.
Example:
https://docs.microsoft.com/en-us/sql/reporting-services/report-design/expression-examples-report-builder-and-ssrs?view=sql-server-ver15
Hope this will help.
Thanks.
ZHU
Hi,Many thanks for your reply. I have added the document in the attachments.
At the bottom of the page you will see a column with the name 'Korting' (which means discount) and below this column you'll see € TotalInvoiceDiscountAmount. Both fields should not be displayed when no discount is given.Do you know the solution for this?Many thanks in advance!!Factuur-lay_2D00_out-korting-18_2D00_10_2D00_2021.docx
Hi,
Could you maybe help me? At the bottom of this topic I have added the link to the document.
Many thanks in advance!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 1,573
Khushbu Rajvi. 773 Super User 2025 Season 2
YUN ZHU 760 Super User 2025 Season 2
