create combobox in selection criteria

rbuser

hi,
i need to give the list of users of s/w in combo box to be selected for
search criteria and then compare that user name with three fields of same
table in query. how to do it? is it possible?

it is something like ,
table1.field1 = combo.value or
table1.field2 = combo.value

thanks,
Trupti

nicocizik

------------------------------------------------------------
Tech Tip: Replacing Built-in Dialogs/Forms in ReportBuilder
-----------------------------------------------------------

ReportBuilder has an open architecture for replacing any of the built-in
dialogs. You can replace any of the built-in dialogs by creating a new
form that inherits from an abstract ancestor and then registering it as
the new built-in dialog.

For example to replace ReportBuilder's preview dialog you could

1. Create a new Preview dialog by renaming ReportBuilder's default
preview dialog, then doing a SaveAs to save it under another unit name.

The default dialog resides in RBuilder\Source\ppPrvDlg.pas and the form
is called ppPreviewDialog. You should assign your form a unique name,
for example, myPreviewDlg, and save the unit to another name. Also save
the unit to the directory where your other forms are stored (not
RBuilder\Source).

2. Make desired changes.

You will notice that the preview dialog inherits from an ancestor
TppCustomPreviewDialog - this ancestor resides in ppForms.pas (where all
the abstract ancestor forms for ReportBuilder are defined).

3. Register the new form.

Declare an initializtion section at the bottom of the unit:

initialization

ppRegisterForm(TppCustomPreviewer, TmyPreviewDlg);


4. Add the new unit to your project and compile.

Now your preview dialog should be automatically created and destroyed by
ReportBuilder. The two page preview dialog in the
RBuilder\Demos\Reports\Demo.dpro was created this same way. The only
difference is the ppRegisterForm call is in then OnClick event of the
button.

--

rbuser

Hi Nico,

I am a novice user of ReportBuilder. Will you pls. explain in detail.
Instead of InList option of search I want Combobox and want to compare the
selected values with three different field of the same table.

Thanks,

Trupti

nicocizik

Hi Trupti,

There is an example of creating a custom AutoSearch dialog in the
\RBuilder\Demos\5. AutoSearch\4. Custom AutoSearch Dialog\... directory.
This should give you a good starting point on creating your own dialog.

--