Jump to content

How do I output all data lines when data exceeds 25k line limit?

Recommended Posts

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

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.

  • Like 1
Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...