RAP Parameters

rbuser

Hi!

I've been using RAP for a couple of weeks now but I have a question.

I have a report where the query is built from the query builder of the DATA
tab. It is a simple report which displays a list of values between two
dates. Once the query wizard is done, the SQL statement looks like this:

Select SomeValue
where Date1 >= 01-01-01
and Date2 <= 01-01-02

I've designed a form with two DateTimePickers on it and I would like to be
able to change the Date values of the query within the RAP module. I
already managed to showmodal the form from the GlobalOnCreate event of the
RAP but I just don't know how to pass the values into the query.

Thanks!

nardmoseley

1. Use the Data workspace to define AutoSearch parameters for the Query (see
article below).

2. The DataTime picker can be implemented by creating a custom autosearch
dialog. See RBuilder\Demos\AutoSearch\Custom AutoSearch dialog. This example
implements a date picker.


----------------------------------------------------
Tech Tips: Creating AutoSearch parameters via DADE
----------------------------------------------------


1. Access the Data workspace of the Report Designer.

2. Create a DataView using the Query Wizard or Query Designer.

2. A DataView tool window will be displayed in the data workspace.

3. Press the Search button. The Search tab of the Query Designer will be
displayed.

4. Add a search criteria item and select the AutoSearch checkbox. You can
optionally select Mandatory as desired.

5. Close the query designer.

6. Now when you select the Preview tab of the Report Designer. A search
button will appear on the toolbar. This displays the AutoSearch dialog.

7. By calling Report.Print in code, or by selecting print/preview from the
report explorer the AutoSearch dialog will be automatically be displayed.




--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com

rbuser

In article <3f9520e3@dm500.>, steve.riley@micromedica.qc.ca (Steve Riley)

rbuser

Hi!

Thanks for the fast responses!

The thing is that I don't like the Built-in dialog. Worst than that: my
boss can't stand it.

What I really want, in fact, is a custom made dialog.

Any hint ?

nardmoseley

See RBuilder\Demos\AutoSearch\Custom AutoSearch dialog. You can replace the
dialog!

--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com