View Full Version : Report issues


Aleashia
05-02-2007, 01:01 PM
I have used a query to generate the report (I simply want to show a list of all computers which store a certain piece of software; which I have done).

Anyways, the report shows these details 3 times for some unknown reason? i.e. if there are 3 records it will show them nine times on the report. Is there an option or something which will ensure every entry is only shown once on the report?

Thanks =)

rainman89
05-02-2007, 01:21 PM
does the query only show it time? it sounds like there is a reference mess up that is causing u to get the multiple results for each record

boblarson
05-02-2007, 01:21 PM
If you are pulling data from multiple tables, you could have not set the joins. Also, you may be pulling data that has multiple entries, so you would want to use the grouping within the query to group the values.

Aleashia
05-02-2007, 01:35 PM
Ah I forgot the join, works now, my fault, normally I would of noticed that- thankyou!