How to filtering in the report paramter
Hi,
Please provide me approach to filter the record . My report's datasource is XML . I need to write a filter for dataset where im going to get all rows but not first row.
I Used this approach
http://www.eggheadcafe.com/conversationwarning.aspx?messageid=29953847&groupid=1338
But it didnot worked for me
Mahender
October 29th, 2010 4:19pm
Hi,
In the output, you can hide the first row with a condition on row visibility.
1) right click the row in tablix and click row visiblity
2) click "show or hide based on expression"
3) enter the expression as given below
=(RowNumber("DataSet1")=1)
Hope this helps.
Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.
BH
Free Windows Admin Tool Kit Click here and download it now
October 30th, 2010 1:16am
thnx for answer. Well cant we do it thru Filters, rowID >0 as mentioned in this URL
http://www.eggheadcafe.com/conversationwarning.aspx?messageid=29953847&groupid=1338
I need such functionality because, I'm having a webservice which return XML , If the first row of XML datasource contains a NULL or Empty column value, then it is ignored by SSRS dataset, in order to fix those issue, I'm passing dummy column from my webservice
to ssrs report and in the report using filters just remove that entry from the result set.
-MahenderMahender
November 1st, 2010 5:08am