Value List Data in the Report Output?

[Gerry O'Rourke]

You can create a custom Value List, e.g.

ID     VALUE

1     Blah1

2     Blah2

3     Blah3

You can create a Report Definition that has an field  (which would be an ID value) linked to the Value List.

But I want the report data output to show the Value rather than the ID.

I.e. I don't need or want the value list for a filter.

But I want the data in the value list to display instead of the ID.

So the report instead of showing:

Agent     SomeIDDataLinkValueList

Alice     1

Bob      2

Would show:

Agent     SomeIDDataLinkValueList

Alice     Blah1

Bob      Blah2

Is this possible?

Gerry

[Gerry O'Rourke]

Anyone know if above is possible?

Why have an option to associate a field with a value list and not have filter checked?

i.e. I have a report with ID field and it is linked with a value list.

Should the Value list appear in the grid output or should the original field value (i.e. the id value) appear?

Gerry

[rajagkri]

The value list values do NOT appear in the grid that shows the report data. The value list values are used only for filtering purposes.

The value list values are displayed when the user runs the report, in the filter selection screen. Now, the values the user selects from the filter screen goes into the actual SQL as an IN clause, as part of the WHERE condition. The grid will contain the data returned from the execution of this SQL.

Regards,
Rajagopal