Results 1 to 5 of 5

Thread: Report Experts

  1. #1
    Join Date
    Mar 2004
    Posts
    83

    Unanswered: Report Experts

    I'm needing to group sections of my report, but I'm not sure how to get all the info on the report (I can make seperate reports fine, but I'm lost when I try to combine them)

    I would like it to look like this:

    CPU Speed:
    <tab>1G<tab> Less than 1G
    Area1
    Area2
    Area3

    O/S:
    <tab>2000<tab> XP
    Area1
    Area2
    Area3

    AV:
    <tab> McAfee <tab>Norton
    Area1
    Area2
    Area3

    If I make a group footer of the areas I can use =Count(IIf...) statements to count the totals, but how on earth do I get the headers to appear only once above each secton?

    (sorry about the formatting, I hope I made it clear...)

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    I"m not sure I understand exactly what you want to do here.

    Do you want three seperate reports on the same document, or do you want to nest this stuff?

    Eg:

    CPU Speed
    .....O/S
    ..........AV

    vs.

    CPU Speed
    -------
    O/S
    -------
    AV


    The difference is in whether you can use grouping levels, or whether you'd be better served with subreports. If you're nesting, then of course you can go the grouping level route.

  3. #3
    Join Date
    Mar 2004
    Posts
    83
    Sorry, I'm not the best at explaining

    I would like the report to generate 3 seperate "blocks" of data on the same page. Each block contains the Areas (on the vertical column), and whatever else on the horizontal...a grid pattern. Now like I said, I can get ONE report to display fine, it's when I try and add the second one that I encounter problems.

    (Here's the report that works, Area Footer for the Data, Page header for "Norton Mcafee" heading)
    ________Norton______McAfree_______
    |Area1---=Count-------=Count--------
    |Area2---=Count-------=Count--------
    |Area3---=Count-------=Count--------
    __________________________________

    Now lets say in the print preview I want to add an additional one of these (2 total), but it's to display some different data....

    ________<1Gz PC______>1Gz PC______
    |Area1---=Count-------=Count--------
    |Area2---=Count-------=Count--------
    |Area3---=Count-------=Count--------
    __________________________________

    This is where I get lost...

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Are you currently using subreports? It sounds like you should be... is that what you're having problems with?

  5. #5
    Join Date
    Mar 2004
    Posts
    83
    I was not, thats exactly what I needed, thanks

Posting Permissions

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