Suneetha,

Thank you for submitting your question to our forum.

Is it possible to get some clarification? By sequence number
do you mean the report ID number?

Please let me know and I will follow up accordingly.

Regards,

Kyle

Hi Kyle,

I meant Sequence number which is similar to Serial Number, instead of starting from 1 number should start from 8000001. Using the Analytical function,Accumulative Total I do not get the correct results.

Thanks,

Suneetha

Hi Suneetha,

if I have understood you correctly, I think you need 2 calculated fields, the 1st one simply has the value of 1. Drag this into the report and apply an "Accumulative Total" Advanced Function to it so that the resulting rows are 1, 2, 3, 4 etc.

Then the 2nd calculated field should simply have a valued of 8000001. Drag this into the report and apply the Advanced Function called "Sum of Columns" to it and then point it to the 1st calculated field. Then you will get 8000001 + 1, 8000001 + 2, 8000001 + 3, etc.





Please let us know if that's what you were looking for or not.

regards,
Dave

Thanks Dave. That works :-)