Sims - designing a report to get counts for grouped data

[antonponniah]

Hi All

 

Wondering if it's possible design a report which will give me counts for grouped sets of data, for example, i need to know the number of occurrences of PPI in year 10 Boys, year 10 girls, etc.., is it possible to get this using a query in Simms. Currently I export this data to spreadsheet and do a count in the spreadsheet. This is time consuming and wondered if this can be done in Simms directly. Any advice is much appreciated.

 

Thanks

Anton

[sefton]

I have a report that exports it to excel and puts it in a pivot table so you can quickly see a number of combinations.

[antonponniah]

I would appreciate if you could share this report with me.

 

I assume we can't do this in Simms directly? I can see that we can do counts for the existing groups in Sims but may be not for dynamic grouped sets?

[ajp233]

How about the School Report? Reports> School Report

[antonponniah]

There is only one report showing up under school report, named as 'GCX_Dummy', which only brings up the school name when i run it. I can see this report in 2011.

There may be other reports like the one you mentioned above which i may have to import but i don't know where to find this.

[antonponniah]

Thanks all for your advice. I am creating a pivot report as per Sefton's advice. Please let me know if there is any Sims report definitions available to extract school summary data.

[sefton]

I would appreciate if you could share this report with me.

 

I assume we can't do this in Simms directly? I can see that we can do counts for the existing groups in Sims but may be not for dynamic grouped sets?

 

It won't let me upload a .rptdef file, if you pm me your email address I 'll send the report to you and you can import it into Sims.

[antonponniah]

My email address is: [email protected]

 

Thanks and much appreciated.

[sefton]

My email address is: [email protected]

 

Thanks and much appreciated.

 

I've just mailed that over.

[ajp233]

When running the School Report it should bring up the 'School Report' dialog box that allows you to select which sections to include in the report. Accepting the defaults and clicking on 'Generate' will then produce the report:

 

 

If the report does not run correctly in your SIMS you should speak to our support people to get it sorted.

[antonponniah]

Great stuff.. just found the report.. somehow i overlooked this. Very useful - thanks for pointing this out.

[antonponniah]

Worked a treat after changing the Pivot table source range (we have around 2000 students) ! Thanks very much and much appreciated!