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


ADVERTISEMENT

Reports & Discoverer :: Bad Images Cause Report To Crash

Aug 26, 2013

We have a report that is using a blob and in that blob is a text string that is in base64. The text string is converted into an image via a function that is a java class. The function works well when executed from SQL Developer, PL/SQL Developer, and other tools either good or bad image.

The problem is that in the reports it crash if the image is bad (no error message). In the report how do I make an exemption if the image is bad to just return null? This way the report does not crash.

View 3 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

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 :: 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 :: 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 :: 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 :: 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 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 :: Make Ageing Report Based On Date

Mar 20, 2011

I have one view which displays the information of all the receipts with date now i want to make ageing report based on this date. the columns will be 0-30 , 30-60,60-180 and > 180 , i want to distribute the receipts qty based on number of days.

View 1 Replies View Related

Reports & Discoverer :: Reports Based On Data

Apr 30, 2013

I have a doubt that can we make a report on sum of the salary record wise and grouped by dept number?

like as shown BELOW

Dept No Dept Name
10 Accounting
Employee ID Name Salary Sum Salary
7782 CLARK 2450 2450
7934 MILLER 1300 3750
7839 KING 5000 8750
Dept No Dept Name
20 Research
Employee ID Name Salary Sum Salary
7369 SMITH 800 800
7788 SCOTT 3000 3800
7902 FORD 3000 6800
Dept No Dept Name
30 Sales
Employee ID Name Salary Sum Salary
7844 TUNER 1500 1500
7499 ALLEN 1600 3100
7521 WARD 1250 4350
7900 JAMES 950 5300

emp table
Name Null? Type
----------------------------------------- -------- ------------------
EMPNO NOT NULL NUMBER(4)
ENAME VARCHAR2(10)
JOB VARCHAR2(9)
MGR NUMBER(4)
HIREDATE DATE
SAL NUMBER(7,2)
COMM NUMBER(7,2)
DEPTNO NUMBER(2)

dept table

Name Null? Type
----------------------------------------- -------- --------------------------
DEPTNO NOT NULL NUMBER
DNAME VARCHAR2(15)
LOC VARCHAR2(15)

View 4 Replies View Related

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 :: Data Inserted Twice In Report?

May 10, 2010

I have a report for this report i want to insert a data into one table. when am inserting the data then two time its inserted. if i run the report its inserted the data and i have taken the pdf file then also inserted 2 time for this.

Note: This report having only one group. not necessary below method give any other solution if destype=pdf then no need to insert otherwise insert the data.

View 9 Replies View Related

Reports & Discoverer :: Report Generating Wrong Data In Windows 7

May 7, 2012

I am actually having problems with a report that is generating wrong data in Windows 7 only. I have the same report working correctly on many Windows XP Computers.

View 9 Replies View Related

Reports & Discoverer :: Matrix Report Cell If No Data Then Display (A)

Apr 7, 2011

Report 6i. I created Matrix Report . it is working fine.

I would like to know that it is possible If Matrix Report Cell do not have data then display any words like 'A'\

View 1 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 :: 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 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 :: 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 :: Can Create Drill Down Report With Parameter Form Of Report

Nov 29, 2011

I am trying to open report in parameter form in drill down report.

View 7 Replies View Related

Reports & Discoverer :: Can Create Drill Down Report With Parameter Form For Report

Dec 19, 2011

I had report A which drill down to report B. While drilling down to report B, The parameter form of report B should be displayed which accept parameter code and then open the report B. My parameter form is displayed but not accepting the input. i am using the hyperlink to display the second report. Is there any cgimap.bat file to be configured for the parameter report? If yes then how to configure this file?

View 1 Replies View Related







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