Search results for query: *

Following the thread thread102-1198575 : After 2 hours of web research and tests, I finally found a working solution (using Delphi 7.0) for loading and saving richedit text (with attributes) in an access database. Rules to follow are : - the Access field must be of type "OLE Object" - this...

Hello, I have a Delphi program that uses OLE to automatically refresh and export to PDF BO reports. In BO V5, everything was fine, the following code was exporting the WHOLE report to PDF : BOApp := CreateOLEObject('BusinessObjects.Application.5'); BODoc := BoApp.Documents.Open('TEST.REP'...

Hello, I try to use a LONG field (Oracle database). I've made a simple test, with one table containing one field. In the Universe, this field is defined as "Long Text". When I make a query on this data, BO only returns the first char of each row : Table = 'AAAAAAAAAAAAAAAAAAAAA...'...

Is it really possible ? Example : Sales : product 1 = 20 $ product 2 = 20 $ product 3 = 60 $ Total = 100$ Which products make 80 % of the sales ? P1 and P3, but also P2 and P3. You can calculate 80% of the total, 80% of a number of products, but all the products making 80% of the total...

Hi Claude (frenchy user like me ?), I have tried lots of solutions for putting an image in a Webi report. Copying the file on a virtual directory is one, but you need to have access to the server, which is only the case on "small" business. I personally can't do that, so what I do is...

I just discovered that it is possible to do a "SELECT * from [query]" : it is perfect from me ! Thanks, Stéphane

Hi everybody, Here is my problem : I have a TRANSFORM Query that works great. I would like to automatically run the query and save the results to a table (with VBA) . I have worked around Recordset and DoCmd, but can't succeed. Any help ? Thanks Stéphane

Can you give a more detailed example ? I have the same problem, but do not understand how to resolve it Thanks, Stéphane

Yes, I've tried to sort the data, but it gets me to a trickier problem : - when sorting in SQL, nothing happens and the problem is the same (although the data is correct in the data window!) - when sorting in BO on my internal ID, I need to put it into the table, then hide it. But BO doesn't...

Hello, I have a report which looks like : COL 1 COL 2 .... COL X A8 rrrr A8 rrrr A8 aaaa A8 ffff A8 ffff A8 zzzz A1 yyyy A1 zzzz A1 zzzz A1 aaaa COL 1 and COL 2 have their own sorting criteria (an...

I've tried this, and all kinds of conversions, but it fails. So, diving into the oracle books (their documentation web site is just incredible !), here is some explanation : - the CLOB type is a TEXT type of 4 Gb size, - you can SELECT a CLOB field from SQL/Plus, but not inside Designer or...

My field contains plain text, but the CLOB type can surely contains something else.

Hello, I have a field in my Oracle database table which is of type "CLOB" (seems similar to BLOB). How can I use it in a report ? Designer refuse to create an object based on that field. Thanx Stéphane

Though I may have not understood all of your post (due to my poor english !), and Sridharan gave you the solution, just a last question : why not create a second dataprovider, with your condition d, then display in your table the informations from dataprovider 1 (condition a, b and c) and...

Thanks to all for your answers. I've written a little script for which I would like your advice. It checks all variables and proposes to delete the ones that seems erroneous : Sub CheckVariables() Dim BadVariables As String Dim Value As String Dim Var As DocumentVariable Dim...

Can you give us the SQL statement ?

Is the universe definition also in a Access table or in an Oracle one ? The way the date is stored in the database can be different, and be interpreted in a wrong way by B.O. What happens if you create in Designer the sub-variables Year/Quarter/Month related to your date, and the print them in...

I often rearrange my reports to improve them, and I like to use variables. So, after a while, I get in my report a lot of variables that are not used anymore, because they are replaced by new ones (I keep the old ones in case). To do so, I go and search every variable marked with a red icon to...

Thanx, that's the way I do it today. I'm looking for a "hidden" function which would do it automatically and delete all that is unused in a document. Stéphane

Hi all, Is there a way to quickly delete unused variables ? (those that appear with a red triangular icon at the beginning of the line) in Data/Variable (that is in a french version) Thanks Stéphane