Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003

    Unanswered: Turning Crosstab queries into Reports


    I was hoping I could get some help on the following.

    I have created a crosstab query. When it is run it requests the user to type in two parameters (Subcategory and Recovery Class)that determine the rows and the columns. The query works fine. Now I want to turn this crosstab query into a report so that I can format it appropriately. The problem is when I go to the report wizard, select my crosstab query, and click next, NO FIELDS show up. They have all vanished. Do you know what the problem is? Do I have to do some sort of parameterization for the report. To get the cross tab query I had to enter parameter types for the user inputs.

    Please note that I am looking for a dynamic solution since the number of rows and columns will change depending on the user inputs.

    Thanks in advance.


  2. #2
    Join Date
    Nov 2003
    AS far as i know Cross tab queries don't port over to reports. Why not use regular Select query you the report part? With a little bit of work you should be able to create the look you want.

Posting Permissions

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