Get Parameter value in FDM report event script

936587

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.

user6692921

I haven't done anything with FDM reports for a while but from what I can remember I think you can just add the ~~ field to the SQL query statement e.g.

SELECT Account, Entity, ~myParam~ AS MYPARAM FROM TDATASEG1

936587

Thank you. There is the way to get the parameter in SQL and it must be the way in vbscript. I still believe.

user6692921

So you can now assign the SQL column that contains the parameter value to a field on the report and then reference that in the report script:

If rpt.Sections("PageHeader").Controls("txtMyParams").Text = "1" Then

.....

Francisco Amores

exactky, .text is the right one