charles
Posts: 59
|
| Posted: 03/03/2006, 3:16 AM |
|
I hope Someone can help me on this?
I am trying to print search parameters on a report page.
I know how to obtain the search parameter using the CCGETFromGet code or the retrieve value for control action.
My problem is that the search parameter is the primary key value which is an integer.Is there a way i can do some form of CCDLookup to get the corresponding name of the parameter value.Specifically, i want to display on my report form the description of the period which is, November 2005.Presently what i can do is display the PK value which is 4.
Regards,
Charles
|
 |
 |
wkempees
|
| Posted: 03/03/2006, 7:41 AM |
|
Charles you are answering your own question, good4u.
On the report put a label, where you want to display the textvalue of your
PK value.
In the properties of that label add a action->DLookup or
add an action->code in which you do a CCDLookup
the parameters only you now: f.i. CCDLookup("fieldname to lookup",
"tablename","PK=" "concatenation character for ASP" <the searchfield>,
"<your connectionname>"
GL
Walter
"charles" <charles@forum.codecharge> schreef in bericht
news:644082572ba3d9@news.codecharge.com...
>I hope Someone can help me on this?
> I am trying to print search parameters on a report page.
> I know how to obtain the search parameter using the CCGETFromGet code or
> the
> retrieve value for control action.
> My problem is that the search parameter is the primary key value which is
> an
> integer.Is there a way i can do some form of CCDLookup to get the
> corresponding
> name of the parameter value.Specifically, i want to display on my report
> form
> the description of the period which is, November 2005.Presently what i can
> do
> is display the PK value which is 4.
> Regards,
> Charles
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
|
