Dynamic Parameters values?

[ImArchimedes]

I'm trying to create a truely dynamic parameter field but CRXI doesn't seem to want to let me.

What I want the parameter field to do is pull values from a given field to populate the values in the parameter but it needs to change dynamicly. If I choose static and pick a value field, it will pull those database values into the values for the parameter field I'm making. What I would like to do is elect a field and have the values dynamically change depending on the database it is run on.

Example:

Three customers have the same field with different values

Cust. A field values: Fishing, Raking, Jogging
Cust. B field values: Skiing, Sleding, Snowboarding
Cust. C field values: Swimming, Tanning, Volleyball

One report would return the same prompt but with different value for them to choose from base on their db's field values.

Cust. A prompt:
"What would you like to do today?"
Fishing
Raking
Jogging

Cust. B prompt:
"What would you like to do today?"
Skiing
Sleding
Snowboarding

Cust. C prompt:
"What would you like to do today?"
Swimming
Tanning
Volleyball

I have a work around which is to pull down the customers database, set report to that dbs location, and then modify the parameter to pull values static from the field in their db. Obviously this slows the process down quite a bit and I couldn't make one report for all my customers. I'd have to make a different version for each customer.

Can anyone tell me if this is possible? I hope I made sense.

 

[lbass]

You could potentially create a command that uses a parameter for the database. Create a string parameter {?DB} within the command, and then populate it with the database names in the main report->field explorer->edit parameter.

select {?DB}.`field`
from {?DB}

You should actually build all the fields you need into this same command, which would then become the entire datasource for your report.

-LB