SAP Running total on first 300 Record

[Former Member]

Hi Everyone,

i suppress rows greater than 300. serial formula in Crystal report. but when i am total sum of amount  this will give me wrong result it give me result of all. but i want just 300 top crystal formula . i am not  using any  grouping in crystal report. thanks

[former_member205840 · Accepted solution]

Hi Safeer,

You can write a formula like :

If rownumber > 300 then 0 else Amount 

Now insert your summary based on the above formula.

Note : The condition which you are using to suppress rows, use the same condition in above formula.  Also please replace formula fields with appropriate report fields.

Thanks,

Sastry

[Former Member · Accepted solution]

Thanks,

but we cant' import the serial no report formula in running total. but we can in suppress formula

[abhilash_kumar · Accepted solution]

Hi Safeer,

Could you post the formula you've used to suppress rows greater than 300?

-Abhilash

[abhilash_kumar · Accepted solution]

If you're using the rownumber function, here's what you can do:

1) Create a new formula field using this code:

If  rownumber <= 300 then

Shared numbervar amnt := amnt + {Amount field};

'':

2) Drag and drop this formula field to the details section.

3) Create another formula field to display the Total and place this field on the report footer:

Shared numbervar amnt;

-Abhilash

[Former Member · Accepted solution]

if {@serial}>300

then true

[Former Member · Accepted solution]

WhilePrintingRecords;

numbervar inc;

numbervar top_n;

inc := inc + 1;

if inc <= 300 then //where 5 means top 5

top_n := top_n + {@Amount}

i done with this thanks..