Dynamic Parameter with a Dynamic List

[codrutza]

CRXI
I’m trying to have a dynamic parameter with a dynamic list of values. At refresh the list it gives me to choose between customers that start with A until customers that start with K, and I want just the ones which start with S.
1. If I need them all, from A to Z, how can be done?
2. I put {?Customer}={Table.Customer} and {Table.Customer} startswith “S”, but parameter has in list again customers that start with A until customers that start with K
3. If users input a new Customer, appears or not in the list?
Please help.

 

[lbass]

I think you should use a command set up like this:

select left(table.customer,1) as 'Initial'
from table
union
select 'All'
from table

Then reference {command.customer} to populate the dynamic parameter. Your selection formula then should look like this:

(
(
{?Customer} <> "All" and
{Orders.Ship Via} startswith {?Customer}
) or
{?Customer} = "All"
)

Don't link the command to your table--just ignore the message that says there are two datasources--and don't reference the command in the main report. Use it only to populate the picklist.

-LB

 

[codrutza]

Hello, thanks for your reply.
- What means "and don't reference the command in the main report. Use it only to populate the picklist"?
- I obtain customers where the rest of the records are blank. Do you know why?
example:
Customer: Loader
1 j1 Hong Kong 19/12/2008 Cape Town 09/01/2009 Loader
2 j5 Hong Kong 15/08/2011 Keelung 17/08/2011 Loader
3 Loader
4 Loader
5 j2 Yantian 12/08/2011 Vostoc 18/08/2011 Loader

- Instead of {Orders.Ship Via} I put {table.customer}

- I don't get all the customers, maybe I've mistaken something

 

[codrutza]

Sorry - I think I do get all the customers that have j