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.
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.