Results 1 to 11 of 11
  1. #1
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Landscape Query (XP/2K)

    I do not thnk there is any way to save this other than as a report, but you never know. Is there a way to save the landscape orientation of a query, or to force it to print landscape without the user choosing page layout through VBA?
    Thanks

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

    Re: Landscape Query (XP/2K)

    You're correct, tables and queries don't remember the page setting...

  3. #3
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Landscape Query (XP/2K)

    So maybe there is another way. I have used Getz Litwin and Gilbert's function for creating a crosstab report based on a query. However, there are two limitations. One- that before you start having the data value columns there can be only one row heading field. I know that I could cocantetate all the fields into one- but the client says that that is confusing.
    The other problem is that you are limited to some arbitrary number of columns.
    Any better ideas?
    Thanks

  4. #4
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Landscape Query (XP/2K)

    I see that therefore the printDevMode does not apply to tables or queries either?

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

    Re: Landscape Query (XP/2K)

    Crosstab reports with dynamic column headings were a popular subject in this forum, but I fear that all threads dealing with it have expired <img src=/S/sad.gif border=0 alt=sad width=15 height=15>.

    Would you like to create a report with a number of columns limited to what fits on one landscape page, or would you like the number of columns to be unlimited? I can find examples for either.

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

    Re: Landscape Query (XP/2K)

    Yes, PrtDevMode, PrtMIP and PrtDevNames apply to forms and reports only.

  7. #7
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Landscape Query (XP/2K)

    I need unlimited if you have such an example. But, I also need that the first 3 columns are not values but row headings. I think in Levitz etc. example that threw things off a bit.
    Thanks a million

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

    Re: Landscape Query (XP/2K)

    Most examples use only one row header, so they must be adapted for crosstab queries with more row header fields. You have to do this yourself, but it is less work than designing the whole report from scratch.

    Duane Hookom has created an example of a report with a potentially unlimited number of columns. You can download it from (for instance) Crosstab Report.

  9. #9
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Landscape Query (XP/2K)

    thanks. Of course this was on my computer already, I just forgot I had downloaded it.

  10. #10
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Landscape Query (XP/2K)

    I was thinking possibly of a different approach to the perennial problem of dynamic crosstab reports. IF you create a form in datasheet view then it would be the equivalent of a crosstab query with the additional advantage of the control of a form. You cannot however create the from based on the crosstab query and save it since the rows on the form are saved when you save the form as text boxes and they would not change as the data in the crosstab changes.
    BUT, if you could write a routine that would automatically create a datasheet view form based on the crosstab every time, then save it and manipulate the printing of the from that might work.
    IS that a logical approach to the issue?
    Thanks for insights into the approach before I start coding.

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

    Re: Landscape Query (XP/2K)

    Same question has been posted in a new thread. I'm locking this thread to avoid duplication and confusion; all reactions <!post=here,289127>here<!/post> please. Thank you,

Posting Permissions

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