Forum Discussion
Helper IIPaginated Report - Cascading Parameters
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 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.⚡
2 Replies
- parry2k
Super User
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.⚡
