Wild card search with sharepoint datas on SSRS 2008
Hi all, I have created a report with all the fields from a share-point list. The report is fine. Now I have to do a wild-card search in that. The report will be like this No Name Department ================== 1 John Finance 2 David IT 3 Thomas Consulting 4 Smith Legal I have to create a text-box where a user enters any text, and when he clicks "view report" the report table should display all the rows with all the occurrence of that keyword entered on that textbox. For eg. if I type 'a' in the text-box, it should display all the rows that has 'a'. The output would be No Name Department =================== 1 John Fina nce 2 Da vid IT 3 Thoma s Consulting 4 Smith Lega l Dataset I used is <Query> <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction> <Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems"> <Parameters> <Parameter Name="listName"> <DefaultValue>ListName</DefaultValue> </Parameter> </Parameters> </Method> <ElementPath IgnoreNamespaces="True">*</ElementPath> </Query> How to achieve this. Any suggestions.
September 30th, 2010 11:56am

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

Other recent topics Other recent topics