Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

make a crosstab query'ed report automaticly add new columns?

Discussion in 'Information Technology' started by James, Jul 28, 2006.

  1. James

    James
    Expand Collapse
    Guest

    anyone know how to make a crosstab query'ed report automaticly add new
    columns?
     
  2. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    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" wrote:

    > anyone know how to make a crosstab query'ed report automaticly add new
    > columns?
    >
    >
    >
     
  3. James

    James
    Expand Collapse
    Guest

    how to have it automaticly add them to a report tho if a new column apears
    in the query...

    "KARL DEWEY" <KARLDEWEY@discussions.microsoft.com> wrote in message
    news:803F4AEA-3F97-42AE-B977-79A0A8EB88A1@microsoft.com...
    > 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" wrote:
    >
    >> anyone know how to make a crosstab query'ed report automaticly add new
    >> columns?
    >>
    >>
    >>
     
  4. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    Prior planning. Add all that you will eventually have. Like days of the
    month, months of the year, etc.

    "James" wrote:

    > how to have it automaticly add them to a report tho if a new column apears
    > in the query...
    >
    > "KARL DEWEY" <KARLDEWEY@discussions.microsoft.com> wrote in message
    > news:803F4AEA-3F97-42AE-B977-79A0A8EB88A1@microsoft.com...
    > > 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" wrote:
    > >
    > >> anyone know how to make a crosstab query'ed report automaticly add new
    > >> columns?
    > >>
    > >>
    > >>

    >
    >
    >
     
  5. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    Or programatically deal with new controls (Createreportcontrol)

    Pieter

    "KARL DEWEY" <KARLDEWEY@discussions.microsoft.com> wrote in message
    news:E64B1D84-DAD1-4757-9579-C51A52C21242@microsoft.com...
    > Prior planning. Add all that you will eventually have. Like days of
    > the
    > month, months of the year, etc.
    >
    > "James" wrote:
    >
    >> how to have it automaticly add them to a report tho if a new column
    >> apears
    >> in the query...
    >>
    >> "KARL DEWEY" <KARLDEWEY@discussions.microsoft.com> wrote in message
    >> news:803F4AEA-3F97-42AE-B977-79A0A8EB88A1@microsoft.com...
    >> > 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" wrote:
    >> >
    >> >> anyone know how to make a crosstab query'ed report automaticly add new
    >> >> columns?
    >> >>
    >> >>
    >> >>

    >>
    >>
    >>




    --
    ----------------------------------------
    I am using the free version of SPAMfighter for private users.
    It has removed 4182 spam emails to date.
    Paying users do not have this message in their emails.
    Get the free SPAMfighter here: http://www.spamfighter.com/len
     

Share This Page