+ Post New Thread
Results 1 to 11 of 11
MIS Systems Thread, Individual Reports - Tables Within Tables in Technical; Hi All, I'm trying to make some modifications to a template we use for student reports, however it simply doesn't ...
  1. #1

    Join Date
    Feb 2014
    Location
    Derby, UK
    Posts
    13
    Thank Post
    5
    Thanked 4 Times in 3 Posts
    Rep Power
    2

    Individual Reports - Tables Within Tables

    Hi All,

    I'm trying to make some modifications to a template we use for student reports, however it simply doesn't want to play ball at all.

    The way it is currently set up is that there is a 1 column table with multiple rows with report information within each cell like this:

    Art
    Baseline: - Prediction: - Effort:
    Attendance:

    Teacher Comment:
    Biology
    Baseline: - Prediction: - Effort:
    Attendance:

    Teacher Comment:

    However, we need to put the 'Baseline', 'Prediction' and 'Effort' sections into a table so it actually looks presentable, hence the requirement of a table within a table. The only problem with this is that because there is a table within a table the system refuses to 'Remove Report Sections that contain no Results'. So the areas of the report that have no data (the student doesn't study the subject) are still present after the report is generated, but the sections contain no data - just a blank table within a table.

    What we're looking for/hoping for is something like this:

    Art
    Baseline: Prediction: Effort:
    Attendance:

    Teacher Comment:
    Biology
    Baseline: Prediction: Effort:
    Attendance:

    Teacher Comment:

    Does anyone know if this is at all possible? Any help would be greatly appreciated!

  2. #2

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,492
    Thank Post
    1,451
    Thanked 1,197 Times in 812 Posts
    Rep Power
    711
    Each report section should be it's own table with only a line break between each closing/opening tag. If you get an error saying you can't put a report section tag inside a table, put the tag one line below, then delete the empty line. from your example, it would look like this (without the blank line separating the tables from the tags, can't remove it on here!):

    <<ReportSection>>
    Art
    Baseline: Prediction: Effort:
    Attendance:
    Teacher Comment:
    <</Report Section>><<Report Section>>
    Biology
    Baseline: Prediction: Effort:
    Attendance:
    Teacher Comment:
    <</Report Section>>

    Then when the report is generated, because the tags are removed the tables should get merged in to one with the empty subjects removed
    Last edited by LosOjos; 7th February 2014 at 12:25 PM.

  3. Thanks to LosOjos from:

    Spizzy01 (7th February 2014)

  4. #3

    Join Date
    Feb 2014
    Location
    Derby, UK
    Posts
    13
    Thank Post
    5
    Thanked 4 Times in 3 Posts
    Rep Power
    2
    Ah right... Thanks for that, I'll give it a shot.

    Is the <<ReportSection>> tag a hidden tag or something? It's not a selectable field from what's available in the list SIMS.Net provides, so I'm a little curious to know how you came to know about it? Is it in some form of documentation somewhere?

  5. #4

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,492
    Thank Post
    1,451
    Thanked 1,197 Times in 812 Posts
    Rep Power
    711
    Quote Originally Posted by Spizzy01 View Post
    Ah right... Thanks for that, I'll give it a shot.

    Is the <<ReportSection>> tag a hidden tag or something? It's not a selectable field from what's available in the list SIMS.Net provides, so I'm a little curious to know how you came to know about it? Is it in some form of documentation somewhere?
    No it's a standard tag, it's how you tell SIMS exactly what a section is so that it can remove an empty one. I did make a typo though, there should be a space between the two words i.e. "Report Section" (invalid XML, tut tut)

    It's on the ribbon in newer versions of Office, can't remember where it is on older versions now though...

    repsec.jpg

  6. Thanks to LosOjos from:

    Spizzy01 (7th February 2014)

  7. #5
    CAM
    CAM is offline

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Burgh Heath, Surrey
    Posts
    4,177
    Thank Post
    839
    Thanked 370 Times in 287 Posts
    Blog Entries
    60
    Rep Power
    283
    Right Click -> Report Section -> Open/Close for non-ribbon Office.

    Also make sure the sections don't overlap. So Open-Close-Open-Close not Open-Open-Close-Close

  8. 2 Thanks to CAM:

    LosOjos (7th February 2014), Spizzy01 (7th February 2014)

  9. #6

    Join Date
    Feb 2014
    Location
    Derby, UK
    Posts
    13
    Thank Post
    5
    Thanked 4 Times in 3 Posts
    Rep Power
    2
    Quote Originally Posted by LosOjos View Post
    No it's a standard tag, it's how you tell SIMS exactly what a section is so that it can remove an empty one. I did make a typo though, there should be a space between the two words i.e. "Report Section" (invalid XML, tut tut)

    It's on the ribbon in newer versions of Office, can't remember where it is on older versions now though...

    repsec.jpg
    That moment when you could swear you had checked every possible tag available, but then get shown that you haven't - Gotta love those moments...

    We have Office 2010, and I feel ashamed that I have never noticed this 'Report Section' option before and missed something so simple... That being said, it looks like this should work, so thanks for all your help guys!

  10. #7

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,008
    Thank Post
    680
    Thanked 1,397 Times in 1,157 Posts
    Rep Power
    353
    I inherited some tables within tables, but don't mess with them cos they work.
    You should be able to get what you want with extra columns in your design, and merging those that only need one, we do that as we have a page per subject, which does have report sections around it, and then within the page the table has multiple rows and columns.

    I've never relied on tables auto-merging - that's scary! Word is bad enough with tables as it is.

    I have this one type of report, where the table disappears off the bottom of the page, and if i want to edit it, i have to change to A3 paper size so i can see all the tags. Then put it back again.

  11. #8

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,492
    Thank Post
    1,451
    Thanked 1,197 Times in 812 Posts
    Rep Power
    711
    Quote Originally Posted by vikpaw View Post
    I've never relied on tables auto-merging - that's scary! Word is bad enough with tables as it is.
    If you remove all line/paragraph breaks between tables in Word, it will automatically merge the tables. It can be quite irritating but can also come in handy some times - like SIMS, it's a case of recognizing when it's a help or a hindrance!

    Quote Originally Posted by vikpaw View Post
    I have this one type of report, where the table disappears off the bottom of the page, and if i want to edit it, i have to change to A3 paper size so i can see all the tags. Then put it back again.
    Sounds to me like the table has been set not to break pages ("Table Properties > Allow Table to Break Pages")

  12. #9

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,008
    Thank Post
    680
    Thanked 1,397 Times in 1,157 Posts
    Rep Power
    353
    True, but it ain't broke, so i'm not going any where near it unless i really have to.

  13. #10
    CAM
    CAM is offline

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Burgh Heath, Surrey
    Posts
    4,177
    Thank Post
    839
    Thanked 370 Times in 287 Posts
    Blog Entries
    60
    Rep Power
    283
    I've had stranger: One template prints off fine for the first 100 students and the rest of them it chops the top line off from a table (annoying as I was using it as a separator for headings and the text below). Bizarre Individual Reports moment...

  14. #11

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,008
    Thank Post
    680
    Thanked 1,397 Times in 1,157 Posts
    Rep Power
    353
    Is it always the same? Maybe some students have some random data coming in causing the issue. Hidden or broken tags could do that.

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] HOW-TO: Bulk Update Result Set in Individual Reports (AM7)
    By LosOjos in forum MIS Systems
    Replies: 7
    Last Post: 19th December 2012, 10:15 AM
  2. [SIMS] Sims Assessment Manager Individual Reports
    By MACIT in forum MIS Systems
    Replies: 11
    Last Post: 30th June 2011, 02:14 PM
  3. Replies: 3
    Last Post: 10th June 2010, 03:12 PM
  4. Saving edited Individual Reports to Linked Documents
    By sallie_wan in forum MIS Systems
    Replies: 10
    Last Post: 20th March 2010, 11:22 AM
  5. Individual reports for students in SIMS
    By cjohnsonuk in forum MIS Systems
    Replies: 2
    Last Post: 25th March 2008, 11:27 AM

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
  •