Skip to Content
0
Former Member
Sep 14, 2007 at 08:06 PM

Create Database Expert command to insert data into table for use in report

35 Views

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.