Custom user prompt for date range

rbuser

Using integrated ReportBuider Enterprise Edition v9.02 (no plans to
upgrade due to issues in newer Delphi releases).

We can set a search filter on a date field in the query designer, but
there is no way to set a default date range (i.e.: for the previous
week; =(CURRENT_DATE) or =(CURRENT_DATE - 8)). My hope is that we
sould set a custom prompt in the calc tab in the report designer.
However, after searching the Digital-Metaphors wiki and other parts of
the web, I have not found a way to prompt for dates or date ranges
outside of the query designer (i.e. GetUserListValue(aMessage, aValue)
or GetUserString(aMessage, aDefault)).

Is this possible? If so, how?

Thanks in advance!

--

-Dustin T Waling

nicocizik

Hi Dustin,

Which version of Delphi are you using? Out of curiosity, what issues
are you having with later versions of Delphi? In our experience, the
latest versions of Delphi are light years ahead of the legacy versions.

I'm a bit unclear about where you would like this user prompt to
display. If you are using AutoSearch, you can simply set up a date
range in the query designer with AutoSearch set to True and the
AutoSearch dialog will show a calendar control for your users to select
a date before the report prints. For examples of this, take a look at
the AutoSearch demos.

rbuser

Nico,

The Auto prompt is what I am using already, and the issue with it is
that you cannot set a default date range if the user does not select a
range. So what I am hoping is that there would be a way to manually
create a user prompt (via custom procedure in the calc tab procedures).
This way if the user does not select dates I can specify a default
date range based on the current date. Any thoughts or advice on this?

regarding the updates, I am not on that particular part of the dev
team and this is what I was told. I just specified this to be clear
that updating was not an option for me in this scenario.

thank you,
-Dustin

On Wed, 08 Oct 2014 07:54:41 -0600,

nicocizik

Hi Dustin,

Which version of Delphi are you using?

It is possible to set up a "default" date range simply using the query
designer (data tab). When creating a search condition, simply set the
operator to "Between" and the value to ", ". With
AutoSearch checked, these dates will now be the defaults when the dialog
is shown.

rbuser

We are using v9.02

I have tried this, but the when the report is run from the software,
the default that I set in the Value field is not set. We only see a
date picker defaulted to the current date and the checkbox to opt for
"All Dates..."

Is there a parameter for the Value field that needs to be hooked when
running reports from the software? Is there something I need to discuss
regarding a missing piece in the integration with our dev team?

Thank you!
-Dustin


On Thu, 09 Oct 2014 09:24:06 -0600,

nicocizik

Hi Dustin,

Version 9.02 is the ReportBuilder version, not the Delphi version.

We are only able to provide support to Delphi developers with a full
version of ReportBuilder installed. If you are using ReportBuilder
embedded into another application, you will need to contact the
developer of that application for support (which I believe is your "dev
team").

If there is an issue with ReportBuilder, they can then contact us with
their full Delphi version, full ReportBuilder version, and a detailed
description of the problem for further help.

rbuser

Sorry, I missed that part of your question, we are building with
Delphi 6.


On Fri, 10 Oct 2014 09:13:08 -0600,