Summary Columns

rbuser

I'm looking to produce a summary report of information where the columns of
the report are a sum total by year for each line item. We are looking to
get a summary of usage for a decade by year for each of our inventory items.

The report should look something like this:

Inventory ID 2010 2009 2008 . . .
------------- ----- ----- -----
ID #1 90 105 37
ID #2 5 16 10

Where the number 90 is the summary of usage in the 2010 for inventory ID#1
and so on. There are lots of transactions that need to be summed up.
Perhaps 150,000 per year.

Can / should this be done with with a 'canned' reportbuilder report or is an
aggregate table needed?

Thanks for your consideration - Jon Gray

Delphi 2007 / Report Builder Server 12.02

nicocizik

Hi Jon,

The easiest way to create this report would be to let the database handle
the calculations and create a aggregate table as you mention. This would be
as straight forward as creating the table, connecting it to a simple report,
then displaying the summary data as needed.

It is possible to make such calculations from within a report however with
the amount of data you will be processing, it is not recommended. It would
basically involve traversing all the transactions and manually calculating
the sums for each ID# using TppVariables.


Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com