cancel
Showing results for 
Search instead for 
Did you mean: 

Crystal reports support server side processing when fed from SAP ECC table?

richiew03
Explorer
0 Kudos

Hi,

can anyone tell me if when connected to an ECC table this supports server side processing, i.e SQL selects on the database, rather then returning the whole dataset and filtering on the client. I note the manual states :

"You should also note that server-side processing works only for reports based on SQL data sources." I understand that an openSQL driver isbeing used for the SAP connection, does this count?

Also does anyone know where I can see the SQL that is generated in SAP? there must be some transaction?

Thanks,

Richard

Accepted Solutions (0)

Answers (1)

Answers (1)

richiew03
Explorer
0 Kudos

SOLVED:

I ran a SQL trace in SAP, and when changing the restrictions, the select condition is changed in the SAP generated SQL statement and the number of rows retrieved changes. Therefor server side processing does qork with the SAP integration kit.