Hello,
We are using BO 6.5 SP4 and SQL Server 2005. I designed the report using stored procedure. We want to schedule this report so i added code in macro and when i try to refresh the report it is refreshing for the day mentioned while creating the report.
Two input values are used for the sotred procedure while creating the report. I gave values as “Corp” and '4/1/2007".
No matter what, when i refresh the report it only using 4/1/2007 instead of the day it is passed from the macro (date passed from the macro is todays date).
The same report works good in BO 6.5.1 and SQL Server 2005.
The problem occurs only when i upgrade BO to Service Pack4. I need to get this report running on BO 6.5 SP4 because we are migration to new servers.
Any help is appreciated.
Thanks,
omprakash_k (BOB member since 2006-05-11)