March 8, 2017 at 12:09 pm
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?
March 8, 2017 at 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.
Lowell
March 8, 2017 at 1:20 pm
Lowell - Wednesday, March 8, 2017 1:05 PMoff 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?
March 8, 2017 at 2:08 pm
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply