Hi,
Does flash variable recognize blanks for ALL to work.
In fiddler, captured syntax
GET /BOE/Xcelsius/opendoc/documentDownload?iDocID=128450&sKind=Flash&Year=&Con=%20&CELogonToken=
this is not getting any data in the Child dashboard.
Appreciate
kraf (BOB member since 2013-06-25)
I think %20 is a literal “space”. So this is the same as filtering for {fieldA} = " "
I believe…without knowing much about your environment, you want to pass
%
not %20
So, youll have to work it out so that your OpenDoc formula does exactly that.
Cairmor 
(BOB member since 2008-06-05)
Env: Dashboard Design4.0
dashboard built thru Qaaws Queries
Here is the URL syntax
=“http:///BOE/Xcelsius/opendoc/documentDownload?iDocID=128450&sKind=Flash&Year=”&C29&"&Con="&C30&"&CELogonToken="&C17.
Values passing from filters for:
If Year = 2000 & Con=1, then the child dashboard get values but
if Year = All & Con=All, then no data in child dashboard.
Also why is the fiddler generating con=%20 & year=blank…this values are generated wheb both the parameters are “All”.
Appreciate
kraf (BOB member since 2013-06-25)
Here is some logic that I think will help:
In C29 and C30 you need formulas to say…
if (cell of combobox value = “All” then “%” else cell of combobox value )
Cairmor (BOB member since 2008-06-05)
Appreciate the Input,
Quick Tip,
For “ALL”, in the excel formulas pls check that you do not give space in between quotes " ". cause this would put %20.
correct way is “”.
kraf (BOB member since 2013-06-25)