If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Excel Formula through Report Studio

Started by KVBR, 30 Jul 2007 07:17:13 AM

Previous topic - Next topic

KVBR

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.

MDXpressor

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.
No, a proof is a proof. What kind of a proof? It's a proof. A proof is a proof, and when you have a good proof, it's because it's proven.

-Jean Chretien

KVBR

I proposed the same, have to see the client responce.