Search results for query: *

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

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

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

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

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

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