default values date prompt

building reports desktopintelligence
1

I have a report with date prompts :

Tdate between Start Date &End Date;

For a WebI Report published in Infoview,
Users are interseted in yesterday(sysdate-1)'s date.To avoid refresh time they want this to be default data when they open the report in Infoview before refresh.After this,they also want the option to refresh the report for start,end dates .
Environment BOXIR2,.net environment Infoview

Any suggestions would be of great help.
Thanks

rd (BOB member since 2004-10-19)

2

Im not sure whether we can run macro in WebI XI.
But if it is DeskI, You can get help here

KhoushikTTT :us: (BOB member since 2005-02-24)

3

Looks like we cant run macros in WebI
I tried macros in DeskI based on the following code from BOB forum topics:
.
Private Sub Document_BeforeRefresh(Cancel As Boolean)
Call Default
End Sub

Sub Default()
For i = 1 To ActiveDocument.Variables.Count
If ActiveDocument.Variables.Item(i).IsUserPrompt = True Then
If ActiveDocument.Variables.Item(i).Name = “Enter As-Of Date (dd/mm/yyyy or dd-MON-yyyy)” Then
ActiveDocument.Variables.Item(i).Value = Date
End If
End If
Next i
End Sub

But teh default values are populated every time I run the macro manually(Tools->Macro->Run)
Ex:When user hits refresh button and enters Start Date:10-25-2006
End Date:10-26-2006
these values are stored as default values for prompts unless I do manually purge teh data providers.
If teh report is refreshed without manually running the macros(Tools->Macros->Run option current date values do not show up as default values.
Is there a way to force the macros to be run automatically on report refresh.

Is there any way to set a default value for prompts or LOVS at teh Designer level.

Thanks

rd (BOB member since 2004-10-19)