how to hide textbox 0 values, in RDLC Report in windows c#

Jyoti Jodha

9y4.3kWindows Forms

how to hide textbox 0 values, in RDLC Report

Textbox in Tablix and Show "-"

in windows application

11 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rafnas T P9y ago
Accepted answer
change that select statement replace column CGST_Amt with case when CGST_Amt=0 then "-" else CGST_Amt
Amit Gupta9y ago
Hey

You want to Show - (hyphen) where the value having 0 (zero), you can use iif condition.

Right Click on the cell, say GST_Amt -> Expression and write the below expression
=iif(Fields!GST_Amt.Value=0, "-" ,Fields!GST_Amt.Value)
Determines the condition part
Evaluate when condition is true
Evaluate when condition is false

Run your report and you will get hyphen instead of zero

Good Luck !!
Rafnas T P9y ago
in dataset6 check wich query you have used that query you have to modify
Jyoti Jodha9y ago
in Textbox Query
=First(Fields!CGST_Amt.Value, "DataSet6")

And tablix Query
=Fields!CGST_Amt.Value

what is change in this Query
Rafnas T P9y ago
then change the query which one you are using for tablix
Jyoti Jodha9y ago
I am want to GST_Amt= 0
then don't show 0 where show ("-")
Rafnas T P9y ago
hi,
what do you want exactly. do you want to show - instead of 0 in tablix column GST_Amt
Rajkiran Swain9y ago
http://www.c-sharpcorner.com/UploadFile/nipuntomar/how-to-hide-rdlc-textbox-based-on-value/
Manikandan Murugesan9y ago
For IIF refer this link : https://docs.microsoft.com/en-us/sql/mdx/iif-mdx
IIF is used for evaluating different branch expressions depending on whether a Boolean condition is true or false.

Refer this link to clear the error : https://stackoverflow.com/questions/6279704/how-do-i-set-the-visibility-of-a-text-box-in-ssrs-using-an-expression
Jyoti Jodha9y ago
when use this Query

( iif(Fields!IGST_Amt.Value>0,false,true) )

then show this Error

Enter a valid expression for initial visibility state.
Manikandan Murugesan9y ago
Refer this Article : http://www.c-sharpcorner.com/UploadFile/nipuntomar/how-to-hide-rdlc-textbox-based-on-value/