Questions on selecting fields for reports.

rbuser

Hi All

. I am using the report explorer with dbisam. Everything is working like a
charm so far. THe only question that I have is how can I print a specific
set of records without changing the sql.

For example I need to print an invoice. the way it works now it would print
all the invoices. But I need just to print a certain one. Again I am using
the report explorer and the users will be designing there own reports but I
don't want them to change the sql everytime they need another number
printed. I am using D7+RB Pro.

Any Ideas.

Thanks,
Marc
Sault Custom Programming

rbuser

Hi Marc,

you have to use the 'AutoSearch' feature. Select 'Search' on the data tab and define the search criterias.

HTH,
Chris Ueberall;

rbuser

Thanks Chris,

That solves one problem. But is there a way for me to pop up a dialog to ask
for the value from the user or do they have to fill in that search createria
every time?

Thanks,
Marc

rbuser

Hi Marc,

sure, check the checkbox for the search dialog.
see demo 'RBuilder\Demos\3. EndUser\1. Report Explorer' report 'LessThan: Amount Paid (Currency)'

regards,
Chris Ueberall;

rbuser

Thanks again Chris.

That works but is there a way to force that dialog to pop open on the
preview so that the user could enter the value themselves or to fill that
value in programmaticly? The problem I am having is that the user will want
to print on invoice and not all of them. Also I could do this with sql as a
seperate report file but then it woudn't be part of the report explorer. Any
ideas?

Thanks,
Marc

rbuser

Marc,

If you checked the use of the search dialog then the dialog should pop up upon previewing. I don't understand why you are stating that it works when it doesn't. The given demo works fine for me and asks before previewing for the desired value. You can force the search dialog in preview mode by clicking on the auto search button. Did you run the demo I suggested?

regards,
Chris Ueberall;

digitalmetaphors

Yes, the designer is designed to not show the autosearch dialog when
changing tabs, even if ShowAutosearchDialog = True. We think it would be
annoying if it always popped up the autosearch dialog while you are
designing a report:)


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Sorry my fault. Going to preview from the editor doesn't bring up the dialog
but if I right click and preview from the explorer it works as you said.

Sorry for the problems.

Marc
Sault Custom Programming

rbuser

I agree. It just had me going nuts thought.

Thanks.
Marc