Hi,
Can we send Excel Formula through report Studio.
Here is the Ex:
A B C
--------------------------------
10 5 =A1*B1
4 6 =A2*B2
=A3*B3
Requirement is, user will insert the values in the a3 and b3 once it is generated to excel, so that in the 'C' column he can see the values.
When i create calculated column for 'C' and set the formula in cognos report, it is showing only string value i.e '=A1*B1' not the numerical value 15 in the excel output.
Can anyone give solution.
Thanks,
KVBR.
I am unaware of any way to pass a calculation from C8 to Excel, at best I would have been expecting to send a string that you could then manipulate.
What about using Office Connection or the upgraded Go! Office? Essentially these allow you to work in excel, and import data into your worksheet instead of exporting to a blank worksheet. This will protect any cellular calculations in the excel document.
I proposed the same, have to see the client responce.