Post reply

sumarizing data outside report parameters

  • September 11, 2008 at 11:56 am

    #382625

    Very new to sql and vb - self taught so far, please excuse the inexperience and lack of knowledge. I have found many solutions here so far, thanks to all. Any help with this is greatly appreciated.

    In a parameterized (startdate and enddate) report, is there a way to summarize data outside the parameters?

    I am reporting on number of events started within a week or month and want to also include a count of the total number of events started project to date, year to date, month to date, which fall outside the parameter.

  • September 11, 2008 at 3:02 pm

    #870656

    Hello,

    There are several ways to go about this.

    One way is to build a working table with a row id and a column of say 500 characters.

    create table workTable

    ( rowId int identity,

    outputString varchar(500) null )

    In the first pass through your logic, you build the data and insert the results into the working table outputString column.

    Then you run another bit of logic that does the YTD summary stuff and write it's results to the working table.

    Then your report can output the two groups of data in the way you want but usually you can use the rowId to just loop thru in the sequence you built them.

    Hope this helps.

    Regards,

    Terry

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

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