April 16, 2018 at 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?
Thanks
Chris
April 17, 2018 at 10:12 am
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
April 17, 2018 at 10:20 am
cmw 66135 - Monday, April 16, 2018 2:17 PMI 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/
April 18, 2018 at 8:59 am
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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply