Results 1 to 10 of 10
  1. #1
    2 Star Lounger
    Join Date
    Sep 2002
    Location
    East Coast(USA)
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    report design (Access 2k)

    Hello,
    I have a crosstab query based report in Access 2000.

    1. Is it possible to make every other row shaded in a report?
    2. How do you add graph/chart or percent (%) to a report, which is based on the result of a query?

    Thanks,
    DD

  2. #2
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post

    Re: report design (Access 2k)

    I'm clueless about Question 2, but here's whatcha do about alternate line shading. (I owe all this to Helen Feddema's excellent book, Access 2002 Inside Out, page 295.)

    Select the Detail section of your report. Choose the Event tab of the Properties sheet and put the following code in the OnFormat event:

    Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    Const vbLightGrey = 12632256
    If Me.CurrentRecord Mod 2 = 0 Then
    Me.Section(acDetail).BackColor = vbLightGrey
    Else
    Me.Section(acDetail).BackColor = vbWhite
    End If
    End Sub

    One more thing: If you print your report on an HP 900-series inkjet printer, you'll get the shading only if you print at the "Normal" quality setting or higher. (This same advice may apply to other makes and models, but this is the one I have experience with.) At my job, we delight in printing in "Draft" mode to save ink. The results are quite acceptable, and the printing speed is remarkably faster than at Normal quality. However, I just about lost my professional military bearing before I figured out why we weren't get any shading!

    HTH!

  3. #3
    2 Star Lounger
    Join Date
    Sep 2002
    Location
    East Coast(USA)
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: report design (Access 2k)

    Lucas,
    Thank you for your reply. It worked, except that the grey shade goes beyond my table (both left and right side). My report is in a table, almost looks like Woody's lounge where you have alternate line shadings.

    Thanks,
    DD

  4. #4
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: report design (Access 2k)

    I tend to use vbYellow instead of vbLightGrey, it gives a softer shading on laser printers than vbLightGrey.

  5. #5
    Star Lounger
    Join Date
    Jun 2002
    Posts
    98
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: report design (Access 2k)

    RE: adding a chart to a report

    Use the Chart Wizard (Insert...Report...Chart Wizard) to create the chart based on your query.
    You'll end up with a report. Make it lovely and save it. Close it.
    Open the main report in Design View.
    Drag the Chart report onto the page footer area of the main report.
    __________________________________________________ ____
    <img src=/S/nun.gif border=0 alt=nun width=20 height=20> Sister Dory
    Our Lady of Perpetual Help, Holstein Falls, Wisconsin, USA

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: report design (Access 2k)

    Most of us have who do a lot of development have discovered that trick with laser printers, Pat, and it never hurts to call it to everyone's attention. It works nicely for both greenbar-type line shading and inserting faint lines between groups of records on reports.
    Charlotte

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: report design (Access 2k)

    If you don't want the shading all the way across the report (I assume that's what you meant by going beyond your table), then you can't change the backcolor or style, you have to use a control behind your data controls and turn its visiblity off and on instead.
    Charlotte

  8. #8
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: report design (Access 2k)

    Be aware that there is a potential problem using MS Graph within an Access report. See KB article 318079 .
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

  9. #9
    Star Lounger
    Join Date
    Jun 2002
    Posts
    98
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: report design (Access 2k)

    Potential problem using MS Graph within an Access report? Mood swings, fatigue, irritability, and hair loss are all I've heard about. Thanks for the link. <img src=/S/wink.gif border=0 alt=wink width=15 height=15>
    __________________________________________________ ____
    <img src=/S/nun.gif border=0 alt=nun width=20 height=20> Sister Dory
    Our Lady of Perpetual Help, Holstein Falls, Wisconsin, USA

  10. #10
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: report design (Access 2k)

    Don't forget nail-biting and bed-wetting! <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Charlotte

Posting Permissions

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