dynamic view
From: ck <reachgopi_at_yahoo.com>
Date: 7 Dec 2002 16:31:36 -0800
Message-ID: <ef13ca67.0212071631.1c19f629_at_posting.google.com>
Date: 7 Dec 2002 16:31:36 -0800
Message-ID: <ef13ca67.0212071631.1c19f629_at_posting.google.com>
Project F code DSAA 0012 DSAB 0013 DSAC 0013
Activity Table
Activity Activity Value 1000TA 12 2000TA 13 3000TA 14
Activity Def Table
Owner Activity name DS ASD DS AFD DS PFD DO ASD DO AFD DO PFD Right now this table has 51 records. In future there chance it mightincrease to infinite number of rows. Each row I this Table has related value in the Activity Table. I want dynamic code in the View so that when ever this table is updated it should reflect in the results.
This how the Result should look like-
Project Activity ASD AFD PFD Activity ASD AFD PFD DSAA 1000TA 12 12 12 2000TA 13 13 13 DSAB 1000TA 12 12 12 2000TA 13 13 13I want the values to be displayed as a cross tab. The rows in the Activity Def and Activity Tables should be displayed as columns in the Result. Each Activity Name in the Activity Table will have a record in the Activity Table.
Thank You Very Much,
ck
Received on Sun Dec 08 2002 - 01:31:36 CET