Recent content by promero

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.

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

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;)

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

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

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

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

Please, use a meaningful subject in your messages.

Please, use a meaningful subject in your messages.

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

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

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

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

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

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