report the # of times a name appears in a field

[rankhornjp]

Have you tried shrinking your detail section of your report down to 0, or if it already is 0 playing with your margins, it's kind of impossible to tell what you mean by 'the multiple pages'

I took out all the text boxes and set the detail area to 0x0. In print preview it only shows 1 blank page. A detail area bigger that .5x.5 creates 2 pages.

I don't know what to do with this information......

[rpeare]

I really don't know what you're talking about, can you post a sample database with fake data?

[rankhornjp]

I don't know what's so hard to understand. I want the report to print 1 page, it is printing more than 1. The only way that it will print 1 page, is to have the detail area of the report smaller that 1/2 inch high. At that point there is no room to put anything in the detail area, so the report is blank.

I have created 20+ reports for this same database and have never come across this problem.

[rpeare]

Because the problem as you're describing it makes no sense to me and it would help to see an example of what you're doing so I can understand it. If you don't want to make an example database I'm not sure I can help you because I suspect it's a problem with your data source and how you're representing that data source on your report. If you don't want to make an example of your problem then good luck, maybe someone else can decipher your remarks where I can not.

[rankhornjp]

That comment helps....

Just now I created a new report via Create-Report Design. Print preview shows 1 page. I changed the Record Source to my query "qryGetDHRInformation". I didn't change anything else. Now print preview shows 14 pages, again.

The query is pulling information from 2 tables. 1) "People": has name, address, date seen, referral source, service performed, etc (47 total fields) 2) "SysVar" has: from date, thru date, and version.

If I edit the query and remove the SysVar table, the only thing that changes is the number of result due to not being filtered by date.

I don't have any critiera set. The query just pulls Name, DOB, Date enrolled, Date terminated, Date completed, Referral source, Referral source id#, Race, What service they enrolled in.

Some of these fields will be blank. i.e. if a person has enrolled, but hasn't finished/been terminated. The Completed and Terminated fields will be blank.

Hopefully this helps you understand better what is going on.

Thanks for your patience

[rpeare]

it doesn't. The only thing I can think is that you are not linking your tables correctly in the query driving the report, but again, with no example to work with I can't really say. If your query is a cartesian query (the tables are unlinked) you will get a number of records is equal to the number of items in the first table times the number of items in the second table and if your detail section is even .00000001 mm wide that could make it appear as though you are printing on blank pages. Again, without an example of what you're doing I'm sort of shooting in the dark.

[rankhornjp]

Ok, i pulled the "people" table, query and report into this database. The query has 3 results, the report has 3 pages that show the same information.

[rpeare]

can you post a 2003 or prior version please. I do not have access to 2007+ all the time.

[rankhornjp]

Here ya go.

[rpeare]

I think this one is fairly simple. You've put a summary matrix in the DETAIL section of your report (you'll note in previous posts I said the detail section should have a width of 0). If you put in a REPORT FOOTER and move your current fields to that section of the report and shrink the detail section to 0 width (click on the bar at the bottom of the detail section and move it all the way up to the bar above it) then you should have no more trouble.

[rankhornjp]

that fixed it. Thanks.