Input Control - ALL in Block

building reports webintelligence
1

Hi,

I have a input control in my report (never used before, first time I saw it) and when I select the value - “ALL” in that and put a ReportFilter([ObjectName]) in the block cell, it gives all the values present in the object. And when I select 3 values, it gives 3 only.

I need to see - ALL when I select All in Input control, is there any solution for the same? Please guide.

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

2

Hi,

Try the formula I outlined in my post blog here: http://www.perpendulum.com/2012/04/all-in-an-input-control/

Basically, it counts the number of values in a dimension with and without the Input control filter and based on the result it provides the relevant output.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

Thanks Marek , this is working fine … Great.

Just one thing, When I used the above formula and I select multiple values - It gives me a single value so I simply put the below code instead of Else mentioned here…

Else ReportFilter([ObjectName])

Once agian thank you,…

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

4

Hi Marek,

I am not sure if there is any solution to this or not, but I noticed that suppose I have a input control named as STATE and If I select ALL, it shows ALL but if there is only a single value in STATE and I select that say - UNIVERSE, then also it shows ALL in the formulaed cell… Can it be possible to show the selected value?

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

5

Hi, the selections you make on Input Controls isn’t reflected on ResultFilter, you only see them using ReportSummary() function.
Cheers,
Rogerio

rgoulart :brazil: (BOB member since 2011-08-21)

6

Hi Rogerio, thanks for your response. The formula, ReportFilter works fine for everything except when there is a single value in Input control.

Due to single value, it always evaluates as 1 = 1 and display ALL wherein it should be displaying the selected value… And for that I am struggling, to find any possible solution…

Edit : First of all I am really sorry for post bump.

I guess I have got the solution, so thought to share with you guys -

=If( NoFilter(Count([ObjNam])) = Count([ObjNam]) And Pos(ReportFilterSummary("Report1");"No Filter") = 55;"All";ReportFilter([ObjName]) )

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

7

Sorry for coming back on this post -

=If NoFilter(Count([Lines])) = Count([Lines]) Then "All Lines"
Else Replace(ReportFilter([Lines]);";";Char(10))

This doesn’t work when there is a single value in Input control drop down reason is - It never goes into ELSE part of the logic … :frowning: :frowning: :frowning:

EDIT : This is resolved

=If( NoFilter(Count([Lines])) = Count([Lines]) And Substr(ReportFilterSummary("TabName");Pos(ReportFilterSummary("TabName");"No");2) = "No";"ALL";ReportFilter([Lines]))

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

8

I was able to solve this issue, below code is working fine for all cases-

=If ( Match(ReportFilterSummary("Account");"*Account Name*")=0;"ALL";ReportFilter([Act].[Account Name]))

Basically Between * … *, you have to give the exact object name.

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

9

To implement any kind of Input control logic for displaying values … you can view this post Input Control - Value disappers if Not in Database

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