When you choose "Tools > Reporting", are you in search mode with search criteria specified, or are you in modify mode with the results of the query displayed? If the latter, then you will only get the records you have selected in the results list as the output.
I've had some users get confused about that.
Thad
"Perfection is achieved, not when there is nothing more to add, but when there is nothing left to take away." - Antoine de Saint-Exupéry
| "Mike White"
<[EMAIL PROTECTED]>
Sent by: "Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG> 08/16/2006 09:23 AM
|
|
"I'd tried so many things, it was hard to determine why it runs ok now"
should give you pause.
That said, my first guess would have been to check your User Tool setting -
Tools=>Options=>Behaviors, checkbox labelled Limit Number of Items Returned
(which by default, is 1000). It sounds like ou've already addressed it,
though.
My next guess would be row-level security. There are a number of ways to
implement row-level security - group access to Field ID 1, possibly using a
dynamic or computed group. If you used an Administrator userid, you should
see all records, though. For a row-level security issue, it also wouldn't
make sense that the record counts to change based on how the results are
sorted.
It'll be difficult, maybe impossible to isolate the fault if you've made
changes without testing each individual change. "Something" fixed it, but
you don't know what, which would have given you a clue as to the underlying
cause.
Mike White
Office: 813-978-2192
E-mail: [EMAIL PROTECTED]
"GoDario27"
<[EMAIL PROTECTED] To: arslist@ARSLIST.ORG
A.COM> cc:
Sent by: "Action Subject: Report does not return all records!
Request System
discussion
list(ARSList)"
<[EMAIL PROTECTED]
ORG>
08/16/2006 10:32
Please respond to
arslist
I have a Remedy form that I use Tools > Reporting to pull back assets. The
problem is...
When I run the report, it shows me how many records it's exporting to
csv....i.e, 1 of 1125 (and you see the little "progress" bar as it
exports).
However, it only spits out, say, 379. Now, based on what I sort by, it
always returns a different number, say 792 or 1101. I cannot figure out
how
to export the entire 1125 records.
I have tried sorting on key/unique fields, etc. I have also modified my
settings on the client to return unlimited.
I have been able to pull back all records on one particular report that I
run, but it was hard to get it to do it. I'd tried so many things, it was
hard to determine why it runs ok now (I've saved it) and why it didn't
before (because I know I'd tried those settings in the past).
Anyhow, now I have a different report I need to run (due to the Dell
recall)
and it's doing the same thing.
Any suggestions would be greatly appreciated.
--
View this message in context:
http://www.nabble.com/Report-does-not-return-all-records%21-tf2115681.html#a5833558
Sent from the ARS (Action Request System) forum at Nabble.com.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
==============================================================================
IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature.
==============================================================================
