remoore

Thats brilliant thanks. I will give this a go next time I pop into the office.

Good morning, I am looking to get some information out of SIMS to help the PTA at my daughters school, and also help the office staff. I am the husband of the PTA chair, and yesterday we spent about two hours going through class lists to send out raffle tickets so that each family only gets one set of tickets to sell regardless of how many children that family has at the school. This was a pain so this morning I asked the office staff if they had a report in SIMS configured to get this information. Turns out they don't but they would really, really like one! I am an IT professional and I could probably knock up the SQL for this in a couple of minutes, I test databases for a living so that's not going to worry me, however I am not going to get access to the back end of SIMS with a SQL client and I am not that familiar with the system. I have sorted a couple of problems out for the school, normally integration with ParentMail and once a user-rights problem but I could do with a quick primer on custom reporting, or a link to a manual, user guide etc. Any advice greatfully received Thanks, Ed Moore