Reports in V4 for schools and list participants

#1

Hi!

We upgraded to V4 for this years reading program (summer 2019). We send the schools a list of all the kids who registered for the summer program and a list of all the kids who finished. We did this in v3. It was easy to run that report and email the excel sheet with the list of participants. I am looking at the reports area for v4 and I cannot find a way to run a report list like this now. I can only get the number of total kids by school. This is a huge issue. Is there a way to do this? The kids who participate get a party at the school and I hate to mess that up.

#2

When we implemented reporting in version 4 we were careful to avoid reports that would divulge too much information about individual participants (and minors) as we end up having a lot of users across a lot of library systems with access to run reports in our program.

This data is in the database, you could extract it with a database query if you have access though that’s a little more technical. Alternately, we could add in a report that would produce this for you.

A few questions:

  1. Are you using 4.1.1?
  2. How challenging will it be for you to update the code in your installation?
  3. It seems like you don’t need this report until the end of the program, is that accurate?

Let us know and we’ll do what we can to help!

#3

Hi!

We could use some help with our reports for our school system. They actually need to names of the kids/teens who participated and finished the program. They not only throw a party for those kids, but they also include it in their progress reports. I understand
it is a security issue, but no one has the authority to pull reports but myself, IT and the director. We are bound by state law to uphold patron information. In addition, the schools have state law permission to see the SRP results. We know they finished
by the special badge they got by reading 750 minutes.

We are running 4.1 version. We
can easily change the code of the installation if you they have instructions to do so.

We just need a way to run a report by school name the list of names of kids who registered and how many earned a specific badge.

Thank you for your help in this. We had our best summer ever and have so many amazing comments from patrons about the GRA.

Adrianne Junius

#4

Do you have the ability to run queries directly against your SQL Server database with SQL Server Management Studio? With that you could either cut and paste into Excel or output directly to a CSV file. You could do that immediately with the right query without having to update any code.

Alternately we can build a quick report and send you updated code.

Let me know, the former is going to be much quicker than the latter but we’ll do our best to help you either way.

#5

My IT is asking if you could let us know what the quires are?

We need to run a report of a list of names of kids who signed up by school
and a list of kids and teens who finished 750 minutes by school. My email is ajunius@hallcountylibrary.org Thank you for your help in this.

#6

Here are a few queries. Let me know if this produces what you are looking for:

Signed up:

SELECT u.[FirstName]
	,u.[LastName]
	,s.[Name] [School]
	,u.[PointsEarned]
FROM [Users] u
INNER JOIN [Schools] s ON s.[Id] = u.[SchoolId]
ORDER BY s.[Name]
	,u.[LastName]

Achieved 750 points or more (can be through reading minutes, challenges, etc.):

SELECT u.[FirstName]
	,u.[LastName]
	,s.[Name] [School]
FROM [Users] u
INNER JOIN [Schools] s ON s.[Id] = u.[SchoolId]
WHERE u.[PointsEarned] >= 750
ORDER BY s.[Name]
	,u.[LastName]

Read 750 minutes or more:

SELECT u.[FirstName]
	,u.[LastName]
	,s.[Name] [School]
	,u.[PointsEarned]
FROM [srp19].[dbo].[Users] u
INNER JOIN [Schools] s ON s.[Id] = u.[SchoolId]
WHERE u.[Id] IN (
		SELECT ul.[UserId]
		FROM [UserLogs] ul
		GROUP BY ul.[UserId]
		HAVING SUM(ul.[ActivityEarned]) >= 750
		)
ORDER BY s.[Name]
	,u.[LastName]