Sub Report

[aimbc]

I have an Access Database that I am trying to pull a report for. I would like to analyze activities within a certain date(4/1/2001 and 6/30/2001).

A sample of the field in my database:
- Date
- Type of Activity
- Type of Patron
- Age

In my main form I've already selected the dates in which I would like to analyze from. Now in my subreport I would like to get a count of the different Activities, a count of the Type of Patron, and a count of the different ages all based on the selection from the main form(basically between those dates).

How would I go about doing this. I've tried setting up parameters and formula, but it's not working. I am not even sure if it's the right way. Or maybe subreport NOT the right way to do it....is there a better way?

Thanks in advance.

 

[kenhamady]

I would use a cross-tab for each analysis. This will re-summarize the data of the report any way you like. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.