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 strongm 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. johnwolf

    Ranking in arrays

    Many thanks, works perfectly as always. It would not have occured to me to create another array and successively change to 0 the values of the first array. Still learning thanks to you.
  2. johnwolf

    Ranking in arrays

    {@a} Sum(@A SALES) {@A SALES} If {SALES.AGENT} ="A" then {SALES. AMOUNT} else 0
  3. johnwolf

    Ranking in arrays

    I am sorry I am figuring that the formula of the FAQ is placed at the detail level, where as mine as in the footer. My mind will be fresher tomorrow morning. Thanks
  4. johnwolf

    Ranking in arrays

    Thanks LB for your answer. I am sure you are showing me the right direction but I just cannot figure it out In the FAQ you mention, the multiple parameter list is already ordered and the values in the array belong to that list. In my question, the values in the array do not belong to any...
  5. 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...
  6. johnwolf

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

    Thanks for your answer The minimum function is used to determine if the order of the customer is the first one for this particular customer, i.e. if it is a new customer. I do not no if it is the most effective way. Any idea welcome.
  7. 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...
  8. johnwolf

    How to delete parameters in a report

    Thanks, that was the point I forgot.
  9. 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...
  10. johnwolf

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

    Hi, Thanks for the answer, I am not sure it is only a crystal issue, but as the first line break is after a punctuacion I thought it could be a internal formatting issue. On the other I tried to use a smaller character size so that it fitted in on line, but with no results. I will try a wider...
  11. 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...
  12. johnwolf

    Error Message &lt;PESetNthTableLocation&gt;

    Our developers fixed the problem: it was constraints and information of the new table that had not been set correctly.
  13. 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...
  14. johnwolf

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

    Thank you very much LB. That is clear and accurate. Works perfectly. One question to make sure I understood well: To make a selection, I have to put the same WHERE clause at the end of each of the UNION ALL blocks, correct?
  15. johnwolf

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

    Thanks for your answer Here is SQL query D01_DET_ALBARANES_CLIE es SALES_ORDERS D01_DET_ALBARANES_PROV es PURCHASE_ORDERS FECHA es DATE PRECIO es PRICE CANTIDAD es QUANTITY SELECT "D01DET_ALBARANES_CLIE"."FECHA", "D01DET_ALBARANES_CLIE"."CANTIDAD", "D01DET_ALBARANES_CLIE"."PRECIO"...
  16. johnwolf

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

    Thanks for your answer. I have access to the data only through Crystal and know almost nothing of SQL and less of Oracle. From what I understand, I do no think I have problems with the data itself as both tables are simple as described above. To create a report I use the table relations menu...
  17. johnwolf

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

    Thanks for your answer. I do not understand exactly what you mean. I am used to group/hide details in many reports, but my first logical problem is the link beetween the 2 tables: should it be only on the item#. From the result I get it seems it should be otherwise. I thought I could use a...
  18. 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...
  19. johnwolf

    Steps to pass from a domain to a stand alone PC

    Ok thanks I'll try it tonight

Part and Inventory Search

Back
Top