Adding Additional Column RRS feed

  • Question

  • Hi All,

    I have developed a report using report viewer in web form.  The report is generated based on the selection of Department.  User have an option to multi select the departments so the department column grows. Lets say user select Business category first and generate the report then user decides to add another department say Engineering.  No the report column headers will have addional column "Engineering".  I have used the Matrix since I had to group by Name and dates. Everything is good so far.
    Now I have to add an additional column "Notes" at the end of all the columns. If there is ony department is chosen then Notes column appears after that and if mulitple departments are chosen the Notes column should also appear after all the department column (at the very end).
    I am really having hard time to accomplish this.  Is there any suggestion or solution to finish this?  I really appreciate your responses.

    Thank you.

    Wednesday, February 27, 2008 5:21 PM