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!
Find Currently Available Items By Lexile Range.rdl (28.2 KB)
Find Currently Available Items By AR Range.rdl (28.1 KB)