Results 1 to 9 of 9
  1. #1
    2 Star Lounger
    Join Date
    Jun 2005
    Location
    Atlanta, Georgia, USA
    Posts
    208
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Subreport (2003)

    HI . I have a main report based on a football game where game id is the pk. This main report shows game detail such as ooponent data and such along with quarterback detail. I have a subreport that I want to have the reciver info for that same game. When I put that subreport on the main report it duplicates. For instance the main form has 2 QBs and on the report it shows 1 qb detail then receiver subreport then the other qb and the same receiver subreport. I am pretty sure it is in the grouping. Also I will add another subreport that has the players and their rushing info. Any thoughts?

    Ben

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Subreport (2003)

    Hi Ben

    Difficult to say. Is there any chance you can attach a sample of the database and we can have a look. Being from the <img src=/S/flags/UK.gif border=0 alt=UK width=30 height=18>, I will do my best to assist, but may need help with the American football terminology
    Jerry

  3. #3
    4 Star Lounger
    Join Date
    Jan 2002
    Location
    Brookings, South Dakota, USA
    Posts
    449
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subreport (2003)

    American football terminology <img src=/S/anigrin.gif border=0 alt=anigrin width=19 height=19>
    <IMG SRC=http://www.wopr.com/w3tuserpics/gdrezek_sig.jpg>
    "Those who dance are considered insane by those who can't hear the music" - George Carlin

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

    Re: Subreport (2003)

    Yes it is undoubtedly in grouping. If you are grouping by quarterback and have the receiver in either a next level group or in the detail, then it will behave exactly as you describe. If the receiver can differ between quarterbacks, then it is working the way you designed it. If the receivers should be listed for the game, rather than for the quarterback, you need to have a receiver grouping and put the subreport in that grouping, not in the detail. You'll need to post a stripped down version of your database with the queries and the reports/subreports involved to get it straightened out.
    Charlotte

  5. #5
    2 Star Lounger
    Join Date
    Jun 2005
    Location
    Atlanta, Georgia, USA
    Posts
    208
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subreport (2003)

    Here is a copy.

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

    Re: Subreport (2003)

    I'll take a look at it this evening, but I can see from a quick look at the table design that you went about it in a way that will make your reporting more difficult. More later.
    Charlotte

  7. #7
    2 Star Lounger
    Join Date
    Jun 2005
    Location
    Atlanta, Georgia, USA
    Posts
    208
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subreport (2003)

    I am early in the design process so I can go back and change the tables if needed. Any hints on the design of the table? Would it have been better to put all offfense in 1 table?

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

    Re: Subreport (2003)

    Here are a few suggestions:

    Have a players table with a PlayerID as the Primary Key. Then use that PlayerID to identify players in any other tables you might create rather than entering a new record for a player as a receiver, passer, etc. The basic rule of relational design, is not to enter data in multiplie places but to enter it once and use a key to refer to it elsewhere. I would also recommend not using cryptic field names in your tables. I assume that Int in the Passers table is Interceptions, right? It would make it easier for anyone else trying to decipher this if you spelled it out. Can players function in more than one role in a season? If so, then you really want to identify a player and his role for each game, not just put the player in a table of receivers or passers. That would give you much more flexibility. You could still have history tables, but each record would include a foreign key to identify the game and either a code or a foreign key to a Positions table that would identify the position that player played in the particular game. That would make it much easier to query the data out in the long run.

    Maybe some of the guys will come up with other relevant suggestions, since I'm not a football fan and don't remember much about the game from my schooldays.
    Charlotte

  9. #9
    2 Star Lounger
    Join Date
    Jun 2005
    Location
    Atlanta, Georgia, USA
    Posts
    208
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subreport (2003)

    I will try what you said. You made some good assumptions about football and you have a good grasp of the game.

Posting Permissions

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