I am sorry about the confusion, well in Business objects reports if users don’t pick any values from Agreement Group Name parameter, it won’t join to the fact table. So...

Thanks for everyone reply, when i am using the above "Switch" statement i am not getting an correct data. Can you guys please let me know how can i resolve...

I totally agree with you whatever you are saying, however the SSRS data are matching with the Business objects report when I pick something from Agreement Group parameter it is...

Well we have business objects reports already in production, now clients asking for same reports in SSRS, In business objects we have optional prompts feature. So now in SSRS if...

Find the below link that shows the error msg while I am trying to create the optional parameter. The business requirements pretty straight forward. I have to create the optional...

Thanks for your reply, the multiple values parameter" is not working with NULL values. i have to give both options to the end users, they can pick multple vlaues or...

Thanks for your reply. It is RDL.