+ Post New Thread
Results 1 to 13 of 13
MIS Systems Thread, RTF reports and custom paper size in Technical; I was trying to make a report for our staff badges so I could bin our old software. I managed ...
  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

    RTF reports and custom paper size

    I was trying to make a report for our staff badges so I could bin our old software. I managed to make the report and the content works fine, the only issue is I want the document to be the same size as the badge which is 8.5 x 5.4 cm. Now if I make an RTF document outside SIMS and re-open it, it keeps the right size; if I try and do it through the edit template in the reports properties, it looses it custom size. If I reopen the same document outside SIMS it's fine! Any tips here ?

    Thanks

    ChrisH

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,009
    Thank Post
    680
    Thanked 1,398 Times in 1,158 Posts
    Rep Power
    353
    It will be fine, it's just a bug that when it loads it pulls in a default template.
    Make your report and test the data is correct. The last thing you should do is alter margins and page size and then it should be fine if you run it.
    If you ever do need to edit, then it will default back to whatever it usually does which is Letter with weird margins i think.
    It's useful as they can be tricky to save the template out as a backup. You can save as type : .rtftemplate there is a quick reference sheet on supportnet to help with this.

  3. Thanks to vikpaw from:

    ChrisH (23rd May 2014)

  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
    Thanks Vik I will push on and see what it looks like.

  5. #4
    tombry's Avatar
    Join Date
    Jan 2012
    Location
    Bassingbourn
    Posts
    194
    Thank Post
    45
    Thanked 37 Times in 29 Posts
    Rep Power
    22
    if you are just making cosmetic edits and do not need the field codes when you re-open the template, you can de-select the option for them to be included, and then it will keep your custom paper size.

    our admin ladies have a hell of a time remembering to change it to A4 all the time (defaults to american letter size)

  6. 2 Thanks to tombry:

    ChrisH (23rd May 2014), vikpaw (23rd May 2014)

  7. #5
    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
    Okay seems to be working okay apart from the photos appear to be different sizes which is annoying. Is there a way to standardise these eg a fixed size table cell or something ?

  8. #6

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,497
    Thank Post
    1,453
    Thanked 1,197 Times in 812 Posts
    Rep Power
    711
    Quote Originally Posted by ChrisH View Post
    Okay seems to be working okay apart from the photos appear to be different sizes which is annoying. Is there a way to standardise these eg a fixed size table cell or something ?
    I believe you can put a size (in pixels) directly inside the <Photo> tag in the template, e.g. <Photo(800x600)>

  9. Thanks to LosOjos from:

    ChrisH (23rd May 2014)

  10. #7
    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
    Thanks, I will give that a go.

  11. #8

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,009
    Thank Post
    680
    Thanked 1,398 Times in 1,158 Posts
    Rep Power
    353
    <Photo 100%>


    or


    <Photo 100x100>

  12. #9
    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
    Okay thanks everyone I got it working pretty much, I may just have to add a custom field to SIMS for the internal job titles in use. The only issue I have now is I can't run them all at once because I get the System out of memory exception. This must be a SIMS limitation as I have plenty of memory. Does anyone know any way round this or a configuration somewhere to change?

  13. #10
    tombry's Avatar
    Join Date
    Jan 2012
    Location
    Bassingbourn
    Posts
    194
    Thank Post
    45
    Thanked 37 Times in 29 Posts
    Rep Power
    22
    whenever I run a report and get that error I just RDP to the sims server and run it there instead

  14. Thanks to tombry from:

    ChrisH (23rd May 2014)

  15. #11
    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
    Ah yes thanks that sounds familiar like something we have had to do to import exam results in the past.

    Edit Nope did the same on the server typical!
    Last edited by ChrisH; 23rd May 2014 at 03:09 PM.

  16. #12
    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
    It's something to do with the logo being too close to the border or some such nonsense there is a thread on here about it, experimenting now but not having much luck.

  17. #13

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,497
    Thank Post
    1,453
    Thanked 1,197 Times in 812 Posts
    Rep Power
    711
    If all else fails, I can share my ID system with you - it's just an Access DB which downloads student photos and details from SIMS using CLR, then you set up your print template on a form, set the print size and done. I'm sure it could be adapted for staff fairly easily.

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Creating custom RTF reports
    By Stuart_C in forum MIS Systems
    Replies: 33
    Last Post: 27th November 2010, 05:54 AM
  2. Replies: 15
    Last Post: 21st July 2009, 04:46 PM
  3. Automatic Printer Selection - based on colour/mono/paper size?
    By Jamman960 in forum New Project Ideas
    Replies: 4
    Last Post: 23rd September 2008, 08:28 AM
  4. Printer paper size question
    By Dos_Box in forum Windows
    Replies: 7
    Last Post: 26th May 2008, 02:11 PM
  5. SIMS.net RTF Report Problem
    By MARKR in forum MIS Systems
    Replies: 3
    Last Post: 21st February 2008, 09:54 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
  •