Memorized report question

Jul 13, 2007 4 Replies

Hello,



I use a memorized report to see what is sold for one department, this is always for "today" I got this report, but when I open this report tommorow i must first change the range in "Today". Is it possible to set the range in the filter always the data of today? So i don't need to changes this every time.



Hope somebody can help me.


I think you need to use notepad to edit your memorized report and change the date filter to Craig

Craig,

I already tried that, but i can't get it to work.

It looks like this:

Begin Filter FieldName = "[Transaction].Time" FilterOp = reportfilteropBetween FilterLoLim = "13-7-2007" FilterHilim = "13-7-2007" FilterNegated = False FilterConnector = reportfilterbooleanconAND End Filter

When i change the dates to today i get an error.

Begin Filter FieldName = "[Transaction].Time" FilterOp = reportfilteropBetween FilterLoLim = "" FilterHilim = "" End Filter

Any way to get this to say LAST MONTH?

Mickie

root wrote:

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required