Scattered data into single line

Question

Scattered data into single line

komal145

SSCrazy Eights

Points: 9915
More actions
March 8, 2017 at 12:09 pm

#335776

Hello,
I attached the report.
Right now I am getting data in different lines for each date. how can i get in a single row?

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

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

Lowell SSC Guru Points: 323504 More actions · Answer 1

off hand, i'd say it looks like you need to use something like SELECT MAX(ASP_New?) As ASP_New FROM SomeTable group by [SomeDateColumn ]

That way you are getting just a single value per date.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

komal145 SSCrazy Eights Points: 9915 More actions · Answer 2

Lowell - Wednesday, March 8, 2017 1:05 PM
off hand, i'd say it looks like you need to use something like SELECT MAX(ASP_New?) As ASP_New FROM SomeTable group by [SomeDateColumn ]
That way you are getting just a single value per date.

How to write expression in ssrs for the same?

Lowell SSC Guru Points: 323504 More actions · Answer 3

SSRS has a Grouping band, and the MAX function exists in expressions...did you try that yet?

it's a little hard to help from the screenshot., so i can only offer generic advice.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!