Command Reporter Error
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:
<CommandReporterError>Error Running Report. Reason :A column named 'Forename' already belongs to this DataTable.</CommandReporterError>
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!