Hello, I have just discovered the reporting service. I work with SQL Server Buisness Intelligence Developement Studio. Everything is well, I create my database, my dataset. I have just created a quite simple request : SELECT * FROM E_SUGGEST ; Now I want to treat my fields with filters ( where ). For example I shall like a request of this shape : SELECT COUNT("SU_OBJET") AS "Total" FROM E_SUGGEST WHERE SU_OBJET LIKE "HL %" ; And so on I shall like treating several fields of the table in this way. Could you help me please ? Thank you in advance.

Hi, I assume that you are binding this dataset to a Tablix. 1) If your filter is selected by your end user, you need to create a parameter with values to be selected and use it in your where clause. 2) If you need a static filtering, you need to add filter to your tablix. Please refer the below link for more details on this. http://msdn.microsoft.com/en-us/library/cc627464.aspx. If i misunderstood your requirement or you need more help, let me know.MSBI Developer

Hi Pookiz, According to your description, you would like to apply filter to your dataset, then calculate the rows count of the dataset. Please follow the steps below: 1. Right-click the dataset whose query string is “select * from E_SUGGEST”. 2. Select Dataset Properties, switch to Filters Tab. 3. Click Add, then in the Expression drop down list select SU_OBJET, Operator set to Like ,Value set to HL*. 4. Right-click the textbox you want to show COUNT("SU_OBJET"),then select Expression. 5. Type in RowNumber(“Dataset1”) in the Textbox(please replace Dataset1 with your dataset name). After you complete the steps below, please click preview to have a try. If you have anything unclear, please feel free to let me know. thanks, Bill Lu