+ Post New Thread
Results 1 to 4 of 4
MIS Systems Thread, [SIMS] Applicants report[SOLVED] in Technical; I am trying to run design a report that is the same as the data collection sheet but I want ...
  1. #1
    ChrisH's Avatar
    Join Date
    Jun 2005
    Location
    East Lancs
    Posts
    5,013
    Thank Post
    120
    Thanked 283 Times in 261 Posts
    Rep Power
    108

    [SIMS] Applicants report[SOLVED]

    I am trying to run design a report that is the same as the data collection sheet but I want to run it on our applicants for year 2010 year 7s. This is so they can be checked by the prospective parents. I have no problem targeting the right group etc but I cannot get any multiple record sets to work. I have got as far as contacts and it will only return the first contact. If I try the same template on an "On Roll" group all the contacts show up fine. I have double checked the records to see that certain records have multiple contacts and they do. I have made sure only return 1 result etc is unticked.
    Any Ideas? Quirks I should know about ? Easier way to do this?

    tia

    Chris
    Last edited by ChrisH; 10th May 2010 at 09:52 AM. Reason: Multiple records not sub reports

  2. #2

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,494
    Thank Post
    1,452
    Thanked 1,197 Times in 812 Posts
    Rep Power
    711
    There is a report already set up by default, in "Focus > Applications", called "Applicant Data Collection Sheet", if that doesn't do what you want or isn't laid out how you want it, you could use that as the basis for your report (it appears to pull all the correct data through when I run it on my system).

    Let me know if you don't have it and I'll email you a copy.

  3. Thanks to LosOjos from:

    ChrisH (10th May 2010)

  4. #3
    ChrisH's Avatar
    Join Date
    Jun 2005
    Location
    East Lancs
    Posts
    5,013
    Thank Post
    120
    Thanked 283 Times in 261 Posts
    Rep Power
    108
    Time to book that eye test cheers. It doesn't help that you cant sort the column names by pressing the column title at the top. It was nestled in an odd order.
    Why my template didn't work is a mystery as contacts table looks the same.
    Last edited by ChrisH; 10th May 2010 at 10:30 AM.

  5. #4

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,494
    Thank Post
    1,452
    Thanked 1,197 Times in 812 Posts
    Rep Power
    711
    lol, I've given up trying to make logical sense of certain aspects of SIMS, I mean we have an SQL database that you can't run a report on that pulls info from two separate areas with any kind of ease! glad you got it sorted now anyway

SHARE:
+ Post New Thread

Similar Threads

  1. Sims.net adding new personnel officer [solved]
    By sakwoya in forum MIS Systems
    Replies: 8
    Last Post: 10th March 2010, 12:05 PM
  2. [solved] Missing data in SIMS.net Report
    By MrLudwig in forum MIS Systems
    Replies: 3
    Last Post: 27th November 2009, 08:43 AM
  3. Sims report help
    By Jamie_a in forum MIS Systems
    Replies: 1
    Last Post: 4th October 2008, 04:34 PM
  4. Another Sims Report
    By Jamie_a in forum MIS Systems
    Replies: 2
    Last Post: 29th January 2008, 04:58 PM
  5. SIMS.Net - problem importing new reports [SOLVED]
    By Irazmus in forum MIS Systems
    Replies: 31
    Last Post: 12th October 2006, 02:02 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •