Occasionally BCA picks up ghost prompts where may have been used in earlier versions of the reports, When sending to BCA your prompted for answers to A, B and C but when the document is processed on the server it comes up with A, B, C and D. I have found I can cure this by first purging all the...
You must use VBA to programatically change the name of the tab. Using busobj.ActiveReport.Name = "New tab name" will change the name of the active tab. You'll need to use an Application variable to make this refer to something in your query. Not sure how to do this though. But if your...
Product keys are specific to your licence and are determined by the modules you purchased and the connectivity you require. Call Business Objects and they will give you YOUR key.
Hello, Have you tried using the NoFilter() function? You can wrap it around the syntax of any field you wish to ignore filters on. I'm afraid I don;t have time to understand your problem fully but this may help.
Just to expand on the above comment: All prompts with the same text (case sensitive) will be displayed only once to the user. So you can re-usea prompt as many times as you need within the same document either by choosing the prompt from the list (as above) or by typing in the same text. This...
Document events are usch as 'AfterRefresh', 'BeforeSave', 'BeforeClose', 'BeforeRefresh' etc. Is this what you were asking? Double-click on 'ThisDocument' in the project window and change the drop-down on the code window from 'General' to 'Document' and you will see these events on the next...
It depends on your database but the syntax for your object should be defined as something like:
Oracle -
to_date('01/01/1900','dd/mm/yyyy') + numberofdaysfield
SQL Server -
dateadd(d, numberofdaysfield, '01/01/1900')
No need to use VBA etc unless you're connecting to some sort of ropy...
You didn't say what version of BusinessObjects you're using but you'd have to do this with a script. f it's v4 then you need to use '-script' and with v5 you'll need to embed the script (VBA) into the report.
Not sure of the VBA syntax but it's pretty straight forward and the v4 script can be...
Brian,
If you create a 'variable' in a report (I say variable because they're not 'objects') then there is no facility to add this into the universe. If you create a 'User Object' (see query panel) then this can be included in the universe via the Designer module. I don't know of any...
Seen this once before. It's some sort of limitation of DB2 (certain versions only) and in order to get around it we had to remove all functions from the SQL.
The 'my_var' value is the name of the prompt rather than a variable. So your prompt should be @Prompt('my_var',....). When you create a promt in BusinessObjects it creates a variable (in memory) with the same name as the prompt. By loading the text file on startup you're pre-assigning a value to...
Joran,
Unfortunately I don't have an answer to your date issue but I would be interested to find out what you did to make the connection to Lotus Notes in the Designer module. I assume you installed some Lotus ODBC drivers etc. Any info would be useful. Thanks.
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.