SIMS Excel Report Column Order

[jond123]

Hello,

 

I'm using SIMS to generate some data reports for seating plans.

 

A couple of questions.

 

1) How can I control what order the columns are in? I would rather do this in SIMS at the Design Report level, but it could be done at the Report Output level with a template - but how do I do an Excel template? I've only ever used RTF templates.

 

2) Data for G&T and PP comes out as T and F. Is there a way to get rid of the F's completely, and change the T's to Y? Ideally before it outputs to excel (I know I can search and replace in Excel, but its a pain).

 

If anyone can help me with those, I will bow down and worship you as the god of sims that you are.

 

Thanks

Jon

[vikpaw]

In the report designer, you can see the list of data columns that will be exported. You can move these up and down, however if you are accessing data from a sub-table, this often gets pushed to the bottom, however columns within the table can be ordered.

 

This will be reflected in the Excel / RTF output.

 

In RTF you can put in conditional fields to change the T to a Y.

In Excel you would probably be better off doing it later in Excel - to automate this, you'll want to look at the Advanced Reporting Guide, there are a few threads on it here. It's a little complex, Excel reports have an embedded Macro, you can add to this, to do some conditional formatting for you.

[jond123]

yeah, data from a sub table is pretty much screwing it up.

 

will have a look at the excel template macro - how do I find it?

Edited November 15, 2015 by jond123

[vikpaw]

yeah, data from a sub table is pretty much screwing it up.

 

will have a look at the excel template macro - how do I find it?

 

Hi, try this post http://www.edugeek.net/forums/mis-systems/38519-edit-excel-output.html#post359319 , the rest of the thread could also be useful.

One thing to bear in mind with the macro is that I think it hard codes the size of the data it refers to, so you either have to do this to match your data, or put in some dynamic code so it selects all used / required cells first.