5,901
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
Hi,
Can you confirm that there is no 'space' in description value?
Arpan,
Can you try deleting the report from reporting server and deploying the report again?
Hi Arpan,
You need set expression on Row visibility =iif(Fields!Description1.Value= space(0),True,False)
select the entire row where you have a description set like below -> click on Row visibility and set the expression.
Arpan,
It should work. id there is more than one dataset, please mention the dataset name and try deploying the report again.
Check this example from SalesInvoice report as well -
Nothing else. Is it not working?
i wrote 3 expressions like
=iif(Fields!Description1.Value = space(0),True,False)
=iif(Fields!Description2.Value = space(0),True,False)
=iif(Fields!Description3.Value = space(0),True,False)
for each rows. now what to change?
First expression fetches only the first record of the dataset. Since this condition returns true, lines are getting displayed for all rows. Replace the existing condition with the new condition I provided and test if you see expected result.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (