Dropdowns in Request Pages in Reports?

pablosn

Hi,

Can anyone let me know how you create a dropdown (looking at the values in a table) in the request page of a report?

Thanks in advance

tanmaykothari

Dear pablosn

go to Req form-> text box where u want to show drop down->
properties->table relation -> table name.field

example

if i want to display dropdpwn for location code then

properties->rable relation -> location.code

here location is table name
and code is field of that table

try this

Sergii_Chernenko

The problem is that when you click the assist button next to the TableRelation property nothing will happen.

But. Indeed, if you type the relation manually it will do the trick.

pablosn

Thanks but, I am using a Page not a form, but I am unable to enter anything in the table relationship field. I am using variables for the input parameters, if this helps clarify the situation.

pablosn

Thanks to both of you that works. It would appear that not everything works logical way.

Thanks again

ivicaSD

tanmaykothari wrote: »

if i want to display dropdpwn for location code then

properties->rable relation -> location.code

I have successfully enabled dropdown in the Request Form using this suggestion, but I can only select one value here (I am using Manufacturer.Code)

IF there is a need to select multiple values, the only solution I have found is to set DataItem properties: ReqFilterFields. I have dropdown AND I can select/type multiple values separated with pipe sign ("|")