Hello,

I have a requirement to display all the work baskets associated with all the user and when i tried it my report is displaying as below format. Assume i have 2 users and assigned to below work baskets

User name Work basket
ABCD admin
ABCD manager
XYZ developer
XYZ tester
XYZ BA
But the requirement is to display like below. Not to repeat user name for all the work baskets/ records pulled in the report

How to achieve this?

    Ultimately where are you trying to use this? If this is on a UI control you can use the "group by" option present on the dropdown control OR "categorize by" option on the autocomplete. It would display the results in your required format.
    By this approach, you would be fetching all the records on the data page/report definition.

      I am implementing this this as a report in the report browser

        Have you tried grouping option in the report viewer based on user name?

          Ragul Yes, when i do grouping, I cant filter out results based on user name/ ID which is used for grouping

              Any ways, Thanks Guys for your response.
              I will show the report output to business by doing grouping and will see whether the format displayed is ok for them or not

                Write a Reply...

                -An Initiative Of OneStopPega- Love our work? Support Us🖤