BusinessObjects Board

Report Level Formula In Exel

sdk development
#1

Hi

Is there any SDK solution present if i want to see the report level formulas in a excel sheet.

Please help if someone knows the solution.

It would be greatly appreciated.

Thanks
Aniket

aniketp :uk: (BOB member since 2007-10-05)

#2

Assuming you mean full client reports, this is close … List report level variables in full client reports. Just save as Excel when it’s done.

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

#3

Dwayne thanks for your qucik response.

That i saw and i forgot to mention that i am working on WEBI. So is there any solution for WEBI reports.

Please provide your valuable feedback.

Regards
Aniket

aniketp :uk: (BOB member since 2007-10-05)

#4

Try the following post:
https://bobj-board.org/t/119370

darcstorm :philippines: (BOB member since 2008-07-22)

#5

Hi Darcstorm

That post is for Report variables and this is for Report formulas so i am looking for a way out which will give me the report level formulaes means without creating variables directly i am defining formulaes in formula bar abnd displaying those in Excel.

So if possible please provide me a solution to this .

Thanks for your response.

Regards
Aniket

aniketp :uk: (BOB member since 2007-10-05)

#6

That will be a lot harder.
Basically, these are the steps:

  • Get the DocumentInstance for the WebI document
  • Get the ReportStructure
  • Navigate through the ReportStructure to get a ReportElement
  • When you are at the level of a ReportCell you can retrieve the ReportExpression
  • If the ReportExpression is a formula, you can cast that to a FormulaExpression and retrieve the value

Hope this helps.

darcstorm :philippines: (BOB member since 2008-07-22)