Post Author: dondo
CA Forum: Data Connectivity and SQL
I am trying to pre-select data in an SQL table in CR10 using a parameter. I need to insert the results into a table that is used in my report. That table then joins to another table to produce all the rows I need.I tried to create a command in Database Expert using a parameter to insert into my results table. It is not working; I get the prompt to enter the parameter but the report doesn't change and the table is not updated. I suppose the command is not being executed prior to the report opening.Any help would be appreciated.