Problem with DB2 and Crystal Report SQL in InfoView

Hi;

Can someone help me, I do have a problem with several CR reports that generate SQL command differently from Client and InfoView or CMC. precisely the Where close in the sql sentence is not sent to server from infoView.
Command like :

Select … From … Where …
from client the sql is complete, but when trying to view the reports from infoview we do have
Select … From …

Driver version are the same and configuration of DB2 in prm files look like ok

any ideas :?:


Anis (BOB member since 2010-04-24)

have seen this with the following Environment : BOE Xi3.1 + Crystal Reports 2008 v1, after BOE XI 3.1 Sp2 was applied this error disappeared. I do not know what causes it, an SAP engineer was able to replicate it, besides some ADAPT number was assigned as well, but I did not remember that number, since i do not have access to my SAP account right now


Antremons (BOB member since 2006-03-21)

Can you please provide me with the right ADAPT cause well reading the pdf file related to the SP2 I did not found any description related to the same subject, I can not perform installation of SP2 before being sure that this is the solution.
Thanks


Anis (BOB member since 2010-04-24)

this one ADAPT01223827. I updated both: Crystal as well as BOE


Antremons (BOB member since 2006-03-21)