I caught a ticket from one of the libraries I work with and they asked for a way to find items by Lexile and/or AR scores, specifically items that were currently checked in. I couldn’t find a great way to do this in Leap or the PowerPAC (we don’t currently use Vega Discover) so I wrote up two reports for SSRS that do what they asked.
Simply put, the user can run the report and select a branch, lower score, upper score, and get their item list.
Now, for our MARC records, the Lexile and AR scores are kept in the 521 tag, FirstIndicator = 8, sub a. Anyone using these reports will likely need to modify the data source and the code that pulls in your Organizations, because I had to exclude a bunch of OrganizationIDs that are no longer in use.
Happy hunting!
Edit: I updated these files on August 10, 2026. If you grabbed them before that, you may want to pick up these newer versions.
Find Currently Available Items By AR Range.rdl (28.9 KB)
Find Currently Available Items By Lexile Range.rdl (28.2 KB)
