Report builder filter

Yahoo Archive
1
Dick,
Are you putting the calculated field into the filter?

-----Original Message-----
From: PLAMAN DICK [mailto:dick.plaman@...]
Sent: Thursday, May 10, 2001 10:09 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] report builder filter


I've been meaning to ask the question for a while.
I have a receipt report that looks at receipts from yesterday.
where I have a calculated field, yesterday = Today() - 1
This works great for every day except monday where you would
get Sunday's activity. If I change the formula to the following;
yesterday = iif(Weekday(Today() = 2, Today() - 3, Today() -1)
the reports takes half an hour to generate output. Has anyone
else experienced this slowdown?

To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
2
I've been meaning to ask the question for a while.
I have a receipt report that looks at receipts from yesterday.
where I have a calculated field, yesterday = Today() - 1
This works great for every day except monday where you would
get Sunday's activity. If I change the formula to the following;
yesterday = iif(Weekday(Today() = 2, Today() - 3, Today() -1)
the reports takes half an hour to generate output. Has anyone
else experienced this slowdown?
3
I'd guess that with the first one, RB stuffs in a constant date, and then
passes the query of to the server where it runs quickly. The 2nd version
probably requires RB to pull every record in, and process them on your PC.

You might try making an extra calculation, like 4DaysAgo and change the
condition to Date >= 4DaysAgo and Date = Yesterday
That might allow more of the filtering to happen on the server. Lem'me
know if it works?!

-Wayne

At 11:09 AM 5/10/2001 , you wrote:
>I have a receipt report that looks at receipts from yesterday.
>where I have a calculated field, yesterday = Today() - 1
>This works great for every day except monday where you would
>get Sunday's activity. If I change the formula to the following;
> yesterday = iif(Weekday(Today() = 2, Today() - 3, Today() -1)
>the reports takes half an hour to generate output. Has anyone
>else experienced this slowdown?