Year to date Values should come in the report

building reports desktopintelligence
1

Hi,

I have a requirement in the report; a user can select in prompt any specific date from the last 4-5 years and then data should be displayed as per his selection but in a specific column he should be able to get values for the current year first date (Eg: 01-Jan-10) to till date.

can anybody help me with the formula for this plz.

Thanks
Praveen

kk@bi (BOB member since 2009-06-16)

2

Hi Praveen

One way to achieve this is using BETWEEN in universe.
In the object syntax write the code similar to below

<DateObject> BETWEEN (@Prompt('Your date prompt in the report')) AND SYSDATE

Ideally the code works like this:

SELECT
Table.col
FROM
Table
WHERE
Table.dateColumn BETWEEN (@Prompt('Your date prompt in the report')) AND SYSDATE

Thanks

BI.User (BOB member since 2007-05-22)