How to Show "-" value in case of No Values - Reg.

[shan]

Hi,
Kindly note that i have designed the report with one Header Band & Databand with four textbox & some filter conditions,
but in case the applied filter doesn't has any values i need the textbox value to show "-".
Also note that the Header Band will be printed by using the property printifempty to true, but i want also the DataBand textboxes to be printed with "-" values.

i tried the below code it is working only for DBNull Values not for applied filter cases
(Obj["Employee1"] == DBNull.Value) ? Obj["Employee2"] : Obj["Employee3"].

So look into above mentioned details then suggest me some alternate solution.

Thanks & Regards,
Shan

[Alex K.]

Hello,

Please try to use the Conditions instead filter and "AssignExpression" property for the Text components.

Thank you.

[shan]

Hello,

Please try to use the Conditions instead filter and "AssignExpression" property for the Text components.

Thank you.

Hi,
Thanks for your response. I need to use the filter condtion in DataBand, it is easier for me to change the filter conditions dynamically from code behind. So kindly suggest me the solution by using the filter conditions.

Thanks & Regards
Shan

[Alex K.]

Hello,

Can you please send us your report with test data and detail description of your task for analysis.

Thank you.

[shan]

Hello,

Can you please send us your report with test data and detail description of your task for analysis.

Thank you.

Hi,
Kindly find the attachment of Sample DB with Sample Report for your reference.

In the report i applied the filter using C_ID and to display C_name according to the filter applied. Incase filter fails i need the textbox to display "-" value.

Thanks & Regards,
Shan

[Alex K.]

Hello,

Thank you for sent report. Unfortunately, but is not possible make with the filter conditions, only in Condition as we wrote in previous post.

Thank you.