Displaying a DataReport

[Iain Boyd]

I am displaying a report developed via the DataReport designer using the following code -

Report_Name.Show

The data for the report is from a DataEnvironment command (a table which is cleared then refilled before the report is displayed). However, although the data is changed the report displays the equivalent of the data from the first selection, only.

Can anyone advise me what I need to do to force the report to display the new selection.

[bambang6]

Try to select the required record using the SQL statement on your Command Properties. And then put the parameter

E.g

SELECT * from order WHERE orderno = ?

Change the properties of Parameter on Command properties

and then before you activate your report put the following statement

Dataenvironment.command parameter

to make this thing more clear hereby I right the example :


in this case I want to display report from employee who work in particular City (parameter)

on Command properties :

SQL Statement

SELECT * from Employee where city = ?


On Parameters tab on command properties :

data_type : adbSTR
Hostdatatype : string

on Procedure to activate report

DIM city1 as STRING
city1 = inputbox ("Type the city")

dataenvironment1.command1 city1
report_name.show



thank you

Bambang