Line should display based ion values in SSRS report

(0) Share

Report

Posted on by @rp@n

hi all,

Report design

In the above design ---

Description - Is printing the ITEM NO

Description1, Description2, Description3 = it's should come for all item number based on value

Report output

here 3 GAPS are coming for each item.

But the requirement is the above 3 LINES from each item SHOULD ONLY DISPLAY , IF VALUES IS THERE ELSE THOSE LINES SHOULD NOT COME.

In the above example, it should only show item numbers without GAPS

Please let me know how will do this

I have the same question (0)

All responses (23)

Answers (1)

Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report
You should include an expression for row visibility like this -

iif(First(Fields!Description1.Value, "SalesInvoiceDS") = "",false,true)

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report

for each line rite? means description2 and description3 also

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Correct. condition should be for each row.

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report

i tried this but the report is coming in below

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report

i need to write the above expression -- Visibility -- show/hide expression for each line rite?

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Yes. I think you wrote in the values expression.

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report

now i wrote code in each row -- row visiblity -- show/hide expression

but still it's showing 3 balnk lines for each item

Was this reply helpful? Yes No
Verified answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Try this code please and check. Maybe I had the conditions reversed.

iif(First(Fields!Description.Value, "SalesInvoiceDS") = space(0),True,False)

You can check the Details rows (Packing slip for an example) in SalesInvoice report as well. They are using similar logic.

Was this reply helpful? Yes No
Jeremy_Mounet 170 on at

Like (0)

Report

Hi

Regarding the result, maybe your expression is not in the good sense.

The property is Hidden, not "Show", so, if your value is empty > Hidden = true else false.

It's making something like

iif(First(Fields!Description1.Value, "SalesInvoiceDS") = "",TRUE,FALSE)

It is just a suggestion, you could display a screenshot of the visible property of your rows.

Hope it could be helpful

Jérémy.

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report

thanks Gunjan

it's working now

Was this reply helpful? Yes No