Description of a Parameter field

[johnstrang]

Dear All,

Using CR 8.5 with a direct connection to an Oracle database.

I have a parameter field {?Section}, with default values imported from a text file which was created from an SQL Select statement on the Ref_Section table in the database:

 select section_id, section_desc from ref_section

1 Department A
2 Department B
3 Department C
etc

Users select the required department by name, but the parameter field {?Section} holds the Value.

My question is, how can I display the Description in CR?

I want to report on all Jobs where the Section is
a) the Creator of the Job, and
b) an Approver of the Job for another deprtment.

I would like to group on a) and b) so have
GH1 - Jobs created by "Description"

GH1 - Jobs Approved by "Description"

I hope I have explained this clearly enough.

Thanks in advance,

John

 

[hilfy]

Add the Ref_Section table to your report and either link it to another table on the report that contains the section_id field (preferred method!) or don't link it but set up a selection criterion that reads {ref_section.section_id} = {?Section}.

-D