Reports within Reports and only list 5 records

M

Michael Kintner

I have a report within a report. The report within I only want to see the
first 5 records. I have tried using the top command with no luck.
Sometimes I see 1 records when there are 20 and other times I see 100
records when there are thousands.

Any ideas on how to make this work?

Thank you in advance for any help,
Mike
 
W

Wolfgang Kais

Hello Miachael.

Michael said:
I have a report within a report. The report within I only want to see
the first 5 records. I have tried using the top command with no luck.
Sometimes I see 1 records when there are 20 [...]
Click to expand...

That's 5 percent...
[...] and other times I see 100 records when there are thousands.
Click to expand...

.... if there were 2 thousands, that was also 5 persent.
Any ideas on how to make this work?
Click to expand...

You maybe have used "Top 5 percent". Try "Top 5" instead.
Maybe you can post the query/control settings?
 
Top