Paginated Report - Cascading Parameters

[JackWren]

Hi, 

I am fairly new to Paginated reports. I have created a report with a mix of parameters, two of which are linked through a cascade. 

Sales Branch feeds sales Unit. 

I have made sure to select distinct values in both of them and to check the box "Allow Multiples Values" in the report parameters 

The report runs but only if I select one value in Sales Branch and not Select All. 

If I do, I get the following message: [Teradata Database] [3706] Syntax error: expected something between a string or a Unicode character literal and ','.

Did I forget something? 

Thank you 

[JackWren]

@parry2k  thank you for the info regarding the data source. 

Just another question what do you mean by "how you are using the parameters in the query" ? 

[parry2k · Accepted solution]

@JackWren depends how you are using the parameter in your query and if separated by comma is ok with your underline data source.

Check my latest blog post Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡