how to serial no in multiple group in rdlc report prem kumar (First Group) 1 . sunil agent (table Content) 2 . rakesh agent 3 . siddhart agent Sahitya kumar 1 . sunil agent 2 . rakesh agent 3 . siddhart agent and i want that like that 1. prem kumar 1 . sunil agent 2 . rakesh agent 3 . siddhart agent 2 . Sahitya kumar 1 . sunil agent 2 . rakesh agent 3 . siddhart agent

Hi AjaySoni22, Thanks for your question. According to you description, I understand that you want to add a group number in the front of row group expression, right? If I misunderstand your question, please let me know. If so, in order to solve the question, I suggest you to use RunningValue() function to get the group number, then add the value to the start of the row group expression. For detail steps, please follow below like this: Supposing the current row group expression like this: Fields!SalesTerritoryGroup.Value. 1. Right-click the textbox of your row group, select expression. 2. In the expression dialog box, clear the current expression, then type in: =RunningValue(Fields!SalesTerritoryGroup.Value,CountDistinct,Nothing) &". "& Fields!SalesTerritoryGroup.Value. 3. Click OK. For more information about RunningValue Function (Reporting Services), please see http://msdn.microsoft.com/en-us/library/ms159136(v=SQL.90).aspx . If you have any question, please feel free to let me know. Thanks, Sharp Wang