Skip to Content
0
Former Member
Dec 10, 2007 at 09:03 AM

Business Objects 6.5 Scheduled Reporting

351 Views

Hi,

I'm very new with business object and just wondering whether it is possible to create a scheduled report that auto-run for a specific time of the day in Business Object 6.5.

And below is the SQL codes that I run daily:

SELECT

BACKOFFICE.BRK_ACCOUNT_MASTER_VW.ACCOUNT_NO,

BACKOFFICE.BRK_ACCOUNT_MASTER_VW.ACCOUNT_NAME,

BACKOFFICE.BRK_CNOTES_VW.CNOTE_DATE,

BACKOFFICE.BRK_CNOTES_VW.CNOTE_NO,

BACKOFFICE.BRK_CNOTES_VW.CNOTE_STATUS,

BACKOFFICE.BRK_CNOTES_VW.BUY_SELL_CODE,

BACKOFFICE.BRK_CNOTES_VW.UNITS,

BACKOFFICE.BRK_CNOTES_VW.SEC_CODE,

BACKOFFICE.BRK_CNOTES_VW.UNIT_PRICE,

BACKOFFICE.BRK_CNOTES_VW.UNITS_VAL,

BACKOFFICE.BRK_CNOTES_VW.BKGE_VAL,

BACKOFFICE.BRK_CNOTES_VW.BKGE_GST,

BACKOFFICE.BRK_CNOTES_VW.NETT_VAL,

BACKOFFICE.BRK_CNOTES_VW.ADVISER_CODE,

BACKOFFICE.BRK_ACCOUNT_MASTER_VW.BRANCH,

BACKOFFICE.BRK_CNOTES_VW.ADVISER_CODE

FROM

BACKOFFICE.BRK_ACCOUNT_MASTER_VW,

BACKOFFICE.BRK_CNOTES_VW

WHERE

( BACKOFFICE.BRK_CNOTES_VW.ACCOUNT_NO=BACKOFFICE.BRK_ACCOUNT_MASTER_VW.ACCOUNT_NO )

AND (

BACKOFFICE.BRK_CNOTES_VW.CNOTE_DATE BETWEEN @variable('From Date') AND @variable('To Date')

AND BACKOFFICE.BRK_CNOTES_VW.CNOTE_STATUS != 'R'

AND BACKOFFICE.BRK_ACCOUNT_MASTER_VW.BRANCH = 'EPWM'

)

I would like to get this report scheduled and auto-save it as csv file on my hard drive instead of me running it everyday and manually save it.

I really appreciate it if anyone out there can help me on this.

thanks a lot.

Cheers,

Silva