Double slider input control reg.

[Former Member]

We have placed a double slider in one of our WebI reports (4.2) and we would like to mention those values in the report body. How to write a formula for representing these min & max figures?

[Former Member]

Hello Giri,

Try below code this will work out for your solution.

="Age between "+Substr(ReportFilterSummary();(Pos(ReportFilterSummary();"Between")+8);((Pos(ReportFilterSummary();"AND")-1)-(Pos(ReportFilterSummary();"Between")+8)))+" & "+Substr(ReportFilterSummary();Pos(ReportFilterSummary();"AND")+4;Length(ReportFilterSummary()))

Regards

Niraj

[former_member368522]

Hi Giri

Can u please explain u r problem little more?

[Former Member]

Hi,

1).[Double Slider Field]=Field on Which Double Slider is Created

2). For max=Max([Double Slider Field])

3).For min=Min([Double Slider Field])

Regards,

Raju Kuswhaha

[Former Member]

Thanks for asking the details.

Well, we have a double slider in the input control (left side) panel as shown.

I would like to mention in this band selected by the user, in the report body as shown.

Dynamically, the output should vary when the slider is moved left or right:

 

My question is: How to write a formula in the Report body:

="Age between "+"__?____"+"& "+:___?____"

Hope you understand my requirement! If not please revert.

Thanks in advance.

[Former Member]

Hi,

Use this formula = "Age between "+Min([Age])+" & "+Max([Age])

Regards,

Raju Kushwaha

[Former Member]

Hi Giri,

You need to derive it from report filter summary

Something like

Substr(ReportFilterSummary();Pos(ReportFilterSummary();"Age")+3;Length(ReportFilterSummary()))

First check the out put of reportfiltersummary() and then derive using pos and substr functions