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
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.
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.
How to get page wise total on every page and grand total on last page in oracle tabular report. I have tried by placing summary column at report level and its reset property to page wise and print job on all page but last but it did not work .
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?
We are using APPS 11i, Yesterday some Report are end with Error. Error Details Given Below.
X Error of failed request: BadWindow (invalid Window parameter) Major opcode of failed request: 15 (X_QueryTree) Resource id in failed request: 0x2600001 Serial number of failed request: 614 Current serial number in output stream: 614
I m trying to run reports from my application developed using Oracle FORMS6i but the report engine does not show any job. Platform Information: Microsoft Windows Server 2012 Version 6.2 (64 bit).
I do not want users to leave a parameter value null . so I applied after parameter form trigger
function AfterPForm return boolean is begin IF ( :my_no IS NULL ) THEN srw.message(101, 'Please enter proper No.'); return (FALSE); END IF; return (TRUE); end;
it is working fine, it displays proper message but after my message, a default message is displayed
REP-0771: After Form Trigger Failed.
I want to avoid this message. if i comment out return(false) then it displays message and runs the report. I want to avoid default oracle message and stop running report also.
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"..
.I created the following procedure to implement Event Driven Reporting:
CREATE OR REPLACE procedure ABC.eve_drv_rep as myPlist system.SRW_PARAMLIST; myIdent system.SRW.Job_Ident; BEGIN myPlist := system.SRW_PARAMLIST(system.SRW_PARAMETER('','')); system.srw.add_parameter(myPlist,'GATEWAY','apsIP/reports/rwservlet');
[code]...
Procedure is created successfully but when I execute this procedure, I get the following error:
ORA-20001'Error sending email.Error: ORA-20999 ORA-06512: at "Nml.Eve_Drv_Rep", line 17 ORA-06512: at line 1
2ndly I want to know that whether I should give IP address or Application Server Machine Name in GATEWAY parameter? And in SERVER parameter either I should give the Application Server Machine Name or Report Server name installed on Application Server Machine?Lastly from where I can get the complete list of Parameters to be added in SRW.Add_Parameter like SERVER, GATEWAY etc.
note that we r using Database 10g Rel.2 and Forms and Reports services on Application Server and the report being called was developed in Reports 10g.
I have a report where the Shipments list will appear.The shipment_id appears as hyperlink and when it is pressed it should be redirected to another report which displays the cost details on the respective shipments
But we get an error message as in the attachment when i press the hyperlink. what would be the issue and where should i check for the error to resolve? Also the query used to extract data is
I prepared a report in Oracle reports and trying to run the report through command line by creating a batch file. but i am getting the following error message when i run the batch file
REP-0069: Internal error REP-57054: In-process job terminated:Executed successfully but there were some errors when distribute the output REP-50159: Executed successfully but there were some errors when distribute the output
when I am trying to send report for prints then I received this error.
" REP-57054: In-Process Job terminated: The report generated successfully but distribution to destination failed. REP-50159:The report generated Successfully but distribution to destination failed. REP-50151: Destination ID Currency failed with error An error occured while sending the file to the printer :HPofficejetpro7700Series- Cannot run program "COrcaleMiddlewareasinst_5Config eportsin wlpr":
create process error=2, The system cannot fine the file specified."
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.
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.