Report Builder - Date Range Heading

Yahoo Archive
1
Randy,

Check out the "Overtine Hours - NTF" report in the acct.prl library.
This is a good example on how to pass the filter information to the
report.

Have Fun...

--- In vantage@yahoogroups.com, "randyduly" <randy.duly@...> wrote:
>
> I would like to create a report that has a date range that is
pulled
> from the report filter. For example, our report filter might be
> something like:
>
> ShipHead.ShipDate >= 03/04/2007
> and ShipHead.ShipDate <= 03/21/2007
>
>
> and I want this to show at the top of the report as:
>
> Shipping Report
> From 03/04/2007 to 03/21/2007
>
>
> Can this be done?
>
> Thanks,
>
> Randy Duly
> IT Manager
> National Tube Form
> 3405 Engle Road
> Fort Wayne, IN 46809
>
2
I would like to create a report that has a date range that is pulled
from the report filter. For example, our report filter might be
something like:

ShipHead.ShipDate >= 03/04/2007
and ShipHead.ShipDate <= 03/21/2007


and I want this to show at the top of the report as:

Shipping Report
From 03/04/2007 to 03/21/2007


Can this be done?

Thanks,

Randy Duly
IT Manager
National Tube Form
3405 Engle Road
Fort Wayne, IN 46809
3
You could just make 2 calculated values, 1 of which being
minimum(shiphead.shipdate) and the other being the maximum. Just stick
them in your header with a label that says 'to' in between them. Quick
and dirty, but it works.







Steve Mulder

Information Systems

712-324-4854 x1196

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of randyduly
Sent: Monday, July 02, 2007 11:23 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder - Date Range Heading



I would like to create a report that has a date range that is pulled
from the report filter. For example, our report filter might be
something like:

ShipHead.ShipDate >= 03/04/2007
and ShipHead.ShipDate <= 03/21/2007

and I want this to show at the top of the report as:

Shipping Report
From 03/04/2007 to 03/21/2007

Can this be done?

Thanks,

Randy Duly
IT Manager
National Tube Form
3405 Engle Road
Fort Wayne, IN 46809





[Non-text portions of this message have been removed]
4
Create a calculated field. In the calculated field add ReportFilter(). Add
your new calculated field to your header. Define the field with enough
characters to show your whole filter, Use word wrap if necessary.

Shirley Graver
Rubber Associates Inc.

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
rfc822 Compliance issue From: added by system POTENTIAL SPAM
Sent: Monday, July 02, 2007 12:31 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder - Date Range Heading



I would like to create a report that has a date range that is pulled
from the report filter. For example, our report filter might be
something like:

ShipHead.ShipDate >= 03/04/2007
and ShipHead.ShipDate <= 03/21/2007

and I want this to show at the top of the report as:

Shipping Report
From 03/04/2007 to 03/21/2007

Can this be done?

Thanks,

Randy Duly
IT Manager
National Tube Form
3405 Engle Road
Fort Wayne, IN 46809






[Non-text portions of this message have been removed]
5
We would like to do the same thing someone help us. Thanks Dee

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
randyduly
Sent: Monday, July 02, 2007 10:23 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder - Date Range Heading



I would like to create a report that has a date range that is pulled
from the report filter. For example, our report filter might be
something like:

ShipHead.ShipDate >= 03/04/2007
and ShipHead.ShipDate <= 03/21/2007

and I want this to show at the top of the report as:

Shipping Report
From 03/04/2007 to 03/21/2007

Can this be done?

Thanks,

Randy Duly
IT Manager
National Tube Form
3405 Engle Road
Fort Wayne, IN 46809






[Non-text portions of this message have been removed]
6
If you want to actually extract date fields from the filter text you must pass the whole filter text through an aggregate field and then parse out the characters you want. I posted a reply on June 28 to this same question that has detailed instructions specific to from/to dates. The message subject was 'Report Builder". If you can't find the reply I can forward it to you off-list.
-Todd C.

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of randyduly
Sent: Monday, July 02, 2007 11:23 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder - Date Range Heading


I would like to create a report that has a date range that is pulled
from the report filter. For example, our report filter might be
something like:

ShipHead.ShipDate >= 03/04/2007
and ShipHead.ShipDate <= 03/21/2007

and I want this to show at the top of the report as:

Shipping Report
From 03/04/2007 to 03/21/2007

Can this be done?

Thanks,

Randy Duly
IT Manager
National Tube Form
3405 Engle Road
Fort Wayne, IN 46809



________________________________
The information contained in this E-mail message and any documents which may be attached are privileged and confidential, and may be protected from disclosure.

Please be aware that any use, printing, copying, disclosure or dissemination of this communication may be subject to legal restriction or sanction. If you think you have received this message in error, please reply to the sender.

For more information please visit www.harveyvogel.com


[Non-text portions of this message have been removed]
7
Randy, the other method is to create 2 parameter fields in your Crystal report- a begin date and end date and use them to print these fields on your report header. You can then select/create your record selection filter based on the two begin and end date parameter fields. I do reports like this a lot and it works easier than parsing out I think. Hope I was on the same page as you with the question.
Thanks
RSN


----- Original Message ----
From: Todd Caughey <caugheyt@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Monday, July 2, 2007 11:01:28 AM
Subject: RE: [Vantage] Report Builder - Date Range Heading

If you want to actually extract date fields from the filter text you must pass the whole filter text through an aggregate field and then parse out the characters you want. I posted a reply on June 28 to this same question that has detailed instructions specific to from/to dates. The message subject was 'Report Builder". If you can't find the reply I can forward it to you off-list.
-Todd C.

____________ _________ _________ __
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of randyduly
Sent: Monday, July 02, 2007 11:23 AM
To: vantage@yahoogroups .com
Subject: [Vantage] Report Builder - Date Range Heading

I would like to create a report that has a date range that is pulled
from the report filter. For example, our report filter might be
something like:

ShipHead.ShipDate >= 03/04/2007
and ShipHead.ShipDate <= 03/21/2007

and I want this to show at the top of the report as:

Shipping Report
From 03/04/2007 to 03/21/2007

Can this be done?

Thanks,

Randy Duly
IT Manager
National Tube Form
3405 Engle Road
Fort Wayne, IN 46809

____________ _________ _________ __
The information contained in this E-mail message and any documents which may be attached are privileged and confidential, and may be protected from disclosure.

Please be aware that any use, printing, copying, disclosure or dissemination of this communication may be subject to legal restriction or sanction. If you think you have received this message in error, please reply to the sender.

For more information please visit www.harveyvogel. com

[Non-text portions of this message have been removed]






____________________________________________________________________________________
Get your own web address.
Have a HUGE year through Yahoo! Small Business.
http://smallbusiness.yahoo.com/domains/?p=BESTDEAL

[Non-text portions of this message have been removed]