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

Question

how to hide textbox 0 values, in RDLC Report Textbox in Tablix and Show '-' in windows application

Rafnas T P · Answer

change that select statement replace column CGST_Amt with case when CGST_Amt=0 then "-" else CGST_Amt

Amit Gupta · Answer

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 P · Answer

in dataset6 check wich query you have used that query you have to modify

Jyoti Jodha · Answer

in Textbox Query =First(Fields!CGST_Amt.Value, "DataSet6") And tablix Query =Fields!CGST_Amt.Value what is change in this Query

Rafnas T P · Answer

then change the query which one you are using for tablix

Jyoti Jodha · Answer

I am want to GST_Amt= 0 then don't show 0 where show ("-")

Rafnas T P · Answer

hi, what do you want exactly. do you want to show - instead of 0 in tablix column GST_Amt

Rajkiran Swain · Answer

http://www.c-sharpcorner.com/UploadFile/nipuntomar/how-to-hide-rdlc-textbox-based-on-value/

Manikandan Murugesan · Answer

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 Jodha · Answer

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 Murugesan · Answer

Refer this Article : http://www.c-sharpcorner.com/UploadFile/nipuntomar/how-to-hide-rdlc-textbox-based-on-value/

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

Answers (11)