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 TouchToneTommy 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: johnwolf
  • Content: Threads
  • Order by date
  1. johnwolf

    Ranking in arrays

    Hi to all Using CR XI and Oracle. I need to extract the 1st, 2nd, 3rd, 4th, 5th positions of an array of 5 variables Array = [{@a},{@b},{@c},{@d},{@e}]. (those variables are sales totals per salesmen). To get the highest and lowest values of this array, it is easy, using maximum and minimum...
  2. johnwolf

    Is it posible to orders groups based on results of a manual RT

    Hi Using CR XI I am counting new customers per sales rep during current month. I have a report based on orders table with Group 1 : sales rep Group 2 : customer ID Details: order ID, date, Manual RT Formula init recuento in G1H whileprintingrecords; numbervar recuento:=0; Formula...
  3. johnwolf

    How to delete parameters in a report

    Hi Using CR XI with ORACLE DB I am using a report originally created in CR 8 and saved to CRXI. It works fine. I need know to delete the parameters that were used. I have deleted all the references to parameters in records selection, formulas, sections formatting and i still cannot delete...
  4. johnwolf

    How does CR XI break long strings into different lines when exporting

    Hi I am using CR XI. For each order processed and sent, I want my customer to receive a link to follow up the delivery. This link is generated by CR formulas that depend on the freight forwarder Show you an exemple: String result within CR is: <a...
  5. johnwolf

    Error Message &lt;PESetNthTableLocation&gt;

    Hello, Using CRXI WITH ORACLE DB AFTER A CHANGE IN OUR DATABASE, I.E. RECOVERY OF A TABLE BY CREATING A NEW ONE AND THEN DELETING THE OLD ONE, AND THEN GIVING THE NAME OF THE OLD ONE TO THE NEW ONE, ALL REPORTS WE RUN THAT INCLUDE THIS TABLE DO NOT WORK AND GIVE THIS ERROR: CRYSTAL REPORTS...
  6. johnwolf

    How to print in a report movements from two tables organized by date ?

    Hello Working with CR8 and Oracle DB I am trying to show the movements of goods we buy and sell. I have two tables organized in the same way. Table 1: PURCHASE ORDERS PUR_ORDER# ITEM# PUR_QUANTITY PUR_PRICE PUR_DATE 1 DA019039 30 12.50€ 2009/01/02 1 DA025003 12 4.00€ 2009/01/02 36...
  7. johnwolf

    Steps to pass from a domain to a stand alone PC

    Hello Using XP pro SP2. This laptop was formerly attached to the SBS 2003 domain of my company. I would like to have this laptop quit the domain and create a stand alone profile. I am understanding that doing so might create password problems on this PC. I do have an domain administrator...
  8. johnwolf

    How to save a sub report indenpendantly from a main report

    Using CR8 with Oracle I put a sub report into a main report. Then I made many changes to the subreport. I would like to save this subreport to be able to use in other main reports. Is there anyway to achieve that? Thanks in advance.
  9. johnwolf

    How to count only the last calls made to each customer?

    Using CR8 with Oracle I am currently counting calls to customers in our call center, using a table which is as following CALLS_TBL CALL_ID AGENT_ID CUSTOMER_ID CALL_TYPE (PROSPECT, NEGOTIATE, SELL...) CALL_RESULT (UNAVALAIBLE, QUALIFIED, SALE,...) CALL_STATUS (COMPLETED, PENDING) CALL_DATE...
  10. johnwolf

    Why does my parameter field fail?

    Hello Using CR 8 and Oracle Database I am creating a report to help final user find the last prices paid for a product by a customer within a date range My tables are like INVOICES HEADER Customer Number Invoice Number (1) ... INVOICES DETAILS Invoice Number (1) Product ID (2) Quantity...
  11. johnwolf

    How to print a formula using two running totals in a group header ?

    Hello, Using CR 8 / Oracle database. I am new to CR I am programming a report where I calculate the maximum annual savings in costs per print using generic against original toners Data sample PRIMARY_REF OEM_REF CAPACITY TONER_TYPE PRICE PRINTER_NAME aaa Q5949A 2500 OEM $50 HPLJ1320...

Part and Inventory Search

Back
Top