Data Reports

[whittam]

I was wondering if anyone knew how to concatenate fields in a data report.
Do you do it in the data enviroment or on the report itself????

[Nathan]

The easiest way to do this would be to do it in your sql in the data environment.

ie. in your command do something like this...
SELECT ('Mr./Mrs. ' || FIRST_NAME || ' ' || LAST_NAME) AS FULLNAME
FROM TBL
WHERE ....

then refrence it in your report as FULLNAME

let me know if this isn't clear or if you need more help.

[whittam]

I'll give this a try but why I'm here I have another problem with data reports, I want to know how to specify parameters.

I have to select all kinds of info from sifferent tables which I did with an SQL in the data enviroment but I have to get the dates which the report is approprate for from the user. How do I do this?????

[Nathan]

the only way to do this would be to use parameters in your command object in your sql and open that command object with the parameters before displaying your data report. let me know if you need more help....