Posted 5 March 2019, 11:38 am EST
Hi, I am new to using flex report designer and SQL and I’m struggling to find answers within documentation on this website.
I am trying to set up parameters that work for multi values. I have a parameter for Customer Name, which is linked to the customer database. I can get it to work if you just select one customer, but if you select multiple even through multivalue is TRUE it comes up with ‘no value given for one or more parameters’. My main data source has this in the SQL statement:
WHERE ([Customer Name] IS NULL OR [customer id] IN ([Customer Name]))
I’m guessing that I need to do something else to convert the multi value into something that can be queried but I don’t really understand and can’t find any info
Does anyone have any good documentation on flex report designer that could help so I can minimise the number of posts on here ?
Thanks
Marie