Sr.No is not working proper when Group is changed

[Former Member]

Hi,

The Sr.No is not working proper when Group is changed in my report so give me a better solution for Sr.No.

i used 3 Group in my Reports.

For example -

Sr.No	Value 1	Value 2	Value 3
2	ABCD	10	1010
3	PQRS	0	500
	Gross Total	10	1510

if i change the value1 PQRS is null then Sr.No is change it shows the value of Sr.No is 3 . i want to show the Sr.No value is 1.

Expected Output -

Sr.No	Value1	Value 2	Value 3
1	ABCD	10	1010
2	PQRS	0	500
	Gross Total	10	1510

please give me a solution for Sr.No .

rly fast.

Thanks!!!

[former_member226669]

Hi Kiran,

1)   Create a formula @initialize with the below code and place it in the section above the one where you want to display Sr. No.

whileprintingrecords;

numbervar SrNo:=0;

2)   Create another formula with the code and place where you want to display Sr. No.

whileprintingrecords;

numbervar SrNo:=SrNo+1;

- Nrupal

[abhilash_kumar]

Hi Kiran,

Formula 1 from Nrupal's code should be on the Group Header.

-Abhilash