HI, Im using Report Builder 3.0 for reports. The data sources is sharepoint List. I created Datset using Query Designer in Report Builder. I have created 2 parameters, once i enter values to parameter boxes its works fine. if I enter nothing (leave blank) to a parameter box( which allows null in sharepoint list), the data not retrived. How to solve this problem. Further describing My List as follows Project No SubProjNo 111 1111 112 1121 113 According to above list first 2 rows can be retrived by passing parameters. 3rd one cannot be retrived. My parameters are Project No and SubProjNo. Passing 113 for Project No and leave blank for SubProjNo not working.

Hi, You can use Allow Null values option for the parameter. Hope its helpful....Pavan Kokkula Tata Consultancy Services.

Hi, I tried this, it display the checkbox to select Null or not. But the data not retrived.

Hi, Mohamedaz, Write a Query with ANSI_NULLS OFF. SET ANSI_NULLS OFF GO select * from DbTesting.Table where QTY in (1,12,null) GO Rakesh M J Dont forget to mark it as Answered if found useful MCTS,MCITP,MCSS http://mycubeandreports.blogspot.com/

Hi, My Query is not SQL. It is similar to CAML starting with <RSSharePointList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> and end with </RSSharePointList> The query automatically built in Report builder Query Designer. Thanks.