Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. bensonpa

    ashridharan

    I'm afraid you can't use alerters on charts. This functionality just doesn't exist.
  2. bensonpa

    ashridharan

    I'm afriad you can't use alerters on charts. This functionality just doesn't exist.
  3. bensonpa

    Overriding Prompts in Business Objects

    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...
  4. bensonpa

    Renaming a report tab?

    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...
  5. bensonpa

    product key

    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.
  6. bensonpa

    Why cant I see all of my report????!!!!!!

    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.
  7. bensonpa

    Multiple queries- same input

    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...
  8. bensonpa

    VBA in BOb

    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...
  9. bensonpa

    Calculations right after the query

    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...
  10. bensonpa

    Running BO reports from command line..

    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...
  11. bensonpa

    Suppressing Empty Cells

    You can't filter out columns. Only rows.
  12. bensonpa

    Is any body has a repository on security domain

    This question doesn't make any sense. The security domain is part of the repository.
  13. bensonpa

    Adding objects to the Universe

    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...
  14. bensonpa

    Using CASE statement and aggregate fn in BO

    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.
  15. bensonpa

    Help on Command Line Arguments in BO

    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...
  16. bensonpa

    Date format with import from generic ODBC????????????

    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.

Part and Inventory Search

Back
Top