database analysis report

[kfenner]

Here I go again. Once again, please excuse the fact that I am a novice having to figure all this out by myself.

I have a database I work with that was originally built in Paradox 4.5.(I did not build this database) It has since been moved to Paradox 10. Needless to say, any reports etc...did not successfully move with it. There was an analysis report built in 4.5 which gave you total number of records where certain fields contained specific information or were populated. So, basically, it counted records for you that the information contained in them met certain criteria. I hope I am explaining this so someone will understand. I need to build a report that doesn't show me record and field information, but tells me how many records there are in the database, that contain certain information.

Anyway, I have not figured out a way to build this type of analysis report in Paradox 10. Can anyone point me in the right direction. Thanks!

 

[footpad]

kfenner,

You're looking for a summary report. Build the report as you would if you were printing the individual items, but place the summary objects in group (or page) footers.

When you've got the detail report working they way you want, remove the items in the Record band and then resize the Record band so there's nothing between the borders.

That will give you the summary report you're looking for.

Hope this helps...

-- Lance

 

[kfenner]

Ok, I seem to be getting this method to work, but am having one other problem. When I have more than one summary object in a header, I set a filter to one of them, but it is filtering all of the summary objects that are there. Why is this happening?

Example:

Report has all claim records on it. Summary object to tell me how many claim records and summary object to tell me total dollar amount of all claims. Set filter on first filter to only count claims that are "class 3" but then my dollar amount summary then only adds the "class 3" claims instead of all claims, like it did to begin with.

I'm not very good at explaining this I'm afraid.

Thanks for the help!

 

[footpad]

kfenner,

You're seeing the documented behavior of filter. If you only want one summary to be "filtered," you're better off running a query and then opening the report on the resulting Answer table. This lets you limit the records in the master table while taking advantage of your full detail tables.

There are a couple of tutorials on my site that show how to do this. Please see

http://techtricks.com/paradox/btntutor.php

for an introduction to the basic techniques and

http://techtricks.com/paradox/printone.php

for some alternate approaches.

Hope this helps...

-- Lance