on the fly grouping 1

[jcisco]

Question I'm creating a report that needs to be grouped by either a product line, or a product type. and what i'm thinking is this: I want to have a VB form that lets user click a button that says group by product type, and another one that says group by product line. Now is there a way for me to create just one report, but pass in a value that says group by this or that, or even no grouping?

so basicly i need a way to group either on the fly(runtime). Is this possible?

cheers.
john

--------------

 

[bdreed35]

Create a parameter. You can pass in the value to set the parameter from your VB app.
Create a formula like this:

if {?param1} = "Product Type" then
    {table.product_type}
else
    {table.product_line}

Now Group on this formula instead of one of the 2 fields.

~Brian

 

[jcisco]

Sweet that worked!
i'm very happi now! no more million reports!


You get a star!

--------------