Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Oct 2006
    Location
    Virginia, USA
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Dynamic Crosstab Report (2000)

    I am trying to create a dynamic crosstab report, something very new to me. I have checked the other posts on this subject and tried to modify the code to work for me, but I am obviously not able to do it. I would like the users to be able to pull this report based on any criteria selected on the form (various possibilities). I think I've got the criteria portion done. If I set the code to open the crosstab query instead of the report, it opens fine, but when the button is set to pull the report, I first get a "Type Mismatch" error and then I get a multi-page report with the report header, but no data. I have attached a small sample of the database and would appreciate any help I can get on this.
    Thanks,
    Tiffany

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

    Re: Dynamic Crosstab Report (2000)

    You should set a reference to the Microsoft DAO 3.6 Object Library and clear the one to the Microsoft ActiveX Data Objects 2.n Object Library in Tools | References... in the Visual Basic Editor.

    You should remove or comment out the line referring to txtTotal because there are no text boxes txtTotal1 etc. in your report. (The text boxes txtSubTotal1 etc. were originally in the group footer, they are now in the report footer. This makes their names a bit awkward, but they will still work.)

  3. #3
    New Lounger
    Join Date
    Oct 2006
    Location
    Virginia, USA
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dynamic Crosstab Report (2000)

    That did it - thanks for coming to my rescue yet again!
    Tiffany

Posting Permissions

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