Crystal Report error - "the group section cannot be printed..."

[Former Member]

Hello to everyone.

I have a CR report based on a database view.

Everything is ok when i run the report in the CR designer but choosing the option to preview the report or run it from the SAP Business One (8.81 PL 08) i get an error:

"the group section cannot be printed because its condition field is nonexistent or invalid. Format the section to choose another condition field. Error in file "the Report name".rpt. Invalid group condition".

i must say that this happens in all my reports where i have group data. Also i must say that all those reports were ok some days before...

Is there a way for me to know what field is it refering to?

I have verified the DB and it is pointing correctly and the also the View returns data.

Thanks in advance

[Former Member · Accepted solution]

Hi,

Do you remember if you were in the same PL when the report was working?

Thanks,

Gordon

[Former Member · Accepted solution]

Hello Gordon,

thanks for your response. the reports were working fine until 8.81 PL05

We have upgraded the customer from PL05 - > PL08 a week ago.

Do you think that maybe this is the problem?

Thanks in advance

[Former Member · Accepted solution]

You have right assumption. Upgrade is the most probable cause.

[Former Member · Accepted solution]

Check the database connection settings and see if this resolves the issue.

There is a known issue with Windows 2003 / XP, but I have issues with a different system set up to that in the note (SQL Server 2008 , Windows Server 2008 R2 )

PL09 fixes the former apparently, but haven't tested this

[Former Member]

thank you all for your answers

Just upgrade from PL08 to PL09 and the problem solved