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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics