hi
i have a date field in my report now i want to filter on the date
when i press refresh button
i should get a popup saying enter start date and finish date
when i fill the dates and press ok the report should be filtered between those days
i think this can be atchived using vb macros
i dont know any thing about macros and how to write the macros
any one has the sample code or notes that would be a great help
thankyou
arvind.alex 
(BOB member since 2005-05-14)
Why don’t you just use standard prompt functionality? When you click refresh, you’re going to rerun the query. Include prompts for the beginning and ending dates and you’re done, no VBA code required.
Plus, be advised that even if you do get a VBA solution that does what you want, you cannot then publish that report to Webi. You can’t use interactive VBA scripts in full client reports that are refreshed via Webi. Nor can you use anything with VBA code on a UNIX server.
Dave Rathbun 
(BOB member since 2002-06-06)
yes i agree with you dave
can i get brief material on VBA where i can user VBA macros for fullclient and webi report
that would be a great help
thankyou
arvind.alex (BOB member since 2005-05-14)
[quote:5c075854cf=“arvind.alex”]can i get brief material on VBA where i can user VBA macros for fullclient and webi report
[/quote]
There is no VBA for webi. If you have a license for the SDK then you can download documentation from the tech support site, as per this topic in the SDK forum.
Dave Rathbun (BOB member since 2002-06-06)