Reports with end user input

rbuser

I am using the report builder enterprise software to give our end users
reporting capabilities. Of course we ship our product with a few pre-made
reports. One of those reports is called a history report. Our software
tracks histories for people in the database. Our users are complaining that
the report gives them all the histories that have ever been entered for
every contact.

I realize that I could hard code a date range into the report; however, I
was wondering if there would be any way for the user to select the date
range before running the report or something cool like that. Any
suggestions? Thanks.



Donovan Rogers

digitalmetaphors

Access the DataView for this report and add search criteria for the date
field. Set the operator to 'Between', click the AutoSearch checkbox. Close
the designer, saving the report. Preview the report from the explorer (the
AutoSearch dialog will be displayed.)

That's it...

Cheers,

Tom Ollar
Digital Metaphors Corporation

rbuser

Okay, I think I was able to get all that to work. However, I had to change
the way I was doing that report a little bit. Now I need to change the
group header so that it will look at the new stuff I added to the data view,
instead of the old stuff. How do I do that? Thanks for the help.

Donovan Rogers

rbuser

I figured out how to change the pipeline for the report. However, when I
preview the report the AutoSearch dialog doesn't appear. What am I doing
wrong? Thanks.


Donovan

rbuser

Ok, it turns out that the dialog appears when actually launching the report
not when the preview tab is selected. At that point I must enter a value
for the date field. When I enter a value, it comes back and says, "xxxx is
not a valid datetime." What type of information do I need to enter here?
Obviously, it needs to be a date, but what format does it want? Any
suggestions? Thanks again in advance.


Donovan

digitalmetaphors

It needs the date format as set on the regional settings of your PC...

--
Cheers,

Tom Ollar
Digital Metaphors Corporation