Hi Ong, I have the same question couple years back. I couldn't find the solution, at the end i created another field and bind it accordingly.

Just out of my curiosity though, does Rave Report have any build it function to do it ?

David Smith < djsmith_1998%40yahoo.com">djsmith_1998yahoo.com> wrote:
Having the extra fields created is the best way to do it. When the report is loaded, you bind the appropriate field to your data control. You could also do it
with a calculated field and a case statement using a variable that gets set when
the report gets loaded.

Dave
soonhuat ong < soonhuat81%40yahoo.com">soonhuat81yahoo.com> wrote: Hi,

Actually it's depend on what report is that.
For eg: Report 1 will print dvDate - 1 day, Report 2 will print dvDate- 1 week, report 3 will print dvDate - 30days etc ...

It wil be quite troublesome for me to create additional field though ..
I believe there must be some build in function in Rave Report for Date calculation(Something like dvDate - 1 - but apparently this doesnt works

Rob Kennedy < rkennedy%40cs.wisc.edu">rkennedycs.wisc.edu> wrote:
soonhuat ong wrote:
&gt; I create a dataview on my Rave Report with following fields:
> dvName = String Type
>; dvDate = Date Type
>;
> Now i drop 2 DBText components on my Rave Page, DBText1 will bind to
> dvName, and DBText2 will bind to dvDate ..
>
> The question now is, i want DBText2 to display a day before actual
&gt; dvDate value, how can i do it ??

Is this an occasion for a calculated field? Set it up in the database or
the query, and then link your text control to that field instead of the
normal one.

--
Rob

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

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

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

Messages in this topic (8) Reply (via web post) | Start a new topic

.