on 06-03-2022 2:38 AM
Hello, we develop a custom viewer for a Crystal Report file using mysql as database. We have multiple tables with fields names with special characters. When we design the report using the Crystal Reports Editor, we apply the article
https://userapps.support.sap.com/sap/support/knowledge/en/2631163
and the report works perflecty.
But when we try to use the same report inside our custom viewer developed in C#, it returns an error :
check the manual that corresponds to your MariaDB server version for the right syntax to use near '% AEL_MP....'
the error is because Crystal Reports libraries are not using the string value DoubleQuotation defined in the they:
HKEY_CURRENT_USER\SOFTWARE\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\Database\QueryBuilder\NameBuilder
Where we can configure o enable the DoubleQuotation for a C# (.Net FW). application because it is not working for a custom application with mysql database?
That's because you need to add those registry keys under the cR for VS tree.
See this KBA for what those are:
https://userapps.support.sap.com/sap/support/knowledge/en/2165260
And be aware CR Designer Formula Editor will also have reserved characters:
https://userapps.support.sap.com/sap/support/knowledge/en/2042551
Don
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.