rajeshgoni
Programmer
Hi!
I need help with creating dynamic columns off a crosstab query.
Any hints appreciated.
Rajesh.
I need help with creating dynamic columns off a crosstab query.
Any hints appreciated.
Rajesh.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Create dynamic columns off a crosstab query
- Thread starter rajeshgoni
- Start date
- Status
Raj,
The concept of a crosstab is that the columns *are* dynamic, ie one new column for every value of the table field chosen for the column heading. You can dynmaically change the *sql* for a crosstab to use different a different table field (or say, a different grouping on the column), and you can follow the pivot with an IN() clause to force certain columns, ie your data has only 10 months of data, but you want to show just an empty column for the missing 2 months.
I may have misunderstood your post, let me know if this is what you wanted to hear.
--Jim
The concept of a crosstab is that the columns *are* dynamic, ie one new column for every value of the table field chosen for the column heading. You can dynmaically change the *sql* for a crosstab to use different a different table field (or say, a different grouping on the column), and you can follow the pivot with an IN() clause to force certain columns, ie your data has only 10 months of data, but you want to show just an empty column for the missing 2 months.
I may have misunderstood your post, let me know if this is what you wanted to hear.
--Jim
- Status
Similar threads
