Post reply

group by in reporting services

  • August 24, 2008 at 5:05 pm

    #197470

    I figured there would be a separate forum for Reporting Services (is thi sit)

    I have a report whoch display free disk space on servers like this:

    server 1 | c:\ | 20 GB free 08/22/08

    server 2 | c:\ | 5 GB free 08/22/08

    The query is simply select * from FreeSpace;

    I want to track this data over time so we can see how fast the disk is getting used up.

    I want the report to display the most current record for each drive but I also want the drill down to all lthe previous days and I want to chart it.

    Thanks,

    Kevin

  • August 25, 2008 at 7:19 am

    #862505

    What control are you using to display the data? If you are using a table you can use set the grouping to the Server and in that level take First(datafield) for each of the columns you are using. Then your details will be the rest of the records with a filter that excludes that first row. You would have to order by day desc in your query.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

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

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