Show multiple rows as single row

  • cmw 66135

    Ten Centuries

    Points: 1205

    I have a report that I am building that returns information from different years. The problem I have is that it is showing multiple rows for each user for each month. Is there anyway I can get this to populate on one line?

    Thanks

    Chris

  • richardwillemain

    SSC Veteran

    Points: 291

    Can you tell us better what the data actually are for each user per month ?  ie. is your designed report displaying duplicates or actual rows ?   I think I would need more info in order to be able to suggest a solution or help otherwise.  Rick

  • Sean Lange

    SSC Guru

    Points: 286364

    cmw 66135 - Monday, April 16, 2018 2:17 PM

    I have a report that I am building that returns information from different years. The problem I have is that it is showing multiple rows for each user for each month. Is there anyway I can get this to populate on one line? ThanksChris

    Yes this possible. However, I can't provide an answer because unfortunately you have not yet provided the entire question. We need some details here. Do you want aggregate data? Do you want your rows pivoted? Please see the first link in my signature for best practices when posting questions.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • cmw 66135

    Ten Centuries

    Points: 1205

    Sean

    Thank you for your reply. Sorry my question wasn't complete I was typing while trying to work out the problem, as I have said before I am very green to the reporting software so I do apologise if I dont always make sense. I seem to have stumbled across the answer in playing around with the report and the tests I have run seem to have worked as the results are as I would expect them. Thank you for taking the time to reply though and apologies I didnt follow the best practices for posting a query, I will try harder in the future

    Thanks
    Chris

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply