Search results for query: *

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

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

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

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