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 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: *

  • Users: robo100
  • Content: Threads
  • Order by date
  1. robo100

    Document Mystery in Web

    I have a document which is a one pager. When I run it in Desktop I get one page. when I run it in Web I get 2 pages, the second page seems to have been customised to give a bit of text and some notes with some of the actual results in. Editing the document I can't see any source for the 2nd...
  2. robo100

    Image Path replacement

    I have a problem where I am looking to rename the path where my images for documents come from. I have thousand of images attached to documents and to go through each one and replace would take far too long. Does anyone know a way of doing a mass replace in the metadata to change the network...
  3. robo100

    Smart Host / Narrowcast Problem

    Good morning We are unable to send any emails via Narrowcast, we keep getting the following error message. Error transmitting to recipient [CC3FFC7249474ED68CB20CDFBBC18CE8] - 85018:Connection refused at host 221.xx.xxx.xxx[U607ST133::SE]:3588:[THR:0x960][02/09/2009 11:30:52.812][Level:Minor...
  4. robo100

    Object Manager locking Oracle tables

    Good afternoon I am using Object Manager 8.0.2, my data warehouse is Oracle 9i. Whenever I am copying objects across from 1 project source to another the tables within the Oracle environment are locked and we cannot load any data into them or change them in any way. This never used to happen...
  5. robo100

    Help with speeding up an update sql statement

    Good morning I am trying to do an update via a sql statement on a table containing 47 million rows from a table containing 250 rows. The structures are as follows Table 1 - 47 million rows Offer_id number(5) Branch number(5) item vachar2(5) Date...
  6. robo100

    Command Manager 7.5.1

    I would like to automate a routine to add a single filter to all my reports (100 reports approx). I was hoping that command manager would be able to perform this for me. Unfortunately I have been told by MSTR that the functionality is not yet available (will be added as an enhancement request)...
  7. robo100

    Returning a record from between dates based on a date prompt

    I have the following data in 2 tables Table 1 Store Start Date End Date Value 1 1/1/00 3/31/04 100 1 4/1/04 12/31/04 200 Table 2 Month Name 2/1/04 Feb 2004 4/1/04 April 2004 Based on a prompt from table 2 I...
  8. robo100

    Calculating cumulative figures by month

    I have the following in a table Store Period Year Date Value 1 1 2004 1/1/04 100 1 2 2004 1/2/04 200 1 3 2004 1/3/04 100 2 1 2004 1/1/04 50 2 2 2004 1/2/04 75 I want to write a view to show the cumulative value by month...
  9. robo100

    APPLYSIMPLE PROBLEM

    I am trying to convert a list of dates in to a metric. For example I have the following 01/01/02 10.00 01/02/02 20.00 01/01/03 30.00 02/01/03 40.00 What I would like to see is the following pre 2003 30.00 2003 onwards 70.00 I have created an attribute using applysimple but it...
  10. robo100

    Security Filters

    I am trying to create a report that displays all the company regions sales totals. I would like to add some security such that if Region 1 Manager runs the report he or she will be able to see there totals aswel as totals for the other regions, but only be able to drill down on there particular...
  11. robo100

    calculating an end date in a query

    I have spent ages looking at this and it is starting to bug me. Does anyone know of a way I can calculated the end date in a table with a date and end date field so the data would return as follows. Date End Date 27/9/03 28/9/03 29/9/03 29/9/03 30/9/03 1/10/03...

Part and Inventory Search

Back
Top