Report Filters

Yahoo Archive
1
I create a couple calculated fields,

Today which is today(),

WeekPast which is today() - 7,

MonthPast which is today - 30.



You get the idea. Seems to work OK with the users.



Mark Dupuis



_____

From: peterlv2002 [mailto:peterlv2002@...]
Sent: Friday, March 04, 2005 2:53 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Filters




I have build a report using the progress report builder. I would like
to use the progress syntax 'today' 0r 'today()' as a filter on this
report. I get an error message. I hate to have end users change the
filter, it seems more than most can hold. Any sugestions?





Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links






Yahoo! Groups Sponsor



ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=129u2v94s/M=298184.6018725.7038619.3001176/D=gr
oups/S=1705007183:HM/EXP=1110052472/A=2593423/R=0/SIG=11el9gslf/*http:/www.n
etflix.com/Default?mqso=60190075> click here



<http://us.adserver.yahoo.com/l?M=298184.6018725.7038619.3001176/D=groups/S=
:HM/A=2593423/rand=652240498>



_____

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.



[Non-text portions of this message have been removed]
2
I have build a report using the progress report builder. I would like
to use the progress syntax 'today' 0r 'today()' as a filter on this
report. I get an error message. I hate to have end users change the
filter, it seems more than most can hold. Any sugestions?
3
I define it in a calculated field (called "ThisDay") and then use that. Often also make one called "Yesterday" ( Today() - 1).
-Todd C.

-----Original Message-----
From: peterlv2002 [mailto:peterlv2002@...]
Sent: Friday, March 04, 2005 1:53 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Filters



I have build a report using the progress report builder. I would like
to use the progress syntax 'today' 0r 'today()' as a filter on this
report. I get an error message. I hate to have end users change the
filter, it seems more than most can hold. Any sugestions?





Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=129u2v94s/M=298184.6018725.7038619.3001176/D=groups/S=1705007183:HM/EXP=1110052472/A=2593423/R=0/SIG=11el9gslf/*http://www.netflix.com/Default?mqso=60190075> click here
<http://us.adserver.yahoo.com/l?M=298184.6018725.7038619.3001176/D=groups/S=:HM/A=2593423/rand=652240498>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




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