Forum Discussion
Paginated Report with parameter True/False
Hello Community,
I am building a paginated report with Power BI dataset as Source. I am trying to add a parameter of type "Boolean". When I added this parameter, and run the report, it is giving me an error i.e., Function 'CONTAINSROW' does not support comparing values of type Text with values of type True/False. Consider using the VALUE or FORMAT function to convert one of the values.
Error Message
I don't see any CONTAINSROW function in my query. Below is the screenshot of query
Can anybody help me with fixing the issue to add boolean datatype as parameter.
Below is the link to rdl file and pbix dataset
https://1drv.ms/u/s!AlTyyZ_9D_Wji1R3O3yougWplyrQ?e=ztyoVi
Thanks
4 Replies
Hi, Anonymous
Could you please tell me whether your problem has been solved?
If yes, you could accept the helpful answer as solution. You also could share your own solution here. For now, there is no content of description in the thread. If you still need help, please share more details to us.Best Regards,
Community Support Team _ Easonv-easonf-msft I did try using Boolean as a data type, it still gave me the same error.
As an interim solution, I changed the data type of the field to "Text" in Power bi dataset.
Hi , Anonymous
Have you check the Data Type of your Parameter?
I don't have much experience in SSRS. You can also post your question on sql-server-reporting-services forum for professional help.
Best Regards,
Community Support Team _ Eason
