Results 1 to 4 of 4
  1. #1
    Join Date
    May 2003
    Posts
    26

    Unanswered: Reports using a crosstab query

    How do you create a report which uses a crosstab query that contains parameters to filter the data. How do you know which columns to include?

  2. #2
    Join Date
    May 2003
    Posts
    144
    Here are the options that I know.

    1.) Adding columnheadings
    2.) Unbound all labels and controls and set the caption and control source on report open

    Hope this helps.

  3. #3
    Join Date
    May 2003
    Posts
    26
    Thanks for your response. The record source is a crosstab with over 72 months of monthly data and is also filtered by job. As I will never know what months are going to be listed for a particular job how would I know which column headings to use?

  4. #4
    Join Date
    May 2003
    Posts
    144

Posting Permissions

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