My paginated reports can't handle a single quote in a name field

[MEFOX]

Names such as Mike's Boat Shop create the following error. Does anyone know how to allow a single qoute to be entered into a field in a paginated report?

[parry2k]

@MEFOX check the dataset in the report that is using parameter to pull the data form the SQL server.

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort 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.

[parry2k]

@MEFOX basically you need to tweak your SQL query used in Paginated Report to include a single quote, think if you have to do the same with SSMS and use a single quote value in a variable in where clause the same you have to apply in the paginated report. 

I hope it makes sense, there are tons of blog posts on how to use a single quote in the where clause.

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort 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.

[MEFOX]

I don't beleive there are any SQL queries in this report. I've pasted the account name field properties below.

I'm wondering if there is a settting that can be changed to allow the single quote.  If there was a sqL query how would I find it?

[parry2k]

@MEFOX what do you mean by entering single quote? Do you mean in the parameter? What is the data source?

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort 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.

[MEFOX]

Yes, Its a field where you enter the account name. It will query an Azure sql database.

[MEFOX]

I do realize that the account name field is used to query the Azure SQl database but I don't see a way in the report to change the SQL that queries the database. Thats the piece that I'm missing. Can you guide me to that query or method to change the way the field queries the database?

Thanks