Reports & Discoverer :: Print Image On Criteria?

Jul 30, 2013

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 );

insert into ot_rq_head values(sysdate,1,null);

View 8 Replies


ADVERTISEMENT

Reports & Discoverer :: How To Fetch Data Based On Given Criteria

Sep 1, 2012

I need to design a report out of the below data:

1. bprf_no will be my primary field

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:

BPRF_NO BILL_MONTH NO_OF_TIMES
-------------------------------------------------
BP05 30-Jun-2012 6
BP06 30-Jun-2012 6
BP07 30-Jun-2012 6
BP08 30-Jun-2012 6

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.

BPRF_NOBILL_MONTH VOID_STATUS AVG_IND
------- ----------- ------------ --------
BP0130-Jun-1200
BP0230-Jun-1200
BP0330-Jun-1201
BP0430-Jun-1201
_BP0530-Jun-1201_
_BP0630-Jun-1202_

[code]....

My below query is fetching me wrong data:

----- Query -----
select bprf_no, no_of_month--count(*)
from
(
select a.bprf_no, count(*) no_of_month

[code]....

Here BP03 & BP04 should not come into the listing itself.

View 1 Replies View Related

Reports & Discoverer :: CASE Function With Multiple Criteria?

Jun 20, 2013

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'

View 8 Replies View Related

Reports & Discoverer :: How To Print Into Two Pages

Jul 6, 2010

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 .

View 2 Replies View Related

Reports & Discoverer :: How To Print Report If Printer Use IP

Jan 8, 2013

How to print report if printer use IP ( 172.17.10.252 , 172.16.10.252)

View 1 Replies View Related

Reports & Discoverer :: Print Special Characters

Sep 22, 2013

i want to display such as ratio and degree in the reports 6i, how can i add them ?

View 2 Replies View Related

Reports & Discoverer :: Set Print Object On All Pages

May 4, 2013

My report looks somewhat like below -

|---------------------------| Frame_M1
||-------------------------|| Repeating_Frame_R1
|| ||
|| Field_F1 ||
||-------------------------||
|---------------------------|

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?

View 3 Replies View Related

Reports & Discoverer :: How To Print Tick Sign In 10g

Jun 5, 2012

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;

View 3 Replies View Related

Reports & Discoverer :: Barcode Print In Oracle 6i?

Jun 22, 2012

How to print barcode in report 6i

View 5 Replies View Related

Reports & Discoverer :: Print Dialog Box Doesn't Appear?

Oct 20, 2010

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.

View 2 Replies View Related

Reports & Discoverer :: How To Print Customer / Office Copy In 6i

May 26, 2010

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.

View 1 Replies View Related

Reports & Discoverer :: How To Print Copyright Symbol In Rdf Report

Jul 17, 2012

how to print copyright symbol in rdf reports. I receive a ? when it gets printed.

View 3 Replies View Related

Reports & Discoverer :: Frames / Borders Do Not Print When Empty

Aug 10, 2012

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?

View 7 Replies View Related

Reports & Discoverer :: Disable Print Option In Oracle 10g?

Apr 11, 2010

I want to disable print option in oracle reports 10g while it is opening in browser.Internet explorer version is 6.

View 3 Replies View Related

Reports & Discoverer :: Print In Larger Page Size

Oct 8, 2008

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?

View 2 Replies View Related

Reports & Discoverer :: Builder 6.0.8.8.3 Print With HP 1020 Plus Printer

Aug 16, 2011

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.

View 1 Replies View Related

Reports & Discoverer :: To Print One Report And Multiple Copies

Jan 3, 2011

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,

e.g. consumer copy, bank copy and office copy.

how can it be done?

View 2 Replies View Related

Reports & Discoverer :: Control Print Job From Oracle Report?

Sep 23, 2005

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.

[URL]

View 5 Replies View Related

Reports & Discoverer :: Displaying Image From Database

Aug 5, 2013

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

View 1 Replies View Related

Reports & Discoverer :: How To Disable Print Option In Report Runtime

Jun 13, 2013

I have a report, when i run it from forms runtime then report dispay print option and other menu bar.

Is it possible to disable menu bar or Print option?

View 8 Replies View Related

Reports & Discoverer :: Print Images On Report Based On Data

Apr 25, 2013

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.

CREATE TABLE FT_GALVA (GALV_NO VARCHAR2(2),GALV_APPR_ST NUMBER,img_name varchar2(30),PIC_GALV BLOB)

Create or Replace directory image_dir as 'e:image_dir';

Grant all on directory image_dir to public

/* Formatted on 2013/04/25 23:50 (Formatter Plus v4.8.8) */
CREATE OR REPLACE PROCEDURE insert_image_file (
p_id NUMBER,
p_status NUMBER,

[Code]....

View 2 Replies View Related

Reports & Discoverer :: Formula Column Which Take Image From A Server

Mar 9, 2011

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

View 9 Replies View Related

Reports & Discoverer :: Dynamic Image In Report Without Using BLOB?

Jan 18, 2006

I have students pics in a folder. I want to display it in report using studentID.

View 6 Replies View Related

Reports & Discoverer :: Location Of BMP (image File) In Report?

Jul 14, 2011

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?

View 7 Replies View Related

Reports & Discoverer :: Document To PDF - Image Format For Best Quality

Jun 29, 2010

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?

View 2 Replies View Related

Reports & Discoverer :: Convert Report To Image Programmatically?

Feb 24, 2013

Is there any way (bean / oracle code) to convert report to image Programmatically.

View 2 Replies View Related

Reports & Discoverer :: Report Grant Total Print In Final Page

Mar 16, 2013

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.

View 5 Replies View Related

Reports & Discoverer :: Unable To Read Data In Image Format

Feb 5, 2013

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.

View 5 Replies View Related

Reports & Discoverer :: Unable To Print Report On Thermal Printer Model (PRP-085III)

Feb 3, 2013

I have developed a bitmap report on report 6i, But I am not able to print report on printer (Thermal Printer Model PRP-085III, A baylan POS printer).

I tried to convert the same report to Character mode and it print fine.

why it is not printing or what I need to set ?

View 4 Replies View Related

Reports & Discoverer :: How To Print A Report Name With Full Path At Left Bottom On Report

Sep 20, 2012

How can i print a report name with full path at left bottom on report.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved