not in sql

rbuser

Hi,

I need to be able to produce report generated from RB Wizard to pull data
using the following query:

Select e.*
From Employee e
where e.uid not in
(Select t.Employee From TimeSheet t where t.start between :param1 and
:param2)

Can you help? Any samples I could use?

Thanks,
Dmitry

nardmoseley

You can manually edit the SQL to specify that SQL text.

What issue are you encountering? What is the environment: Delphi version,
ReportBuilder version, database engine, data access components, etc.

--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com

"

rbuser

Hi Nard,

it's Delphi 7, RB 11.04, MS SQL.
I can't manually edit sql because I need user to specify parameters using
autosearch fields (see qry
Select e.*
From Employee e
where e.uid not in
(Select t.Employee From TimeSheet t where t.start between :param1 and
:param2)
)

Thanks,
Dmitry

nardmoseley

RB 11 introduced enhancements to Parameters and SQL that make this possible.
From the Design workspace you can create Report.Parameters[ ] items that can
have AutoSearchSettings. The Parameters can be bound to query search
conditions either by using the Query Designer Search tab or by manually
editing the SQL and using the :ParameterName notation.

1. From the Design workspace, select the Parameters node from the Report
Tree. Press the right mouse button and select New. Use the object inspector
to configure the Parameters. Assign a Name and DataType and set
AutoSearchSettings.Enabled to True.

2. From the Data workspace manually edit the SQL and use the :ParameterName
notation to refer to the parameter.


http://www.digital-metaphors.com:8080/General/What's_New/RB_11/Parameters_and_AutoSearch

--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com