how do I do this?

[Elliott]

my client has a suite of programs which support a semi-annual trade show
the show has an ordering component
the customers can order product before the show, then can order more at the show
there are reports for both customers and the booth personnel (sellers), which show activity both ordered online before the show and what was ordered at the show
if the customer attends the show and orders that order replaces the online (at each booth they visit)
since the requirement is to show all online activity as well as all show floor purchases the total at the bottom cannot be a sum of both, because of the overlap
anyway, the reports basically look like this

Show Activity
first store,booth,department, etc
next store,booth,department, etc
total show activity

Pre-show orders
first store,booth,department, etc
next store,booth,department, etc
total pre-show activity

any ideas on how to show sum show activity + all pre-show that has not been supplanted?

[Stef]

Hi Marianne,

From the description it is not clear what data structure is present and what output is required. Basically it depends on your data and requirements how and where the total is calculated. This calculation can be performed on report level with functions and expressions, or on data level - custom calculations, sql queries.

If you need further help, please elaborate on your data structure and report layout.

Greetings,
Stef
the Telerik team

[Elliott]

Stef

thanks for answering the post
there actually are 4 different reports but they all have as a grouping show vs online - with subtotals
the data being fed looks like this:
number (store,department,booth,etc), qty, qty*unit cost, show or online indicator

I was wondering if it was possible to create a second table in SQL of the online orders supplanted by show orders - and how to access that data in the report footer (in code, if need be)

[Stef]

Hello Marianne,

As described in the Report Structure help article, you cannot use data bound items in the page header and footer. What you can use is the PageExec function and get the running value for a specific item. If you have filtering of orders from pre-order and show, it is better to perform this on data level and just have the field in the data source. Another approach is to calculate the total based on the passed data with custom user-defined function or user aggregate function, e.g. the attached sample report (run it in a ReportViewer control).

I hope this will point you in the right direction.

Kind regards,
Stef
the Telerik team