select parameter name

[crgal]

Hi, using CR 8.5 on Oracle 7..

I want the user to use a pick list to choose a field from a table and then I want to select on that field. There is more than one table, so I need to reference the table name in the select. The general format for the SQL is

SELECT tablea.value1, tableb.value1, tablea.parametername
FROM tablea, tableb
WHERE tablea.parametername is null

I see plenty of help in comparing the parameter to a field in a table, but have found little on using the parameter name as a column name.

Any help is greatly appreciated.

 

[kenhamady]

I don't think you can do this within CR. You would have to do this within your application and pass a recordset (generated by the app) to the report. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)