Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Get Parameter value in FDM report event script

936587Oct 18 2018 — edited Oct 22 2018

Hi All!

I'm using FDM 11.1.2.3 and I want to make the report behave differently depending on the parameter chosen.

The parameter's name is "publish", so I would like to write some code like

Sub OnFormat

if rpt.parameters("publish").value = 1 then

     rpt.Sections("ReportGroup").Controls("Label").multiline = false

...

But can't find correct syntax for rpt.parameters("publish").value.

And the second, connected question:

Before starting the report users choose the report format - pdf, xls and so on.

Is the any way to get programmatically the users choise

a) in the report SQL

b) in the report event script, for example OnFormat?

Would be really appreciate for assistance in my questions.

Best regards

Sergey.

Comments

Post Details

Added on Oct 18 2018
#business-intelligence-applications, #fdm, #financial-data-management, #parameter, #performance-management-applications, #report, #script
4 comments
269 views