Post reply

Multiple subtotals (PrYr Total, QTD, and YTD)

  • December 5, 2008 at 4:43 pm

    #196874

    I am creating a report that shows the amount spent on a particular project. I need to show amount expended through previous year, QTD, YTD, and TotalSpenttodate on one line. I dont know if I should try to do the subtotals in the dataset or on the report itself.

    I have one table named

    PROJECT that has fields projectID, project title,amountapproved, dateapproved..etc.

    Then another table called

    SPENDING that has fields SpendingID, projectID, Datespent, spentamount, etc...

    I will have 2 parameters the Start Date and End Date which will coincide with a Quarter(eg. 4/1/2008 to 6/30/2008)

    The report will show the project title, project ID, and then the different subtotals on one line per project.

    Let me know if more info is needed.

    thanks!

  • December 6, 2008 at 4:57 pm

    #908871

    Two things... first, post the code that you've tried. Second, if you want a better answer quicker, please see the link in my signature line below. 😉

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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