Reports & Discoverer :: WITH Clause In Report Builder

Jun 12, 2013

I'm trying to have RB use the following query:

WITH MY_DATASET
AS (SELECT /*+ materialize */
DISTINCT
N.NAME_ID NID,
NVL (TO_CHAR (RN.CONFIRMATION_NO), 'ACCOMPAGNATORE') CONF,
RN.RESV_NAME_ID,
MEV.TAX1_NO PARTITA_IVA,
[code]....

But although perfectly working in SQLDeveloper, RB returns an ORA-942 table does not exist error, pointing at MY_DATASET as the offending name.

View 8 Replies


ADVERTISEMENT

Reports & Discoverer :: Use Graphic Builder To Make Chart In Report Builder?

Aug 10, 2010

i want to use Graphic builder for make a chart in report builder. how can i use them for create a chart report? i need to see some samples for create my project. put a sample of .OGD and .rdf

View 6 Replies View Related

Reports & Discoverer :: Using Functions In Report Builder Program Unit

Oct 27, 2010

i am creating a report using a function in the select query..suppose this is my function that i created in the program unit of the report

FUNCTION is_numeric_rep (p_strval in varchar2) RETURN
NUMBER
IS
l_numval NUMBER;
BEGIN
l_numval := TO_NUMBER(p_strval);
RETURN 1;
EXCEPTION
WHEN OTHERS THEN
RETURN 0;
END is_numeric_rep;

and also suppose this is the query of the report

Select
is_numeric_rep('343aa43')
From dual

when pressing ok on the query statment in the report it give me this error: ORA-00904 "is_numeric_rep":invalid identifier although when i create this function as a stored function in the database schema and use it in the report it works fine with no problems.

View 1 Replies View Related

Reports & Discoverer :: Digits Conversion - Report Developed In Builder

Oct 9, 2012

I am facing an issue here at my workplace, there is a report developed in report builder , the user wants to see the digits in arabic.

View 4 Replies View Related

Reports & Discoverer :: Oracle Report Builder 11g Stops When Destype Is File

Jul 9, 2013

In Oracle Report Builder 11g whenever i set destype to file report Builder Stops.

View 15 Replies View Related

Reports & Discoverer :: REP-0002 Unable To Retrieve String From Report Builder

Nov 25, 2010

My own created software is running since last 4 years but now when I am trying to run a report then I got a message "REP-0002 unable to retrieve a string from the report builder" and as a result my report don't run. Please note that some other reports are working properly, this problem is happens only with some of them reports.

View 3 Replies View Related

Reports & Discoverer :: OC4J Instance Tracking And Report Builder Running?

May 1, 2012

How to check in which port : OC4j instance is running ??

How to run the report using : OC4j instance and deploy into application server?

View 3 Replies View Related

Reports & Discoverer :: Developed Tabular Report In Builder 6i - Rep-1213 Error?

Dec 23, 2011

I have developed a tabular report in report builder 6i. Total columns in report 28 in all. Now its throwing following error.

REP-1213: Field 'F_orpahn_Code'references column 'orphan_code'at a frequence below its group

View 1 Replies View Related

Reports & Discoverer :: Convert Number From Arabic To English In Oracle Report Builder

Aug 5, 2011

how can convert number from Arabic to English in oracle report builder

View 2 Replies View Related

Reports & Discoverer :: Warning / Opening Report Saved With Newer Version Of Builder

Jan 17, 2012

In our office one of our pc was worn out and d2k source files in the server were not able to open in another system for that we need to install the below D2k6i Version of Report;

Report Builder 6.0.8.24.0

if we try to open the file it shows the below error

"Warning: Opening a report saved with a newer version of Report Builder. Functionality may be lost. Continue? "

Currently we are using "Report Builder 6.0.8.11.3" is it possible to download the 6.0.8.24 version?

View 3 Replies View Related

Reports & Discoverer :: How To Run Version 10g Report In Builder 6i Version

Jun 3, 2010

I have a report of version 10g . I want to run this report in oracle reports 6i version.

View 1 Replies View Related

Reports & Discoverer :: Could Not Connect Reports Builder To Database

Jun 29, 2012

I could not connect the reports builder to the database. Im trying to connect it to the XE database. I checked the tns names and the hosts. Everything seems to be fine. But still when i try to connect the report it throws an error "ORA 12541- tns no listner"..

View 11 Replies View Related

Reports & Discoverer :: Any Way To Pass Delimiter In Builder

Dec 15, 2010

I need to produce Excel spreadsheet from report builder.currently I am getting a format like,

ProductID;Count;CountUnique;
1001;12;16;
1002;11;6;
1004;16;666;
1006;60;86;

This format when opened in Excel does not group in separate columns resulting in all getting mixed up.I am looking a format like,

ProductID,Count,CountUnique,
1001,12,16,
1002,11,6,
1004,16,666,
1006,60,86,

This opens up clearly on excel. items like Product,Count are shown on separate columns along with the value.I am still looking into delimited formatting.

View 2 Replies View Related

Reports & Discoverer :: Builder Crashes While Inserting Graphs?

Aug 8, 2012

My report builder crashes if I try to insert a graph from tool pallete.

View 5 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 :: Builder Get Closed - Formatting Page 1000

Dec 23, 2011

I've created report to generate letters,my query contains records more than 1000 while generating report it shows report progress

"Formatting Page 1000" after that report builder gets closed without any error message,I've tried for 10 records it is working fine,

View 5 Replies View Related

Reports & Discoverer :: Convert Exponential Number Into Pure While Writing On Excel Using Builder

May 16, 2013

How to convert exponential number into pure number while writing on excel using report builder.Excel only takes 15 digit as pure number and remaining number it converts into zero or you can say in exponential form.

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

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

Reports & Discoverer :: Between Clause To Compare Two String Values

Jun 15, 2013

I have a problem with Between clause used in where statement to compare two string variable.

Query is like this,

select item_code, item_deacrption
from itm_master, invoce_det
where im_code = item_code
AND invd_item_number BETWEEN (:startNum) AND (:endNum)

Here invd_item_number is a DB field and is of type varchar2(41), and (:startNum),(:endNum) are of same type.

now invd_item_number has one value '001003002001'
if we give :startNum = '001003001002' and :endNum = '001003004006'

:startNum and :endNum is composed of separate field values (ie, 1st 3 character shows color code, next 3 for catagory, next 3 for size etc). These codes are entered separately and are combined at run time.

it is still fetching the invd_item_number with value '001003002001'. (the last set of character(type code) in the :startNum is greater than invd_item_number's type code value. But it is smaller than the previous code (size code), that's why it is fetching).

But how can i get around this as i don't need that value to be fetched.

View 7 Replies View Related

Reports & Discoverer :: During Open Report The Discoverer Application Frozen?

Jun 23, 2010

When I try to manage the report the Discoverer application frozen.

View 5 Replies View Related

Reports & Discoverer :: Anyway To Stop Report In Before-Report Trigger

Jul 24, 2011

Is there any way of stopping the report from executing in Before-Report Trigger.

Actually what i am doing is to see whether some records are present there in the table in Before-Report Trigger on which the report is going to print. Because I am doing some updates in After-Report trigger. I want to stop if there is no records present in the table in Before-Report Trigger so the report will not go forward to After-Trigger of the report.

how to stop and by using which statement.the other way so that if report has no data then After-Report Trigger should not fired.

View 2 Replies View Related

Reports & Discoverer :: How To Create Aging Report In Discoverer

May 28, 2010

[Message #1] how to get a unapplied receipts for ageing report? and RMA(credit and debit note)columns ?

Which tables should be refered for Ageing reports.

[Message #2] How to create an ageing report in discoverer?

Which tables should be refered for a Ageing reports.

Ageing report colums customer name, customer id,location,segment, credit note and debit note in different column,unapplied amount and applied amount in a different colum.Already i got a due remaning date and total amount I want a linked table names.

View 1 Replies View Related

Reports & Discoverer :: How To Merge Multiple Reports In One Report In 6i

Aug 23, 2011

How to merge multiple reports in one report in reports 6i.

View 1 Replies View Related

Reports & Discoverer :: Calling Report From Another Report

Aug 31, 2010

I created two reports separately.

1.pub.jsp
2.serc.jsp

what i need is i want to call the report serc.jsp from pub.jsp .

View 6 Replies View Related

Reports & Discoverer :: How To Call A Report From A Report

Aug 17, 2012

How to Call a Report from a Report?

Not from a form but a Report from a Report?

View 3 Replies View Related

Reports & Discoverer :: Report Printing In 11g

Sep 25, 2012

I am facing problem while printing from the Oracle Report.. Web.show_document does not print the output of RDF file directly on the printer.

View 1 Replies View Related

Reports & Discoverer :: Unable To Run The Report In 10g

Dec 6, 2012

The code works great for few reports and for few reports it gives an error saying Unable to run the reports in 10g, When i checked the job status it says Terminated with error: <br>REP-163: Invalid value for keyword DESTYPE. Valid options are FILE, PRINTER, MAIL, INTEROFFICE, or CACHE.

I have kept the DESTYPE as CACHE. It is failing at Run_Report_Object(ReportId, Pl_Id)

View 3 Replies View Related

Reports & Discoverer :: How To Run Report In Menu

Oct 19, 2011

How can I run my report in my main menu or fort page for example I want to run my report when user click a button. What will process?

View 5 Replies View Related







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