Who's On?

	Membership:
	Latest: Davido75
	Past 24 Hours: 0
	Prev. 24 Hours: 1
	Overall: 5266

	People Online:
	Visitors: 300
	Members: 0
	Total: 300

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1375
Roger French	1315
mark.cook	1244

AR addins wont return all the rows

2 Replies

0 Subscribed to this topic

1 Subscribed to this forum

Sort:

Author

Messages

David Hersh

New Member Send Private Message

Posts: 0

3/17/2010 4:50 PM

Hello,

I'm using the Excel Addins to query a form (AR90.1) and while I do receive data, I only return 11 rows. I know the data query should return a few hundred rows. I've set the number of rows limit to 9999 and still not difference. Any ideas?

Brad Schauer

Veteran Member Send Private Message

Posts: 76

3/17/2010 5:43 PM

What is your "data retrieval timout preference" set to? The green and yellow arrow button at the top of the screen, second button from the right.

Brad

JonA

Veteran Member Send Private Message

Posts: 1163

2/2/2011 5:16 PM

If the query times out there would be no data return. This is an older post so I'm guessing that you figured out the problem. But I would take a look at the criteria tab and make sure the selections are correct. One mistake I've made in the past is use the same >= for two criteria so I might say PURCHORDER-PO-DATE >= 20110101 AND PURHCORDER-PO-DATE >= 20110131 which would return PO data for Jan 31st up to today when I really wanted just Jan data. Just seems when I'm not getting the data I expect more times than not it comes down to the criteria selected.