We help IT Professionals succeed at work.

How to Reset Serial number in Report(Rdlc)

gpinfotech
gpinfotech asked
on
Hi all,

I am using local reports(rdlc) for report generation in Asp.net

In my report i have 5 groups. Problem is whenever any group is changed, i need to reset the serinal number to 1.How can i do it.

Very urgent.

Regards,

Naren
Comment
Watch Question

If you are getting the data from the SP assign a new Row_Number partion by your group condition. then you can use this column in may manner as a serial to filter or display on reports etc.

Author

Commented:
Hi,Thank you for you reply,

I am not grouping in Query or in SP. I am adding groups in rdlc design itself.

Regards,
Naren
Then use the RowNumber Function with the scope of the group.

Like :-  RowNumber("GroupName") Also sort the Group on any condition like PKID etc to get tqour relevant serial numbers in order.
Then use the RowNumber Function with the scope of the group.

Like :-  RowNumber("GroupName") Also sort the Group on any condition like PKID etc to get tqour relevant serial numbers in order.

Author

Commented:
Hi,thanks for reply,
I know the concept of this rownumber, but i have 5 groups. which group name i need to pass here. I need to reset sno, if any group chaged.

Regards,
Naren

1. If I am getting you right, you have 5 adjacent groups like
Group1, Group2, Group3, Group4, Group5 with some conditions.
11.  You want to determine in which scope are you currently:-  
Ans:- Use InScope("Group1")
OR
1.2. You want to start the row number for each starting from 1.
then use Row_Number("Group1")

2. If you have sub groups like Group5 is child 4 and 4 of 3 and 3 of 2 and 2 of 1

Please let me know what exactly you want to implement

Author

Commented:
Not Resolved