Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Jul 2005
    Location
    North Carolina, USA
    Posts
    195
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Making Own Report Template Wizard (2003)

    Hi, I know this sounds kind of crazy. I have some crosstab queries that I will like to create a permanent report when a new month or date is added to the crosstab. I don't want to keep inserting the new fields to the crosstab report every time with new info. My queries are crosstab by date on the column heading and the events on the row heading, the amount of hours is the value that display in the intersection of the fields. I have the label of the fields on the page header of the report, and the other info. on the details. Any suggestions is appreciated.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Making Own Report Template Wizard (2003)

    You need VBA code to handle a crosstab query in a report. If you search for dynamic crosstab report in this forum, you will find several threads dealing with this subject. For example, you might have a look at the databases attached to <post#=35485>post 35485</post#> and <post#=134439>post 134439</post#>. They demonstrate two different approaches to creating reports based on crosstab queries with dynamic column headings. Another example can be found in <post#=248210>post 248210</post#>.

  3. #3
    2 Star Lounger
    Join Date
    Jul 2005
    Location
    North Carolina, USA
    Posts
    195
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Re: Making Own Report Template Wizard (2003)

    I follow the answer from post 35485, the only thing I can not figure out is to get the subreport with custnames go horizontally instead of vertically.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Making Own Report Template Wizard (2003)

    Open the subreport in design view.
    Select File | Page Setup.
    Activate the Columns tab.
    Select "Across, then Down".
    Click OK.
    Save the subreport.

  5. #5
    2 Star Lounger
    Join Date
    Jul 2005
    Location
    North Carolina, USA
    Posts
    195
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Re: Making Own Report Template Wizard (2003)

    I got it finally, the whole process of the crosstab report. Thank you again for the help. Have to be very careful with the naming and source controls to make it work.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Making Own Report Template Wizard (2003)

    Yes, it's tricky. Congratulations on getting it to work!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •