Scattered data into single line

  • 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?

  • 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!

  • 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?

  • 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!

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

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