I have just updated by catalog from Version 6 to version 7 MR2.
A couple of my reports will no longer run. I have identified the problem as a calculated field.
This calculated field determines the financial period relevent to a transaction (the catlog is over expense claims) so the calculation goes along the lines of:
If date between 2002-12-30 and 2003-01-30 then 1 else if date between 2003-01-31 and 2003-02-27 then 2 else if....
and so on. There is currently about 2 years worth of this so about 24 different selections.
In version 6 this ran fine, not particularly slow. In version 7 the fish does not even start to swim, the hour-glass comes up and stays there. To cancel it I have to go into task manager and 'end task' from here I have seen that my CPU by this point is upto 100%.
If I reduce the calculation down to a few selections it runs ok, hence I can tell it's this that is causing the problem.
I have tried changing the syntax to <'s and >'s but this makes no difference.
Please help!
liz
A couple of my reports will no longer run. I have identified the problem as a calculated field.
This calculated field determines the financial period relevent to a transaction (the catlog is over expense claims) so the calculation goes along the lines of:
If date between 2002-12-30 and 2003-01-30 then 1 else if date between 2003-01-31 and 2003-02-27 then 2 else if....
and so on. There is currently about 2 years worth of this so about 24 different selections.
In version 6 this ran fine, not particularly slow. In version 7 the fish does not even start to swim, the hour-glass comes up and stays there. To cancel it I have to go into task manager and 'end task' from here I have seen that my CPU by this point is upto 100%.
If I reduce the calculation down to a few selections it runs ok, hence I can tell it's this that is causing the problem.
I have tried changing the syntax to <'s and >'s but this makes no difference.
Please help!
liz