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!

Register Log in
  • Congratulations derfloh 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. promero

    URL of a document in WebIntelligence passing parameters

    Hi S Sudhakar Sorry, but I have no access to Business Objects 6, so I don't know. About user/pass sending, I don't know either. You should try with the SDK (wiasp or wijsp) as pabloj said, but I can see you are already trying it. About GetHTMLView, sorry but I have not tested it.
  2. promero

    How to write a PDF

    Hi! I'm new to the forum! I must create a PDF in an Agent (Notes 5.0.10). I have tried with Excel 2000/Acrobat PDFWriter. In my machine it works ok, but in the Domino server the code halts at Excel.Application.PrintOut. No error is thrown, and no other agent can be executed on the server until...
  3. promero

    Concatenation

    At universe level (DB2 databases): TIMESTAMP(Date, Time) At Report level: =AsDate(FormatDate(<Date>,&quot;d/m/yyyy&quot;) & FormatDate(<Time>,&quot; H:m:s&quot;), &quot;d/m/yyyy H:m:s&quot;)
  4. promero

    URL of a document in WebIntelligence passing parameters

    Sorry, sDocType=R for full-client documents. See FAQ on this forum for more info.
  5. promero

    URL of a document in WebIntelligence passing parameters

    I finally make it work. the syntax that works for me is: http://<ServerName>/wi/bin/iswi.dll/WIGenerator/wigenerator/ generator/OpenDocument? sDocName=<DocName>& sDocType=W& iDocId=<DocId>& sRepoName=<DomainName>& sOpen=R& lsS<PromptNamet1>=<Value1>& lsM<PromptName2>=<Value2>&...
  6. promero

    Nesting Function Help!!!

    If I have not missed something, it would be like this: <COL1> = Left(<COL>, Pos(<COL>, &quot; &quot;) - 1) <COL2> = Left(SubStr(<COL>, Length(<COL1>&&quot; &quot;)+1, 1000), Pos(SubStr(<COL>, Length(<COL1>&&quot; &quot;)+1, 1000), &quot; &quot;) - 1) <COL3> = Left(SubStr(<COL>...
  7. promero

    URL of a document in WebIntelligence passing parameters

    I want to launch a document from another in WebIntelligence. I know how to make a web link in a document. The content of the cell must be &quot;<a href=&quot;URL&quot;>TEXT</a>&quot;. This works both in HTML and in PDF. URL and TEXT can be placed dinamically with a formula. Now my problem is...
  8. promero

    Hi, My next problem is Is the

    Please, use a meaningful subject in your messages.
  9. promero

    Hi, I have created a document

    Please, use a meaningful subject in your messages.
  10. promero

    fn locate function

    You can make that operation at report level with the following formula: =Substring(<User Id>, Pos(<User Id>, &quot;\&quot;) + 1, 100)
  11. promero

    Filtering on linenumber() function

    Try applying a ranking. Rankings allow to show only the first N values of a dimension sorted by an associated measure. For more information see &quot;Rankings&quot; in the &quot;Business Objects User Manual&quot;.
  12. promero

    How do I get a macro in a report to autorun?

    Make sure the Sub is in the pre-existent ThisDocument module, and not in a user-created module. Document events go there. If you have done that already, try to debug the code to ensure it's doing what is expected: Place the cursor in the first instruction of the Sub, press F9 (switch break...
  13. promero

    BO Sorting Problem!

    That's ok T.Blom, except alkfhk is talking about sorting, not about filtering. My workaround is (similar to T.Blom's first one): Make an Excel file with all the values of the dimension object you want to sort. Make a data provider from the Excel file. Link the dummy dimension with the real...
  14. promero

    Execution time of the report

    You could take the time before and after the refresh with VBA, and assign the difference to an user variable. Add the following code to the ThisDocument module of VBA. Refresh the document and you will have a variable called <Execution Time> with the time between before and after refresh...
  15. promero

    Broadcast Agent and VBA

    That's the error reported when an error has raised in your code, but BA does not report which error has raised. Test and debug the code interactively in your computer to know what happens. A possible source of error is considering always MyFilterVar.Values(boUniqueValues) as an array. The...
  16. promero

    Counting Dates..

    The solution at universe level can reduce the number of rows returned by the database (using SQL agregation), improving BO performance. There's also solution at report level. Create a new variable called <Year/month> with the following expression: =FormatDate(<Date>, &quot;yyyy/mm&quot;)
  17. promero

    Alternative prompts

    >You can do this by editing the SQL and clicking the do >not regenerate box. You can also make a filter in the universe with that expression, and use that filter in the query panel of the report.
  18. promero

    How to use PrintOut ?

    Use the name of that printer as it's shown in the &quot;Control Panel\Printers&quot; folder, not the original net printer name.
  19. promero

    How to use PrintOut ?

    You must specify the name of a printer installed on your machine. You cannot specify an arbitrary net printer. So, install &quot;\\Path to Our Server\Our Printer&quot; in your machine (browse to it, right click it and select &quot;Install&quot;). After installing it, you will have a new printer...
  20. promero

    suppressing empty pages

    You can stretch the report to fit in one page with. Go to the File menu, Page Properties option. A more complex, and probably inviable, solution is to add a vertical break to the crosstab from a variable derived from the dimension you use in the horizontal edge. Then replace the horizontal...

Part and Inventory Search

Back
Top