CR 2020//Working with Byte fields

[former_member562091]

Hello,

i just switch from CR2016 to CR2020.

i've got a problem with reports which handles with SQL Byte fields (Actian PSQL DB).
In CR2016 it works correct, but CR2020 don't show me the values (See attached pictures).
I have also tried out with other Applications like Flyspeed SQL, Excel ... they all can show me the Byte Value.
So it cannot be a problem of 64bit ODBC, what was my first idea. I also install the service pack

CR202001P_500-70005715 - doesn't help.

May someone can help me.

CR2016:

CR2020:

Best regards

Andreas Woerner -SysTek GmbH-

[ido_millet]

What does Crystal 2016 show as the data type for that column?

What happens if you do Database, Verify Database... for that report in Crystal 2020?

What happens if you save the rpt with data in Crystal 2016 and then open it in Crystal 2020? If it previews correctly, that would confirm the issue is data access rather than data render.

One way around the issue may be to create a View and cast that column to another data type.

[former_member562091]

Hi,

in german version the Type is "Zahl" - think in english "Number".

I don't think, that it is an problerm with ODBC - cause all other Apps like FlySpeed SQL, Excel, MS-Query, ... all works fine.

But thanks for yours investigations 🙂

Best regards

Andreas

[ido_millet]

What is the data type shown by Crystal 2016 for that column?

Perhaps there's a registry entry that needs to be set on a different hive for 64-bit connection.
Here is a link to full listing of these tweaks: https://userapps.support.sap.com/sap/support/knowledge/en/2165260

They are not well documented. For example, I don't know what the "DontAutoConvertODBC" entry is used for.
But you could investigate what you have under the 32-bit hive and apply the same to the 64-bit hive.

If that doesn't work, then investigate updating the ODBC driver.
If that is a dead-end, you would need to request & wait for a bug fix.
You can open a paid tech support case. I believe that if they recognize it as a bug they refund the fee.

[former_member562091]

Hi,

Thanks for yours answer.

i've also create a new Report within CR2020 - it doesn't work.

If i save thge Report in CR2016 with Data and open it in CR2020, the field is shown 🙂 But this don't solve the problem.

Seems that in CR2020 is some fault.
I think yours workaround will run, but then i must create much views, cause there are much Byte-Fields in the DB in many tables - and much installations at customer side.
So i hope that i can solve that problem inside CR2020..

Regards

Andreas