Hi,

As a side question, I would like to know if it's possible to change data that is loaded from an excel file?
I know there are restrictions in manipulating files that are loaded by the odbc excel drivers, so I was wondering if I can use the 'Pre load script', 'Post load script' and 'Final script' in this case.

I gave it a try, but then it threw an error and I'm not sure if it's because of my inexperience with the razor scripting file, or that it's just not allowed in this case.


Example (see my previous post). I know that there are empty values for certain fields. I'm using this field in a division operation, and have encountered division by zero.

So if I could spot these records, and change the value to let's say -1, then the report would execute fine, and I would still see the records that have been changed because they would all have the value '-1'.

I'd like to hear if this is at all possible, and if yes, maybe a simple example of how to change a value of a field (if the value is null, then let the value be -1).

Thanks in advance,
Tom