Row number in sbo hana query in crystal report

[Former Member]

Hi,

How to get the row number in sbo hana crystal report query?

[Former Member]

Dear Prabhu,,

Please find the below query for reference.

(Case When ROW_NUMBER() Over(Partition By T0."DocNum" order By T0."DocNum")='1' then T0."DocTotal" else NULL End) end)  as "Total"

Regards,

Vestrics

[abhilash_kumar]

Hi JK,

If you're reporting against HANA SQL, you can use the Row_Number() function.

More info here:

Window Functions - SAP HANA SQL and System Views Reference - SAP Library

-Abhilash

[former_member205840]

Hi Prabhu,

If you want only row number, create below formula and place it on your details or group wherever it is required.

Whileprintingrecords;

Numbervar x:=x+1

This formula will print serial number.

or you have a special field called RecordNumber under Field explorer, place it in detail section, this works for only detail records.

Thanks,

Sastry