It can be done by putting a condition in the where clause of data provider...
like...
Date between prompt('Enter From Date') AND prompt ('Enter To Date')
run the report. it will ask you to enter the from_date and to_date and will fetch the records accordingly
I hope this is what you needed
Do you want a field in the report that will say the Date on which the report was refresh or run.
Add a variable "<var>" with formula
=LastExecutionDate("data provider name").
If you create a new data provider with only two queries only, (6+3) measures. Does these queries contain the tables you dont need and is the output is correct...?
Hi.
Business Objects does not support this..
But if you want to customize your report as per this requirement you can do through vba scripting.
All you need is to add to write the script in the before refresh event.
create user form that will look like as of BO prompt window.
And fetch the...
In BO you can create reports through... universe(created through the designer module), stored procedures, vba, and data files.
If you have a installed utitlities with BO then u can see all the sample reports and universes created.
Why dont you go through the online guides available with BO.
Go...
Hi
Initially I asked you to try with DayDiff through VBA.
DayDiff calulates the Hours betn 2 dates.
But this folmula is not taken for the new variable you add.
If anybody knows "how to put calculated values in the local variable?" will be a great help, this variable is created...
Hi
You need a add a variable through VBA script.
There is a function called daydiff in VBA, (pass the paramter h for hour, m for minute, as interval)
Shyam
webi identifies the repository database through bomain.key,
it does not identifies any other <name>.key
bomian.key has all the information, I think you need to keep bomain.key in LocData folder.
Since you have copied the bomain key from other m/c and put it on the server. You need to create...
Hi.
I tried some demos to get this error.
when I changed the system time so that it will not in between the service license period, then I received this error.
So this error may occur if your service license of BO is over.
Check out the license period.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.