+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, Photo Reports in Technical; Hi, I have been asked to produce a report with staff photos, staff code, name and department. I have done ...
  1. #1

    Join Date
    Nov 2010
    Location
    Great Grimsby
    Posts
    72
    Thank Post
    7
    Thanked 2 Times in 2 Posts
    Rep Power
    8

    Photo Reports

    Hi,

    I have been asked to produce a report with staff photos, staff code, name and department.

    I have done this, but have hit a snag which means it's in a format which is totally unsuitable for SMT.

    Over the years our staff photos have been imported into SIMS in a variety of different sizes, therefore if I run a standard Word list report, I get one photo per page for some staff, for other staff only a passport sized photo.

    I have tried to create the report in one of the ready-made templates - the address labels one. I have managed to get it into a format which will pass, but when printing the report insists on printing to the multi-purpose tray. Unfortunately, if pressing print will not cause the report to print, it'll be rejected- I can't expect them to load the tray with paper and then press print.

    I have attempted a mailmerge report, but that can't handle the photo, and an RTF report is giving an out of memory error which I assume comes from the size of some of the photos.

    This is leaving me having to produce the report manually, copying and pasting staff photos into a document. I'll also have to keep this up-to date with staff changes. We're the third largest secondary school in the country and hold training school status - I can't allow myself to have this job.

    Has anyone got a report template I could use or some advice they could give me? Helping me make the labels report print to the paper drawer would be fine, but I can't see a setting anywhere.

    Anyone?

    Thanks,

  2. #2
    Steven_Cleaver's Avatar
    Join Date
    Jul 2008
    Location
    Birmingham
    Posts
    463
    Thank Post
    174
    Thanked 84 Times in 68 Posts
    Rep Power
    50
    Hi

    What about printing to PDF I have found this really useful in printing some funny formats out of SIM's.

    FREE PDF Printer

    Could try above or various other free Prnt to PDF Software.

  3. #3

    Join Date
    Nov 2010
    Location
    Great Grimsby
    Posts
    72
    Thank Post
    7
    Thanked 2 Times in 2 Posts
    Rep Power
    8
    Thanks Steven. That's worth a thought, but then it's probably more actions required than opening the tray and putting paper in. Or it still requires me to recognise every time a new member of staff has been appointed and run the report again.

    It's a workaround, but it isn't ideal.

  4. #4

    glennda's Avatar
    Join Date
    Jun 2009
    Location
    Sussex
    Posts
    7,808
    Thank Post
    272
    Thanked 1,135 Times in 1,031 Posts
    Rep Power
    349
    Personally I would export as a word doc - then in word save as HTML this then saves all the photos in the sub-folder. I would the bulk resize and import back into sims at a smaller size so the sims report looks normal when created.

  5. #5

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,406
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    You can set the size of the photo in the report template... Or use SalamanderSoft photo Extractor tool - SalamanderSoft Limited - Free Utilities

    If you get resource issues - and you can't throw SSD\RAM\Network\blah blah at it, filter it, so A-P Q-Z or whatever.

  6. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,850
    Thank Post
    672
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    I have a really nice RTF template you can use, but you'll need to fix the photo size first. Either the Salamander Tool or manually using a filtered report would do the trick.

    I don't think resizing the photo in the template will work because it will still download the full sized photo. I use a table to force the size of the photo and it's usually fine. We use a similar template for teachers to get class photos. It might take a minute or so to run, but they work really well.

    When we take new staff photos, and add them to SIMS, i also dump the information to the intranet and it's stored there for quick retrieval, but it is a manual process, which needs periodic updating.

SHARE:
+ Post New Thread

Similar Threads

  1. Sims Report with Photos
    By Geoff in forum MIS Systems
    Replies: 8
    Last Post: 18th September 2009, 10:24 PM
  2. SIMS.net Reports, Photos and XML
    By localzuk in forum MIS Systems
    Replies: 1
    Last Post: 13th February 2009, 10:51 AM
  3. Using Photos in Reports
    By Jamie_a in forum MIS Systems
    Replies: 2
    Last Post: 13th November 2007, 11:44 AM
  4. Printing Access Reports... or not!
    By Frazer in forum Windows
    Replies: 0
    Last Post: 20th October 2005, 11:03 AM
  5. Getting your server to email you reports.
    By eejit in forum Windows
    Replies: 11
    Last Post: 23rd September 2005, 10:46 AM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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