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 Chriss Miller 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. srobiolle

    Load and save Richedit Text in database

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

    Error in ExportAsPdf : "incorrect variable type"

    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'...
  3. srobiolle

    LONG field : BO only retrieves first char

    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...'...
  4. srobiolle

    # of products that make-up 80% of sales?

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

    Show an images on report Webi

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

    Save Transform query results to a table

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

    Save Transform query results to a table

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

    INSERT INTO a table results of a TRANSFORM

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

    Pb : Adding a break automatically sorts the report alphabetically !

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

    Pb : Adding a break automatically sorts the report alphabetically !

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

    Using CLOB/BLOB field

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

    Using CLOB/BLOB field

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

    Using CLOB/BLOB field

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

    Linking reports from the same universe with different criteria

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

    Delete UnUsed Variables

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

    Access Dates

    Can you give us the SQL statement ?
  17. srobiolle

    Access Dates

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

    Delete UnUsed Variables

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

    Delete UnUsed Variables

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

    Delete UnUsed Variables

    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

Part and Inventory Search

Back
Top