Filter value


Filter value

Groups | Search | About

User Password

Lost Password?

Point-Of-Sale Software - - MS Point Of Sale software discussed here

get this group's latest topics as an RSS feed

add this group's latest topics to your My MSN content

add this group's latest topics to your My Yahoo content

add this group's latest topics to your Google content

Yahoo!

Google

Windows Live

del.icio.us digg

digg

Netscape

Subject

Author

Date

Filter value

cesmi1

12-06-2006

Glenn Adams [MV...

Scott

Jeff @ Check Po...

Posted by cesmi1 on December 6, 2006, 12:16 pm

Please log in for more thread options

I'm trying to put a filter value into a report's .qrp and am having
difficulty with the right syntax.

I want to set the filter to take the current date and subtract 120 days from
it. The filter is currently set to:
Begin Filter
FieldName = "[Transaction].Time"
FilterOp = reportfilteropbetween
FilterLoLim = "<Today>"
FilterHiLim = "<Today>"
End Filter

I would like FilterLoLim to be: FilterLoLim = <Today> - 120

How can this be accomplished?

Posted by Glenn Adams [MVP - Retail Mgmt on December 7, 2006, 12:10 pm

Please log in for more thread options

It can't. The filter limits are just string tokens that represent
special dates - Today, start of month, start of year, a couple of
others. You can't perform math on them.

You could use the SelectionCriteria to limit the entire report to the
past 120 days:

SelCriteria = " ([Transaction].[Time] >= (dateadd(dd,-120,getdate()))) "

No mater what date range is selected in the filter, the reprot would
always be limited to the past 120 days...

Glenn Adams
Tiber Creek Consulting
http://www.tibercreek.com
glenn@tibercreek.com
----------------------------------------------
Please DO NOT respond to me directly but post all responses here in the
newsgroup so that all can share the information.

cesmi1 wrote:

> I'm trying to put a filter value into a report's .qrp and am having

> difficulty with the right syntax.

> I want to set the filter to take the current date and subtract 120 days from

> it. The filter is currently set to:

> Begin Filter

> FieldName = "[Transaction].Time"

> FilterOp = reportfilteropbetween

> FilterLoLim = "<Today>"

> FilterHiLim = "<Today>"

> End Filter

> I would like FilterLoLim to be: FilterLoLim = <Today> - 120

> How can this be accomplished?

Posted by Scott on December 7, 2006, 10:08 pm

Please log in for more thread options

I run a series on reports every Monday and would love for these memorized
reports to default to "month to date". I can edit reports in .qrp. I would
like the syntax for editing a memorized report to default to month to date.
Any help would be appreciated.
Scott

> I'm trying to put a filter value into a report's .qrp and am having

> difficulty with the right syntax.

> I want to set the filter to take the current date and subtract 120 days

> from

> it. The filter is currently set to:

> Begin Filter

> FieldName = "[Transaction].Time"

> FilterOp = reportfilteropbetween

> FilterLoLim = "<Today>"

> FilterHiLim = "<Today>"

> End Filter

> I would like FilterLoLim to be: FilterLoLim = <Today> - 120

> How can this be accomplished?

Posted by Jeff @ Check Point Software on December 8, 2006, 5:36 pm

Please log in for more thread options

: quoted-printable

Scott,

Modify your filter in the report you memorized to;

Begin Filter
FieldName =3D <Whatever you're using>
FilterOp =3D reportfilteropBetween
FilterLoLim =3D "<MonthStart>"
FilterHilim =3D "<Today>"
End Filter

On the phone, I thought you said you wanted 3 days?

--=20

Jeff=20
Check Point Software

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

You must be using Outlook Express or some other type of newsgroup reader =
to
see and download the file attachment(s). If you are not using a reader, =
follow
the link below to setup Outlook Express. Click on "Open with =
newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

I run a series on reports every Monday and would love for these =
memorized=20
reports to default to "month to date". I can edit reports in .qrp. I =
would=20
like the syntax for editing a memorized report to default to month to =
date.
Any help would be appreciated.
Scott
> I'm trying to put a filter value into a report's .qrp and am having
> difficulty with the right syntax.
>
> I want to set the filter to take the current date and subtract 120 =
days=20
> from
> it. The filter is currently set to:
> Begin Filter
> FieldName =3D "[Transaction].Time"
> FilterOp =3D reportfilteropbetween
> FilterLoLim =3D "<Today>"
> FilterHiLim =3D "<Today>"
> End Filter
>
> I would like FilterLoLim to be: FilterLoLim =3D <Today> - 120
>
> How can this be accomplished?=20

------=_NextPart_000_059E_01C71AD6.4811FB50
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dwindows-1252">
<META content=3D"MSHTML 6.00.5730.11" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#008000>Scott,</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Modify your filter in the report you =
memorized=20
to;</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Begin Filter<BR>   FieldName=20
=3D <Whatever you're using><BR>   FilterOp =3D=20
reportfilteropBetween<BR>   FilterLoLim =3D=20
"<MonthStart>"<BR>   FilterHilim =3D =
"<Today>"<BR>End=20
Filter</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>On the phone, I thought you said you wanted 3 =

days?</FONT></DIV>
<DIV><BR>-- <BR><BR>Jeff <BR>Check Point Software</DIV>
<DIV> </DIV>
<DIV>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D</DIV>
<DIV> </DIV>
<DIV>You must be using Outlook Express or some other type of newsgroup =
reader=20
to<BR>see and download the file attachment(s).  If you are not =
using a=20
reader, follow<BR>the link below to setup Outlook Express.  Click =
on "Open=20
with newsreader"<BR>under the MS Retail Management System on the =
right.</DIV>
<DIV> </DIV>
<DIV><A=20
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A><BR>=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
<BR></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #008000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Scott" <<A=20
=
t;=20
wrote in message <A=20
=
4112@TK2MSFTNGP04.phx.gbl</A>...</DIV>I=20
run a series on reports every Monday and would love for these =
memorized=20
<BR>reports to default to "month to date".  I can edit reports in =

.qrp.  I would <BR>like the syntax for editing a memorized report =
to=20
default to month to date.<BR>Any help would be=20
appreciated.<BR>Scott<BR>"cesmi1" <<A=20
=
soft.com</A>>=20
wrote in message <BR><A=20
=
37EDD-FD9C-4E98-9AF4-DE3FECEB7386@microsoft.com</A>...<BR>>=20
I'm trying to put a filter value into a report's .qrp and am =
having<BR>>=20
difficulty with the right syntax.<BR>><BR>> I want to set the =
filter to=20
take the current date and subtract 120 days <BR>> from<BR>> it. =
The=20
filter is currently set to:<BR>> Begin Filter<BR>>  =
FieldName =3D=20
"[Transaction].Time"<BR>>  FilterOp =3D=20
reportfilteropbetween<BR>>  FilterLoLim =3D=20
"<Today>"<BR>>  FilterHiLim =3D "<Today>"<BR>> =
End=20
Filter<BR>><BR>> I would like FilterLoLim to be: FilterLoLim =3D =

<Today> - 120<BR>><BR>> How can this be accomplished?=20
<BR><BR></BLOCKQUOTE></BODY></HTML>

------=

Similar Threads	Posted
Filter a report	August 10, 2007, 7:10 am
SQL-web item- with 1 more filter?	May 19, 2008, 9:14 am
Modifying Report Filter	June 23, 2005, 7:20 pm
Modifying Report Filter	June 27, 2005, 8:19 am
How to get Filter parameter values in QRP ??	July 15, 2006, 6:34 am
Report with Negate Filter	September 5, 2006, 3:51 pm
Date sold filter value	July 21, 2007, 9:41 pm
Report Filter focus	March 6, 2008, 11:44 am
Statement filter date	July 8, 2008, 9:31 pm
Report date filter problem	August 18, 2005, 4:49 am

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software

XML Sitemap