Adrian Simpkins Posted March 6 Share Posted March 6 Hi All I am undertaking a review of our basic user data loaded to the system. Currently we have 44838 users loaded, so when I output the report data it is limited at 25000 lines so the customer data stops at jake.nice. How do i setup the report to output the 2 sets of data please? Need one with the 1st 25000 records, then a second one to output the other 19838 that go up to Z. Many thanks as always Link to comment Share on other sites More sharing options...
Steve Giller Posted March 6 Share Posted March 6 In theory ordering by a unique field will give you the first data set, and ordering by the same field in the opposite direction will give you the rest (with a little overlap.) If you go past 50,000 that's not going to work, but I'll leave that answer to someone with a better knowledge or Reporting. 1 Link to comment Share on other sites More sharing options...
Adrian Simpkins Posted March 6 Author Share Posted March 6 Thanks Steve, I will take a look at setting it that way to output the data Many thanks as always Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now