+ Post New Thread
Results 1 to 4 of 4
MIS Systems Thread, AM7 Show formula column in report in Technical; Hi All, This one has me and our sims guru stuck. We are redesigning our reports so that they look ...
  1. #1
    philjones2000's Avatar
    Join Date
    Mar 2006
    Location
    Pool, Cornwall
    Posts
    137
    Thank Post
    52
    Thanked 8 Times in 4 Posts
    Rep Power
    21

    AM7 Show formula column in report

    Hi All,

    This one has me and our sims guru stuck.

    We are redesigning our reports so that they look nice. One part of this, is a column that tells parents if their child is on target, off target or over target (with off target colour-coded red, on target green etc.). We've created a formula column in sims am7 that does this but we can't for the life of us export this into the word report.

    The formula column doesn't seem to exist when we look to insert this in the mail merge and word doesn't do conditional formatting, so there was no way of doing it there either.

    How can we achieve this? Is it possible?

    Thanks

  2. #2
    rh91uk's Avatar
    Join Date
    Sep 2008
    Location
    UK
    Posts
    876
    Thank Post
    137
    Thanked 132 Times in 114 Posts
    Rep Power
    35
    Hi Phil

    Just clutching at straws here ..... is the column a "formula entry" column and if so, it must have an aspect (I think!) attatched to it. If not, perhaps try adding one with an aspect and try exporting that into the word report. You can always make this column "read only".

    Cheers

  3. Thanks to rh91uk from:

    philjones2000 (10th November 2010)

  4. #3

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,447
    Thank Post
    1,438
    Thanked 1,168 Times in 797 Posts
    Rep Power
    707
    +1 to rh19uk's comment: you must create the columns as "Data Entry with Formula" and then you can choose an aspect and result set to link them to as with any other data entry columns. And making it read only will only prevent manual editing; SIMS will still store the result in the column.

    As a bonus, since the Summer 10 upgrade, SIMS stores the colour of the cell now so that it can be included in your report: just remember to tick "Print report with colour" in individual reports, and make sure there is only one result per cell that needs colouring (they have to be in a table for colouring to work as it shades the cell's background).

  5. Thanks to LosOjos from:

    philjones2000 (10th November 2010)

  6. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    As the guys above, however there was a way to do conditional formatting in word. There was a thread on supportnet recently with similar requirement but I couldn't remember how it's done but I saw the technique on the supportnet forum some time ago. Basically using an IF field code.

  7. Thanks to vikpaw from:

    philjones2000 (11th November 2010)

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] SIMS AM7 Template Change resultset script
    By vikpaw in forum MIS Systems
    Replies: 71
    Last Post: 25th October 2011, 09:38 AM
  2. Replies: 1
    Last Post: 19th August 2010, 09:51 AM
  3. [SIMS] Good AM7 Data Structure
    By CAM in forum MIS Systems
    Replies: 9
    Last Post: 27th October 2009, 11:13 PM
  4. SIMS AM7 -Export and Import Marksheet
    By LittleRedFoot in forum MIS Systems
    Replies: 4
    Last Post: 20th October 2008, 07:52 PM

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
  •