[sims] Sims Achievement and Behaviour Report

[calcharn]

Hi

 

I have a report in sims that produces a list of student names along side their achievement points, behaviour points and then a total (achiev - behav) between two dates.

When i run it for just one form it works perfectly, sending the information into excel and then into a pivot table or macro table. Not sure what as its a pre defined report that i can see to open or manipulate.

 

When i try to run it for more than one form or different dates it times out and produces the following error "error 6 overflow"

 

I have tried to google and i believe its something to do with number of rows - but that's where i get totally confused.

 

How do i edit the VBA if i dont know where the sims template is stored?

 

in addition to getting the above up and running i would also like to filter the report to show subject specific points. But again when i ask too much it crashes.

 

can any one help?

[ajp233]

If you export the report from SIMS as a RptDef file, change the file extension to .zip and then you will be able to extract the Excel report template and modify the VBA.

[calcharn]

its saying the compressed zip folder is invalid

[coolhands]

once you exported the original report from sims (right-click, export) it will have the file extension RptDef - you must change that part (rename it) to be.zip it warns you, say yes, then it makes it look like a folder. Double click this new folder and inside it you can see the excel file.

[calcharn]

This is the error i get when i try to extract?

 

[SpreadsheetJockey]

I think you need to enable "show file extensions" in order not to get that .zip.zip file name. You can do that via the "File Name Extensions" check box in the View menu of File Explorer. This should allow you to rename it properly with .zip and open it.

[calcharn]

Hi AJP233 we have managed to finally extract the file (excel) what row do i need to edit in the VBA