J James Jul 7, 2006 #1 anyone know how to make a crosstab query'ed report automaticly add new columns?
G Guest Jul 7, 2006 #2 In the SQL statement add your column list like this -- PIVOT [YourTable].[YourField] In (1,2,3,4,5,6,7,8,9,10);
In the SQL statement add your column list like this -- PIVOT [YourTable].[YourField] In (1,2,3,4,5,6,7,8,9,10);
J James Jul 7, 2006 #3 how to have it automaticly add them to a report tho if a new column apears in the query... KARL DEWEY said: In the SQL statement add your column list like this -- PIVOT [YourTable].[YourField] In (1,2,3,4,5,6,7,8,9,10); James said: anyone know how to make a crosstab query'ed report automaticly add new columns? Click to expand... Click to expand...
how to have it automaticly add them to a report tho if a new column apears in the query... KARL DEWEY said: In the SQL statement add your column list like this -- PIVOT [YourTable].[YourField] In (1,2,3,4,5,6,7,8,9,10); James said: anyone know how to make a crosstab query'ed report automaticly add new columns? Click to expand... Click to expand...
G Guest Jul 7, 2006 #4 Prior planning. Add all that you will eventually have. Like days of the month, months of the year, etc. James said: how to have it automaticly add them to a report tho if a new column apears in the query... KARL DEWEY said: In the SQL statement add your column list like this -- PIVOT [YourTable].[YourField] In (1,2,3,4,5,6,7,8,9,10); James said: anyone know how to make a crosstab query'ed report automaticly add new columns? Click to expand... Click to expand... Click to expand...
Prior planning. Add all that you will eventually have. Like days of the month, months of the year, etc. James said: how to have it automaticly add them to a report tho if a new column apears in the query... KARL DEWEY said: In the SQL statement add your column list like this -- PIVOT [YourTable].[YourField] In (1,2,3,4,5,6,7,8,9,10); James said: anyone know how to make a crosstab query'ed report automaticly add new columns? Click to expand... Click to expand... Click to expand...
P Pieter Wijnen Jul 8, 2006 #5 Or programatically deal with new controls (Createreportcontrol) Pieter KARL DEWEY said: Prior planning. Add all that you will eventually have. Like days of the month, months of the year, etc. James said: how to have it automaticly add them to a report tho if a new column apears in the query... KARL DEWEY said: In the SQL statement add your column list like this -- PIVOT [YourTable].[YourField] In (1,2,3,4,5,6,7,8,9,10); : anyone know how to make a crosstab query'ed report automaticly add new columns? Click to expand... Click to expand... Click to expand... --
Or programatically deal with new controls (Createreportcontrol) Pieter KARL DEWEY said: Prior planning. Add all that you will eventually have. Like days of the month, months of the year, etc. James said: how to have it automaticly add them to a report tho if a new column apears in the query... KARL DEWEY said: In the SQL statement add your column list like this -- PIVOT [YourTable].[YourField] In (1,2,3,4,5,6,7,8,9,10); : anyone know how to make a crosstab query'ed report automaticly add new columns? Click to expand... Click to expand... Click to expand... --
