Recent content by asmetana

Sange, I never found an adequate solution other than to resize the images so they were all approximately the same size. I have been working some with Oracle Reports and it seems to do a better job with images (although it has its own problems).

I have an Oracle 9i database on Windows 2000 that has jpeg images stored in blobs. When I include the blob field in a report, the property inspector indicates the field is an image and it has a length of 4 which is not right. The image does not display. I just get a few funny characters in the...

I have a CR 8.5 report that contains images from an Oracle BLOB field. Using "Can Grow" on the format tab will do proportional scale. However the image field is sized for the first image and if some later image is larger than the first, it will over flow the space allowed for the...

Is it possible to force a formula to be evaluated during pass 3? That is at the same time TotalPageCount and PageMofN are evaluated. This would let me place a fixed size text field containing a table of contents at the front of the report. The TOC itself can be built using the ideas presented...

HI, Try adding a second detail section with the name and address fields in it for the bottom section. I.E. something along the following: Detail a {name} {address} ------------------------------------------------------ Detail b {name} {address} Please return...

Output from Totext of a large number (>10^17) causes Tonumber to error with "String is non-numeric". The following made up sample illustrates the error: tonumber(totext(1.*10^17)) This error happens because totext returns scientific notation for large numbers and tonumber doesn't...

Thanks Mike, You gave me an idea that I have implemented below. It seems to work (at least for the dozen different test cases i have tried. //convert a numeric string, which may be in scientific notation, to a number // numbervar strlen; numbervar eloc; stringvar str :=...

Noglem, What the coding is starting to evolve to is: stringvar str :=replace({table.textcolumn}," ",""); //remove blanks if str[1] = "+" then str := replace(str,"+"," "); if numerictext(str) then . .

I am not sure I agree that it is not a bug. While the plus sign is optional to designate a positive number, including it still represents a vaild number. Just one more thing to have to code around while addressing my real problem: Crystal Reports doesn't recognize scientific notation...

I am using the numerictext function to see if a string represents a number. The problem is numerictext("+3") [positive 3] returns FALSE. It should return TRUE. Numerictext works correctly for [negative 3] i.e. numerictext("-3") returns TRUE. Have other people run into...

I am using CR 8.5 to report on an Oracle database. My detail records are of the form age_in_days, number1, number2. If I select "for each record" a plot number1 and number2, the labels for the X-axis are sequential values (record number?) 1 --> the number of records. Is there any way...

I am using CR 8.5 to chart numeric data from a formula. Is it possible to control the formating of the labels? For example my x-axis labels are in the form of xxx.xx and the y-axis labels are X (whole number). What I need is whole numbers for the x-axis and X.xxx for the y-axis labels?

I have a report which contains around 40 subreports. Each subreport uses the value of SAMPLES.U_SAMPLEID specified by the use and hard coded (one or several) TASKS.METHOD (s). I have recently discovered that there are times when there is not a one-to-one relationship between U_SAMPLEID and...

A somewhat simpler way build the file name based on the code in the previous reply is to use the "Iw.m" format code. This code will add leading zeros to the number. --- snip --- C Set the suffix one time FNAME3(INAM+4:INAM+7) = '.out' C Run loop to create files...

I have a report with ~40 subreports in it. To speed processing, I am using a query created with SQL Designer. If I run the query without a parameter (explicitly setting the where criteria), save the query and data, and then run the report, the report works great. This requires a multistep...