jyothsna

• May 15th, 2006

 

When you group data, Impromptu sorts the data item you are grouping and removes duplicatevalues. You can organize your report by grouping on one or more data items.By associating a grouped data item to another data item, you can eliminate duplicateinformation from your report.You can associate one or more data items with a grouped data item. An associated data itemshould have a one-to-one relationship with the grouped data item. For example, Order No. is agrouped data item. For each order number, there is an Order Date. Order No. and Order Datehave a one-to-one relationship.

Guest

• Jun 23rd, 2006

 

Group: used to eliminate duplicate values in the report.

Association: used with grouped item that displays data only when the values are changed.

ProctLine        ProductName        Quantity           Revenue

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

Soaps             LUX                     100                 1000

                                                200                 2000

                                                300                 3000

                    TIDE                      100                 1500

SHAMPOO      GARNIER                  100                 4000

                                                 200                 8000

                    SUNSILK                 100                  5000

--> Here, ProductLine is a grouped column and ProductName is an Associated column.

rkiranbedi

• Mar 27th, 2007

 

Group is used to Eleminate Duplicates

where as associate is used to make grouped item in one to one relationship manner.


ProctLine        ProductName        Quantity           Revenue--------------------------------------------------------Soaps             santoor                   100                    1000                                                      200                    2000                                                      300                    3000                        Lux                         100                   1500SHAMPOO        Chik                        100                   4000                                                       200                   8000                         Velvet                    100                    5000


Here Proct Line is applied by group.

and  Product Name is applied by Association.

rkiranbedi

• Mar 27th, 2007

 

group is used to eliniminate Duplicates,

Where as Association is used to make one to one relation ship between to columns.

ProctLine        ProductName        Quantity           Revenue--------------------------------------------------------Soaps             Rexona                     100                 1000                                                        200                 2000                                                        300                 1000           
                       Santoor                     100                 1500SHAMPOO       Chik                           100                 4000                                                        200                 8000                       Velvet                       100                  5000


here Produce Line is applied by Group
and   Product Name is applied by Association

sreenu007

 Profile Answers by sreenu007 Questions by sreenu007

• Jun 5th, 2010

 

GROUP is used to suppress the duplicate values having one to many relations.
Associate is used to suppress the values having one to one relations.