Input control as Report filter ( sap bo 4.2 sp04)

[richard_reeves]

Hello Experts,

Please provide a way to use an input control as a report filter.

I have 4 columns where i am populating the difference (columns A-B, C-D , E-F and G-H (all difference populated via variables)).

Now,User want to provide some value in the input cotrol (Like 100, 000) and the report should only show the records with the difference more then 100 000 .

Thanks in advance,
R

[jyothirmayee_s · Accepted solution]

Hi,

you need 2 variables:

@Value:

=0

@threshold:

=[Differerencemeasure] >=@value

Create a Entry Field input control and select > = and apply to a document.

FYR: below blog explain on dynamic inputcontrols:

https://blogs.sap.com/2013/08/13/dynamic-variables-using-input-control/

Post back your result.

Thanks,

Jothi

[richard_reeves · Accepted solution]

Hello Jyothi,

I have four difference measures

@variable_diff_AB

@variable_diff_CD

@variable_diff_EF

@variable_diff_GH

I have created two variables @value and @threshold.

Kindly provide further steps. Appriciated your help.

Regards,
R

[richard_reeves · Accepted solution]

Thanks, This logic worked -- Appriciated your help.

[jyothirmayee_s]

Hi,

So you want all 4 measures to filter as threshold value?.How a re you displaying 4 measures on report?. single table columns?.

Thanks,

Jothi

[richard_reeves]

Hello Jyothi,

Yes i am showing all four difference in one report. The goal is to provide one input control to user and if user provides 3000 as input value then below table should only show the all the Diff A-B greater then 3000 (if available)

Regards,
R