It prints too much records!!

[deangelis]

Hi,
I'm using CR 8.5, VB6, MS Access 97 via Database Files.
I've in the details section of a subreport the data that i want to view. They are 4 field of the db:

table.tizio table.caio table.semprionio table.time

More over I want to visualize other field that are the result of a query of the db.
If I put these fields

query2.tizio query2.caio

in the report header or footer it prints only the first record of the query and in the details section it repeats n times every record, where n is the number of the record of the query.
Example:

details tizio caio sempronio bla
tizio caio sempronio bla
tizio caio sempronio bla
tizio caio2 sempronio2 bla2
tizio caio2 sempronio2 bla2
tizio caio2 sempronio2 bla2
RF query1 query2

If I put also the query's fields in the detail section it repeats the query's records n times (where n is the number of the record in the details section, no the query's records) alternating with the details record and repeating them m times (where m is the number of the query's records)
Example
details tizio caio sempronio bla
query1 query1.1
tizio caio sempronio bla
query2 query2.1
tizio caio sempronio bla
query3 query3.1
tizio1 caio1 sempronio1 bla1
query1 query1.1
tizio1 caio1 sempronio1 bla1
query2 query2.1
tizio1 caio1 sempronio1 bla1
query3 query3.1
.....
Is there a solution for this problem???
Thanks to all

Ciao da
N@poleone

 

[dgillz]

Check your subreport linking and this problem will most likely be resolved.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[deangelis]

I changed the linking between the varoius tables and also between the main report and the subreport. Now the result is this (putting the two query fields in the details section togethet with the other fields)

details query2
query2
query2
query2
query2
query2
tizio caio1 sempronio1 bla1
query2
tizio caio2 sempronio2 bla2
query2
tizio caio2 sempronio2 bla2

As yo can see the other field of the query is not displayed!!!

Ciao da
N@poleone