Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Dec 2007
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    columns in report (2000)

    I have a report that I made columns in using bound controls (no labels) and the page setup columns option. But I need a column of "lables" to print only once on the left side of the report.

    Ex.
    Facility (label) Fac. 1 Fac.2 Fac.3
    question 1(label) 5% 10% 20%

    I only have a report header & footer, and detail section.

    Any ideas?

  2. #2
    Star Lounger
    Join Date
    Sep 2001
    Location
    SC, USA
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: columns in report (2000)

    I would not add any labels in this case, but add three unbound text boxes in the detail section. The first will count the detail records (Control Source =1
    Running Sum Over Group
    Visible = No).
    Name this first box "CounterBox". The next two textboxes use an if statement as the control source. Second textbox: Control Source =IIF([CounterBox] = 1, "Facility", ""). Third textbox: Control Source =IIF([CounterBox] = 1, "question 1", ""). The second and third textboxes will now be your labels, and will only show up for the first detail on each page. Note: in the if statements above, the second argument is quotequote(no spaces). Set the font on textbox two and three, anyway you like, to get the desired visual results. <img src=/S/chatter.gif border=0 alt=chatter width=38 height=16>

  3. #3
    New Lounger
    Join Date
    Dec 2007
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: columns in report (2000)

    Thanks so...this worked beautifully!

Posting Permissions

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