Report Builder / Date Range

Yahoo Archive
1
There is a report builder function REPORT-FILTER() that will print the
filter.

HTH

Russ Dover





_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
ctultra_met
Sent: Tuesday, May 01, 2007 2:00 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Report Builder / Date Range



That worked but is there anyway to show particular filter lines or
can you just show all?
Thank you.

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Stan
Chmura" <schmura@...> wrote:
>
> Create a calculated field; name it whatever you like, and in the
functions
> window choose REPORT-FILTER() and save (OK). After the field is
created,
> add that field to the Report header or footer.
>
>
>
>
>
> _____
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
> ctultra_met
> Sent: Tuesday, May 01, 2007 1:34 PM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: [Vantage] Report Builder / Date Range
>
> How do I get a filter date range to print on the report?
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
2
How do I get a filter date range to print on the report?
3
Create a calculated field; name it whatever you like, and in the functions
window choose REPORT-FILTER() and save (OK). After the field is created,
add that field to the Report header or footer.





_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
ctultra_met
Sent: Tuesday, May 01, 2007 1:34 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder / Date Range

How do I get a filter date range to print on the report?



[Non-text portions of this message have been removed]
4
That worked but is there anyway to show particular filter lines or
can you just show all?
Thank you.

--- In vantage@yahoogroups.com, "Stan Chmura" <schmura@...> wrote:
>
> Create a calculated field; name it whatever you like, and in the
functions
> window choose REPORT-FILTER() and save (OK). After the field is
created,
> add that field to the Report header or footer.
>
>
>
>
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> ctultra_met
> Sent: Tuesday, May 01, 2007 1:34 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Report Builder / Date Range
>
> How do I get a filter date range to print on the report?
>
>
>
> [Non-text portions of this message have been removed]
>
5
Never had a need for that. But in a quick look could not find an easy way
to segregate just one element of the filter.






_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
ctultra_met
Sent: Tuesday, May 01, 2007 2:00 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Report Builder / Date Range

That worked but is there anyway to show particular filter lines or
can you just show all?
Thank you.

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Stan
Chmura" <schmura@...> wrote:
>
> Create a calculated field; name it whatever you like, and in the
functions
> window choose REPORT-FILTER() and save (OK). After the field is
created,
> add that field to the Report header or footer.
>
>
>
>
>
> _____
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
> ctultra_met
> Sent: Tuesday, May 01, 2007 1:34 PM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: [Vantage] Report Builder / Date Range
>
> How do I get a filter date range to print on the report?
>
>
>
> [Non-text portions of this message have been removed]
>



[Non-text portions of this message have been removed]
6
I do this all the time.
Here are my notes. Same technique is useful for many tasks such as seletively turning details on/off and entering miscelaneous data (carton qty for example on shipping labels).
Todd C.

---------------------------------------------
PrtFilter = Report-Filter() ! (system function)

ParseFilter = Minimum(PrtFilter) ! must pass thru aggregate due to indirect use of function

Start-From: INDEX(ParseFilter,'/') - 2
Start-To: INDEX-NTH(ParseFilter,'/',3) - 2
FromDate: SUBSTRING(ParseFilter,Start-From,10)
ToDate: SUBSTRING(ParseFilter,Start-to,10)

What these do is to find the first "slash" and backup two characters to the start of the date. Then the next one finds the third "slash" using the INDEX-NTH function and does the same. If you had several date ranges just set the NTH part accordingly. The only reason this method might not work is if you have filters that contain slashes. Otherwise this method works really well if you happen to need to add another filter ahead of the dates (usually for performance reasons). The starting point for looking for the first date's "Equal To" will not change on you.
------------------------------
Extract Carton Qty (or any value) from filter:

PrtFilter = Report-Filter() !(system function)

ParseFilter = Minimum(PrtFilter) !must pass thru aggregate due to indirect use of function

!In the following adjust the starting point (60) as needed depending on the filters
! and the position of the first date test

StartCount: INDEX(ParseFilter,'not equal to',60) + 13
FilterCount: SUBSTRING(ParseFilter,StartCount,10)
EnterCartonCount: 9999999 ----this goes in filter as EnterCartonCount <> 0
CartonQty-Out: IIF(FilterCount = '0',
STRING(Part.UserInteger1,'9999999'),
STRING(NUMERIC(FilterCount),'9999999'))





-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of ctultra_met
Sent: Tuesday, May 01, 2007 1:00 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Report Builder / Date Range



That worked but is there anyway to show particular filter lines or
can you just show all?
Thank you.

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Stan Chmura" <schmura@...> wrote:
>
> Create a calculated field; name it whatever you like, and in the
functions
> window choose REPORT-FILTER() and save (OK). After the field is
created,
> add that field to the Report header or footer.
>
>
>
>
>
> _____
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com [mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
> ctultra_met
> Sent: Tuesday, May 01, 2007 1:34 PM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: [Vantage] Report Builder / Date Range
>
> How do I get a filter date range to print on the report?
>
>
>
> [Non-text portions of this message have been removed]
>







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