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!

  • Congratulations IamaSherpa 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. MikeKeane

    Oracle ODBC

    Hi, wonder if anybody could help with this problem :- If i open from an ODBC source (which is ORACLE) for some reason i cannot see any VIEWS in the database, just tables. Does anyone know what the problem may be? Thanks in advance
  2. MikeKeane

    Multiple page of search results

    Hi, Does anyone know how to create multiple pages for serarch results extracted from a recordset? For example , if i have 200 records returned in the recordset, i want to be able to output 100 on the first page then then 100 on the next page using the "Next,End and Page no" that is used in...
  3. MikeKeane

    Returning data from oracle procedure

    Hi, Does anybody know how to return query rresults from an oracle procedure using business objects? Thanks
  4. MikeKeane

    How do i get the last time a doc was refreshed?

    Hi, which columns relate to what? there is one date field as far as i can tell (M_DOC_N_DATE) but i dont know what this means or what format this is in. Thanks.
  5. MikeKeane

    How do i get the last time a doc was refreshed?

    Hi, i need to know how many times the reports from corporate docs have been used/refreshed. Is there any way i can get this info and make a BO report from it? We do not have Webi just the client. Thanks
  6. MikeKeane

    Variable (col type)

    Hi, can anyone tell me how to find out the variable type in VBA? i need to know whether it is a number or string that is being returned by the dataprovider (column type) Any help on this would be appreciated. Thanks
  7. MikeKeane

    Filtering on linenumber() function

    Thanks, been going along the same route but to no avail. will keep trying. Bit annoyed really cus its only for cosmetic purposes to make the charts look better! But then again ive found that most problems and report writing time with BO are to make the reports look good, data is not usually the...
  8. MikeKeane

    Filtering on linenumber() function

    Hi, sorry i wasnt clear earlier. Basically i am trying to achieve a minimum of 5 rows per table. I have created a union which appends 5 blank rows to the dataset that i am extracting, this works fine. So sometimes with the data i pull back i only get one populated row of data plus the 5 blank...
  9. MikeKeane

    Filtering on linenumber() function

    Hi, I need to apply a filter to a crosstab based on the first 5 rows of data in the section. I cannot seem to get this working as it will not let me apply a filter on it. Also when i create a dimension and set a flag to say its "5 and below" based on the linenumber, this does not allow...
  10. MikeKeane

    Reading cell values from tables

    Hi, can anyone please tell me how to read the cell values from a table structure ( not the provider ) as it appears in a report using VBA? Thanks
  11. MikeKeane

    Procedures, returning data.

    Cheers, u were right, i didnt read the documentation at all! Just assumed thats all that was needed!. Thanks
  12. MikeKeane

    Procedures, returning data.

    Hi, Im trying to get BO to return data via a stored Procedure (Oracle). However i always get 'No Data Returned', even with something as simple as 'select sysdate in myVar from dual'. How do i return this value into the BO Report? Thanks
  13. MikeKeane

    117 Invalid report name

    Hi, i'm trying to rename my report (in VBA) which has been scheduled on the Broadcast Agent. However when it runs i get the following error message on the console:- '117 Invalid report name.' It does not seem to matter what I put as the reportname it will still error. It works fine using full...

Part and Inventory Search

Back
Top