Guys i am new to this forum and this is my first post.

 I have a peculiar problem I have created a report using sql query like this Select prod_id,Product_name,product_description from product_mst where prod_id in {?inProdId} where inProdId is a string parameter. When i preview this report in crystal report with passing the values '1123','1124','1125',1126','1127','1128',1129' it is giving me the report.

 but after deploying this report in business object server and previewing this report with the above said values it is giving me a blank report. When i checked the db there is no record for first value 1123, but value is there for 1124. In BE server if i give only 1124 value it is giving me the report in BE Server preview.

 My data source mentioned in the crystal report and business object server is same. Please help me to solve the problem.