Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Paradox- Report , Group, Count of Records(rows) per group 1

Status
Not open for further replies.

elevator

Programmer
Apr 23, 2002
19
0
0
US
Hello. Here I am again, LOL
Paradox- Report , Group, Count of Records(rows) per group

Below is the report i am trying to come up with.

-----------
Video Type
-----------
D
-----------
D
-----------
D
-----------
D = 3

------------
V
------------
V
------------
V = 2
------------
D = 3
V = 2
 
Elevator,

You'll need a report with at least one group on the Video Type field.

To get the summaries you want, start by placing a summary calculated field object in the group footer. This will give you the individual group totals.

To get the overall summary totals, you've got a couple of choices You can:

1) Save calc count all query with the Video type field checked. Include that (yes, the QBE file) in the report's datamodel and then bind a table frame to it in the report footer.

2) Drop a crosstab in the report's footer. It'll pretty much do the same thing.

Hope this helps...

-- Lance

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top