Search results for query: *

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.

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

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

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

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

Thank you very much lbass. Works perfectly.

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.

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

Thanks, that was the point I forgot.

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

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

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

Our developers fixed the problem: it was constraints and information of the new table that had not been set correctly.

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

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?

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"...

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

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

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

Ok thanks I'll try it tonight