I have a report based on one table with three columns , one column will be updated upon user intervention that if approves the status flag of that column will be 3 and if he amends it will be 1 , by default it will be null.I want to display digital signature or image if the status is approved.I want to store the image/digital signature in Database.Do i need to create a table with BLOB column and store.
create table ot_rq_head ( r_date date, r_no number , r_status number );
2. report parameters will be the bill_month & no_of_months
Based on above 2 parameters I need to scan through the data for BILL_MONTH <= '20-Jun-2012' and NO_OF_MONTHS <= 6 the other criteria being the AVG_IND in (1,2).
In brief the criteria will be to pick all BPRF_NO having AVG_ID in (1, 2) consecutively till a break (AVG_IND not in (1, 2) starting from the given BILL_MONTH and going below this period, that is BILL_MONTH <= '30-Jun-2012'.
For the below data, if my parameters are: BILL_MONTH <= '30-Jun-2012' and NO_OF_MONTHS <= 3, only the underscore added data should be picked (as they fulfill the criteria) and the report output will be like:
Here the NO_OF_TIMES is the count, that is no of times the BPRF_NO falls into the above mentioned criteria consecutively starting from the provided BILL_MONTH.
I am using: Desktop / Discoverer 4.1 / Windows XP.
I am attempting to add a new calculated column and have had some success with the CASE function but need to add additional criteria.
What I have that works is:
SUM(CASE WHEN Expenditure Type = 'Supplier Rebates' THEN Total Spend Plus Commit ELSE 0 END)
What I need to add are a few additional criteria. I attempted and failed with a few variants of this:
SUM(CASE WHEN Expenditure Type = 'Supplier Rebates' AND Capitalizable = 'Y' AND Task Owing Company = '534' OR '915' THEN Total Spend Plus Commit ELSE 0 END)
The three criteria points that I am looking to includea are:
•Expenditure Type = 'Supplier Rebates' •Capitalizable = 'Y' •Task Owing Company = '534' OR '915'
I am creating report a using emp table .There are 14 rows in emp table , i want to print output into two pages . If i set FILTER TYPE Property to 5 ,it only shows 5 records .
For M1, R1 and F1 I have set print object on All Pages and base printing on Enclosing Object. After running the report, output is only one page and consists of 7 rows. But as per the query it should have fetched 21 rows.
When I have changed print object on property to First Page, it output is 2 pages and consists of all 21 records.So, why print object on All Pages generating only one page while print object on First Page generating 2 pages?
searched here for Tick Sign in Reports & Discoverer section, but did not find. i am trying to work on Reports and have a requirement of Tick Sign should appear in report if the column value is 'Y' means yes.
i tried following SQL statement in SQL*Plus, but failed to find and Tick Sign.
declare n number:=0; c varchar2(1); begin for i in 1..255 loop select chr(i) into c from dual; dbms_output.put_line ('* '||lpad(to_char(i),3,' ')||' -> '||c); end loop; end;
I have designed a report (by oracle report 6) when i run it on the report preview when choosing print the print dialog box doesn't appear on other pc the dialog box appears.
I want the print dialog box to show.
I set the JOBPRINT parameter to yes which is the default value but didn't solve it.
How to Print Customer Copy / Office Copy in rports 6i for example i want to print two copies of any report i want that on first copy of report shows CUSTOMER COPY and second copy of shows OFFICE COPY and report may be on multiple pages.
Inherited a report created in 6i (works fine) and learned it doesn't correctly display in 10g! (Example attached) Cell frames do not print when there's no info to display, leaving blank gaps in the report. Is this a bug or something in Reports 10g that's causing the problem?
I have this problem. I need to print in paper size of 14.875x11 or us std fan fold. But when I print, some part is not printed, like a size of 11x8.5. Questions:
1) Is there a way I can print in 14.875x11 without configuring the page setup to 14.875x11 and automatically print what ever i can see on my live pre viewer? 2) What should be the value of Report Width/Height if it affects the printing size?
I am using HP laserjet 1020 plus printer with windows xp sp2 and reports builder 6.0.8.8.3. Problem is that printer does not print the reports generated by d2k i suppose printer command is not sent to printer. My another printer HP laserjet 1160 can print the same reports without any trouble.
I am generating a report/invoice. I want to print three copies of one report, one copy for consumer and one copy for bank and one copy for my official use. All three copies should have proper table,
How I control hte print job from Oracle Report. The problem is that If I do a report and print out, there should not be allowed to any user to print again. Here I also want to control the user list who can print a report.
In my table I have a column for storing image path how can I display the image in my report.I added a file link and specified the image source and the image is displayed when running report.
is it possible to make the source dynamic, based on the primary key entered by the user??
how can i print the stored images in reports 6i from database, based on the condition,that suppose if i have one field approval status whose flag is either 3 or 1 , based on this flag ,if the status is 3 then image should be displayed otherwise no. the rest of the process.
I have wrote this code behind a formula column which take the image from a server. The name of the image and location is carried out from database. When ever there is new record new name of the image is posted in this formula column. But when the file is not present in the location it gives error. When the error occur i cant able to view the report. The error says 'You cant run the report without layout'. When all images are present in the directory then report runs fine.
function CF_QID_IMAGE return Char is l_file_exists BOOLEAN; l_file_len NUMBER; l_blocksize BINARY_INTEGER; image_link varchar2(50); [code]...
I just started working for a company and am modifying existing reports. This report has a logo in the layout in the form of an image. Is there a way to find out where this image is located? It cannot find the image when I open the layout or run the report so I assume I am not mapped to the drive/directory where the images are located? Is this information noted anywhere in the actual report?
i'm generating some document to pdf and sending them to a company. When they print them out the images in the pdf aren't very good, although they look ok in the pdf. i think it's a gif format at the minute.
what is the best image format for the best quality?
I am Created one Invoice Report with Text Output which as Require to Print in Pre-Print Stationary Page,In it the Total Value is Require to Print Down which as Anchored and It printing fine,But when ever the Invoice Contain lot of Items then the Total Value is Print in Multiple Page, as per user requirement as to Print in Single Page only.
I have a database in access 2003 with the empno,empname and photo (bounded image). Using queries and an ODBC connection I have inserted the table into Oracle 8i (8.1.7). When I try to read the data using reports I get 'REP-1818 Unable to read data in image format.' error for the photo field.
