[sims] Command Reporter Error

[Cache]

Hi

 

Anyone able to help me out with this CommandReporter error?

 

I've created a report in SIMS which will pull the entire school roll, medical conditions and then Contacts 1,2 & 3 and send it to a csv. Works perfectly when running from within SIMS, but when I try to use the command reporter to automate the report I get the following:

 

Error Running Report. Reason :A column named 'Forename' already belongs to this DataTable.

 

Any ideas what it is it's complaining about that needs to be changed/specified because I don't understand it?

 

Edit: DUH! Bit of logic and it makes sense.

 

Contacts have Forename and Surname too! SIMS kindly named the heading Forename and Surname so renamed all the Forename columns, problem solved!

Edited September 30, 2010 by Cache