Create two variables,example, start_date and end_date
Assign these variable with a InputBox
Enter this code in the main Edit Script
// Title of source to display in QV
SQL select nvl(sum(appt_cnt), 0), nvl(sum(semn_cnt), 0), nvl(sum(apply_cnt), 0 )
as appts from web_track
and trunc(crdt) >= to_date($start_date)
and trunc(crdt) < to_date($end_date) + 1
Change the dates in the inputbox and reload the document
If your query loads all data up front then it should be possible to filter out it(it can be done with the Chart object at least)
Otherwise , it is easy to use a macro to do an silent reload(and even partial)
Select Document Properties from the Settings menu
Select the variable in the Variable Event Triggers - list, click Add Action
Select External and Run Macro, click OK
Click Edit Module
Add some code for a Reload-function
// Check for valid content
if ActiveDocument.Variables("ENDTIME").GetContent.String<>"-" then
// This reload hides the splash dialog as well
Close and select it in the dialog
And thats about it.
The same code can be applied on a Button-macro or whatever.
This will help. What about is this is a statics report. Like in first go i will load all the data from my table abd then i run the query to fetch the data from the loded table. In this case will that be required to reload data or do we have any other method to do that. What basicallt i wanted to do is , i will create a report that can be veiw by some other end user , so they might dont have the database to which i am connecting . In this case they will be having the statics report . How should i proceed in this case.
I think i am making some sense here. Please let me know if u want any clarification.
Thanks for help