Post reply

Summing a subset of a Group

  • May 27, 2010 at 8:01 am

    #1173325

    I can't off the top of my head come up with a way for you to get just one reporting period without the others and without screwing with your total.

    If showing all of the periods would fit the requirements, you could investigate a matrix report and add a column group based on your reporting period.

    IF however that will not meet your needs another way I've been able to accomplish such things is to actually do all of the data manipulation in the SQL query or stored procedure. Then just output that results in a table.

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • May 27, 2010 at 8:06 am

    #1173331

    Thanks for the advice Luke, i'll have a look at using a matrix instead; i have come across this suggestion during my research into the issue already so it would seem like a sound suggestion.

  • May 27, 2010 at 8:14 am

    #1173338

    Basically a matrix is a CrossTab that gets auto generated on the fly. Seems like you are doing a sales report so it'd be something like the following, please excuse the ascii art...

    NAme | Qtr1 | Qtr2 | Qtr3 | Qtr4 | Total

    Bob | 1000 | 1500 | 500 | 0 | 3000

    Jane

    Bill

    Mary

    etc...

    It dynamically adds rows as the names change and also dynamically will add columns based on your column groups.

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • May 27, 2010 at 8:27 am

    #1173351

    Thanks again Luke.

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

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