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


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 :: TAB Delimiter Report Is Not Functioning

Sep 16, 2006

I am developing a TAB delimited oracle reports(6i).In which I am doing the following

1. One query for both text and excel reports
2. two layouts, one for standard another for excel(I have parameter to select whihc format user want to see)
3. In excel layout I putting one fielde for each row. And assigning each row with a formul;a column
4. In formula column I am sending data for that row with tab delimited as below
return(:Name || chr(9) || :Age || chr(9) || :depat) ;
5. I have registered in Apps
6. When I run the report in apps the output comes with tab space for each column
7. But I save the same file and try to open in excel with delimiter as 'TAB' its not spreading across cell. It is just coming in a single cell

View 4 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 :: 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 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 :: 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 :: 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 :: 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 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 :: 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 :: Pass Parameters In Table Section?

May 31, 2012

I have a problem here.Normally, we use &p_where inside a sql script in condition sectione.g :
select name from member where name like 'a%' &p_where order by name;

may i use this kind of parameter in table section?e.g :
select name from &p_table where name like 'a%' and status = 'a' order by name;

the reason i need to do is there are 2 different server. but i need retrieve same info.server ABC have table A but don't have table B and server DEF have table B but don't have table A.

Is there any other method to solve this problem?

View 4 Replies View Related

Reports & Discoverer :: Pass Parameter From Forms To Report

Oct 5, 2013

I can not Pass parameter from forms to Report.

I use three parameter for report. I want to show the employee who has been hired between from_date to_date,it work well in report builder. but I want to pass parameter from forms to report and pdf format. I upload my work (this is actually a zip File, change file type txt to zip just before open).

View 5 Replies View Related

Reports & Discoverer :: Link Two Forms And Pass Employee Name To Next Form

Jul 31, 2010

if i have two reports one of them is that you enter the office name and it will show you list of employee. the second one i want to show the information that is related to that employee by putting beside each employee button that if pressed i will go to other report that show me information about that employee.How i could link the two form and pass the employee name to the next form

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

Forms :: Oracle Builder Object Navigator Reports

Nov 16, 2011

I am using Oracle Forms Builder 6i. When you open it, in the navigator tree:

- Forms - MODULE - Reports

I want to know what is the purpose of REPORT section in the Forms Builder.

View 6 Replies View Related

Client Tools :: Similar To Oracle Reports Builder 6i?

Jul 14, 2011

Any good tool similar to Oracle reports builder 6i ?Which should be OPENSOURCE.

View 7 Replies View Related

Reports & Discoverer :: How To Run Discoverer Reports In A Forms Menu

Jul 5, 2010

how to Run a Discoverer Reports in a Forms Menu.

View 2 Replies View Related

Reports & Discoverer :: Launching Discoverer Viewer From Forms Menu

Dec 6, 2011

Is it possible to link to Discoverer Viewer from Forms without requiring the user to log in again. If so, can I then link to a specific Workbook within Discoverer?

View 2 Replies View Related

Reports & Discoverer :: Oracle Apps Data Does Not Show In Discoverer

Mar 19, 2012

When running my query in sql developer, I have to execute the command apps.fnd_global.apps_initialize(user_id, resp_id, resp_appl_id) in order to show the result of my query. Without this, the query returns nothing. The problem is I am using this query as a custom query for my Discoverer report and my report does not show any record.

View 3 Replies View Related

Reports & Discoverer :: Discoverer Admin - How To Copy Folder From One Instance To Another

Nov 9, 2011

I need to copy my discoverer report from dev to prod. How should I do this? Are the items created using calculation in the report can also be copied? These items are not present in the folder in discoverer admin.

View 1 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 :: Provide Download Link To Blob In Database On Oracle Reports?

Aug 8, 2013

My user would like to have a way to attach files to database records. For simplicity, we'll say that each employee in the database could have 0-many file attachments associated with them. I know how to make this part work using Oracle Forms.

So that's the easy part for me. The tough part is that they want to be able to run an Oracle Report on our application server (displays as a PDF, also downloadable as a PDF) and have links on this report to the attachments that they uploaded using the forms process above.

For the idea of storing the files on a folder somewhere, I simply created a text object on the report that had it's hyperlink property pointing to the file location. Done.. opens fine.

However, I want to be able to have the option of storing these files in the database instead, just in case we can't go with the shared folder idea. I'm not sure how to make this work. I can store a blob in the database.. but how do I link to that blob on the report for them to be able to download it? Is this even possible?

how to create a download link on the Oracle Report that let's them download a file out of the database.

View 5 Replies View Related

Reports & Discoverer :: Text Bold - Format Particular Word In Oracle Reports At Runtime?

Nov 2, 2010

I have a doubt; can we format a particular word in oracle reports at runtime..?

Ex:-

A text filed contains data Quote:We request #BANK# to finance the same Bill as per agreed interest rate and other terms and conditions agreed on the above addendum and immediately remit the proceeds to our account A/c no. #ACCOUNTNO#, held with your Bank.

We need to make #BANK#, #ACCOUNTNO# are bold at runtime, Is there any method to format characters at runtime..?

View 10 Replies View Related







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