+ Post New Thread
Results 1 to 11 of 11
MIS Systems Thread, sims report excel autogrouping in Technical; i wondering if anyone knew the solution for this. whenever any member of staff runs a report in sims with ...
  1. #1
    sandeep2504's Avatar
    Join Date
    Jan 2009
    Location
    Surrey
    Posts
    245
    Thank Post
    47
    Thanked 21 Times in 20 Posts
    Rep Power
    17

    sims report excel autogrouping

    i wondering if anyone knew the solution for this.

    whenever any member of staff runs a report in sims with any values, fields, no filters/filters with the file type as excel, the excel document automatically groups the sheets when the report is run.

    i have tried this on various machines, as admin user and i made sure group sheets is not selected in sims

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,893
    Thank Post
    751
    Thanked 1,469 Times in 1,220 Posts
    Rep Power
    364
    sounds strange, especially if you are unticking the group sheets box.
    is this for all reports? and it happens for your admin account too?
    what if you design a new report from scratch and untick the box?
    other predefined reports may have that ticked and saved within them or be based on a template that has the grouping function within a macro.

  3. #3
    sandeep2504's Avatar
    Join Date
    Jan 2009
    Location
    Surrey
    Posts
    245
    Thank Post
    47
    Thanked 21 Times in 20 Posts
    Rep Power
    17
    all reports - from scratch and from template, doesnt matter what fields, filters are select when you select excel it all exports as grouped sheets

    group all sheets is not ticked by default on our system

    ticking it and then unticking it doesnt make a difference

    its affecting all user accounts

    i've spoken to sims support and they are as baffled as i am

  4. #4
    sandeep2504's Avatar
    Join Date
    Jan 2009
    Location
    Surrey
    Posts
    245
    Thank Post
    47
    Thanked 21 Times in 20 Posts
    Rep Power
    17
    we have narrowed this down to being a problem with Office 2003 service pack 3.

    Running reports on a workstation with service pack 2 has no problems with grouping.

    Sims support have told us they cant support us anymore.

    I was wondering if anyone else had problems with Office 2003 SP3 and sims reports.

    ideally i dont want to remove SP3!

  5. #5

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,893
    Thank Post
    751
    Thanked 1,469 Times in 1,220 Posts
    Rep Power
    364
    nope.
    unfortunately you might have to remove it if Capita have said they wont support you.
    if you could work out why it happens, maybe you could add a macro to undo it, but that's too complicated.
    shame

  6. #6
    sandeep2504's Avatar
    Join Date
    Jan 2009
    Location
    Surrey
    Posts
    245
    Thank Post
    47
    Thanked 21 Times in 20 Posts
    Rep Power
    17
    well it wasnt office service pack 3.

    i doubled checked the machines and although my pc has SP3, the office staff pc has service pack 2 just like our test machine.

    i did think it was stupid that it would be service pack 3, im sure other schools are using sims with sp3 absolutely fine and sp3 has been out for a while now.

    I am now going compare software on our test machine and affected machines.

    Driving me up the wall this is!

    Would be ok if the member of staff would click ungroup and carry on but no she is kicking up a fuss.

  7. #7

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,893
    Thank Post
    751
    Thanked 1,469 Times in 1,220 Posts
    Rep Power
    364
    i'm confused. what type of grouping are we talking about?
    i thought we were talking about when SIMS splits the results by the last column e.g. reg group so you get separate sheets for each reg group.
    Where is the ungroup button that get's rid of this..?

  8. #8
    sandeep2504's Avatar
    Join Date
    Jan 2009
    Location
    Surrey
    Posts
    245
    Thank Post
    47
    Thanked 21 Times in 20 Posts
    Rep Power
    17
    In Excel 2003 Select Data > Group and Outline from the top menu.

    or select a sheet by using the ctrl button.

    Basically the functions groups together sheets in an Excel workbook so when you amend one cell it amends the corresponding cells in the other sheets you selected when you grouped it.

  9. #9

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,893
    Thank Post
    751
    Thanked 1,469 Times in 1,220 Posts
    Rep Power
    364
    i didn't know you could do that.

    i think i've found it. but group and outline from the data menu doesn't do it, i've used that before for hiding data quickly.

    ctrl+selecting sheets and then editing data does it though.

    by default any of my reports that split the data into sheets does also have them all selected, if the report doesn't split the data however i only have 1 sheet. that's with excel sp3.

    i'm not sure there is anything special about grouping, right clicking on the sheet tab and selecting ungroup sheets just deselects the rest, so the solution would be to just click on a single sheet and they will be ungrouped.

    i've never noticed it before or had it reported as an issue with anyone using the spreadsheets afterwords, but i don't see it's such a big problem.

  10. #10
    sandeep2504's Avatar
    Join Date
    Jan 2009
    Location
    Surrey
    Posts
    245
    Thank Post
    47
    Thanked 21 Times in 20 Posts
    Rep Power
    17
    Quote Originally Posted by vikpaw View Post
    i didn't know you could do that.

    i think i've found it. but group and outline from the data menu doesn't do it, i've used that before for hiding data quickly.

    ctrl+selecting sheets and then editing data does it though.

    by default any of my reports that split the data into sheets does also have them all selected, if the report doesn't split the data however i only have 1 sheet. that's with excel sp3.

    i'm not sure there is anything special about grouping, right clicking on the sheet tab and selecting ungroup sheets just deselects the rest, so the solution would be to just click on a single sheet and they will be ungrouped.

    i've never noticed it before or had it reported as an issue with anyone using the spreadsheets afterwords, but i don't see it's such a big problem.
    I totally agree with you about not seeing it as a problem; if it was me i click a single sheet and continue.

    I forgot to add that grouping it also greys out functions in the data menu which is why they originally logged the problem because they couldnt sort a spreadsheet because sort was greyed in the menu.

    Their argument is, it wasnt doing it before, why is it doing it now.

  11. #11

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,893
    Thank Post
    751
    Thanked 1,469 Times in 1,220 Posts
    Rep Power
    364
    Fair enough. We don't have that many reports that group the results into sheets.
    I guess you'll need a Microsoft update that fixes it or Capita to change the way they output reports.
    Rock and a Hard Place?
    Good Luck.



SHARE:
+ Post New Thread

Similar Threads

  1. Excel Report Template in SIMS
    By landaufortecollege in forum MIS Systems
    Replies: 11
    Last Post: 9th December 2009, 04:47 PM
  2. SIMS: Report to tell me what day it is
    By Ric_ in forum MIS Systems
    Replies: 1
    Last Post: 25th November 2009, 11:45 AM
  3. Sims report help
    By Jamie_a in forum MIS Systems
    Replies: 1
    Last Post: 4th October 2008, 05:34 PM
  4. Sims report Template
    By imiddleton25 in forum MIS Systems
    Replies: 1
    Last Post: 27th June 2008, 06:08 PM
  5. Another Sims Report
    By Jamie_a in forum MIS Systems
    Replies: 2
    Last Post: 29th January 2008, 05:58 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
  •