locked
rdlc report RRS feed

  • Question

  • 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

     

    Thursday, May 26, 2011 3:35 PM

Answers

  • 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

    • Proposed as answer by Challen Fu Wednesday, June 1, 2011 1:11 AM
    • Marked as answer by Challen Fu Monday, June 6, 2011 3:09 AM
    Monday, May 30, 2011 6:46 AM