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 ...
19th January 2010, 03:54 PM #1
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
20th January 2010, 07:28 AM #2
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.
20th January 2010, 10:09 AM #3
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
20th January 2010, 12:53 PM #4
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!
25th January 2010, 08:06 AM #5
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.
25th January 2010, 10:40 AM #6
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.
25th January 2010, 01:15 PM #7
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..?
25th January 2010, 01:24 PM #8
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.
25th January 2010, 01:40 PM #9
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.
25th January 2010, 01:57 PM #10
I totally agree with you about not seeing it as a problem; if it was me i click a single sheet and continue.
Originally Posted by vikpaw
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.
26th January 2010, 08:33 AM #11
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?
By landaufortecollege in forum MIS Systems
Last Post: 9th December 2009, 04:47 PM
By Ric_ in forum MIS Systems
Last Post: 25th November 2009, 11:45 AM
By Jamie_a in forum MIS Systems
Last Post: 4th October 2008, 05:34 PM
By imiddleton25 in forum MIS Systems
Last Post: 27th June 2008, 06:08 PM
By Jamie_a in forum MIS Systems
Last Post: 29th January 2008, 05:58 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)