Forms :: Run Crystal Report From Developer 10g R2?
Apr 15, 2010I am using oracle developer 10g R2.also using Crystal Report 9. Now i want to call the report created by crystal report.
View 8 RepliesI am using oracle developer 10g R2.also using Crystal Report 9. Now i want to call the report created by crystal report.
View 8 RepliesI want to run a report developed by crystal reports by click on a button in oracle developer 6i.
Is it possible. If yes then how can i do this.
In my report I'm using inner join in queries .I got correct record but itz repeated.How to deduct that repeat values?
this is my query:
SELECT f.feeid,
f.studentid,
( s.first_name + last_name )AS studentname,
b.branchname,
c.coursename,
y.yearname,
[Code].....
One of my developer creating views in his own schema,we are able to see that views from sqlplusw. But we are unable view them from crystal report tool(CRW32) ,Except this schema all are visible...
View 3 Replies View Relatedwe have moved our database to a new server which is 64bit. (earlier database was 32bit)
when i try to connect my crystal report or Vs .net to the new server i'm getting below error.
ORA-03113: end-of-file on communication channel
my computer is Win 7 (32bit)
I want to generate a PDF report from Form Developer 6i.
View 5 Replies View RelatedHow can I run an AWR report through SQL Developer? I do not have EM installed on my Oracle 11g database.
View 1 Replies View RelatedI took the course for "Oracle Reports Developer 10g" but I didn't copy the schema when I took the course.
Now,I have the book "Oracle Reports Developer 10g: Build Reports Student Guide" but I look over the internet and I can't find the schema for this course. I needed the schemas for the following tables:
CUSTOMERS
ORDERS
ORDER_ITEMS
WAREHOUSES
INVENTORIES
PRODUCT_INFORMATION
PRODUCT_DESCRIPTIONS
ONLINE_MEDIA
PRINT_MEDIA
where I can find the sql scripts for this schema ?
I am working on oracle 10g with developer 2000 . I have a problem while running reports. when i run a report it goes to a particular path in which my database are not there and hence gives a error 'cannot find server'. everytime i have to physically change the path of the database to run the report.
THE PATH WHERE MY APPLICATION AND THE IP ADDRESS OF WINDOWS SYSTEM IS THIS
[URL]...
WHERE AS THE REPORT TAKES ME TO THIS PATH
[URL]...
I had a look at the reports conf file , but couldnt find the path of the database which the report shows for me to change it. It looks like some where the report path has been hardcoded but i am not able to locate it.
There might be some link missing while installing the application and the database.
I have problems in Oracle returning data from a stored procedure. In MS SQL it's quite simple.
i.e.
CREATE OR REPLACE PACKAGE globalpkg
AS
TYPE RCT1 IS REF CURSOR;
TRANCOUNT INTEGER := 0;
IDENTITY INTEGER;
END;
/
next the stored procedure:
CREATE OR REPLACE PROCEDURE mytest
(
RCT1 OUTGLOBALPKG.RCT1
)
AS
BEGIN
OPEN RCT1 FOR
SELECT *
FROM EMPLOYEE;
END;
Next trying to run the Stored procedure:
VARIABLE resultSet REFCURSOR
EXEC mytest (:resultSet);
Result always returns this error:
REFCURSOR - Unrecognized type.
I have tried using sample on the internet, but all returns the same error, what am I missing
I recently got a new PC at work which is Windows 7 64 bit.
We run lots of crystal reports(1000's) that pull data from an oracle back end.
I have installed the Oracle Client 32 bit on this machine and have no problem connecting to the database and pulling back data.
However, when I use crystal to access the TNS Name it gives me the following error.
[URL]
My path variable on the PC has "C:oracleproduct10.2.0client_1BIN;".
I also tried to create and ODBC using the 32bit ODBC on the machine and that connects fine, but when you try to access the DSN from Crystal, I still get the 12154 error.
I have u na forms developer application in 6.0 that generates a Word document. This application runs successfully on Windows XP operating system. We now have PC's new operating system Windows 7 and officce 2010. My procedure reads a specific route where a template in Word which is used to generate the document. In the user's PC application that does not generate the document even shows me an error message. But when I enter my network user with the user's PC and the document genre generates me perfectly. I checked if the user has access to the server path specifies where the template encuntra wish to open and if you have them.
View 1 Replies View Relatedwe have these oracle developer 2000 forms (in .fmx format) in a server and the data of these forms in another server.... the server with the data is very old and is very slow...so we decided to relocate the database(oracle 9i) to a new server..... also, we move the developer 2000 forms from the old server to another server which will serve as the front end to the new data server. how to make the developer 2000 forms on the new front end server to point to the new database on the new data server. how the forms find the data, where this "connection string" is for developer 2000 forms.
View 1 Replies View RelatedHow to Install Oracle Forms and Reports 11g Send me Link or Document.
View 4 Replies View Relatedi want some information about the oracle developer 11g ( froms & reports) . if oracle developer 11g and oracle is both are similar ?.
View 5 Replies View RelatedI have installed Developer 10 suite and 6i on same machine, developer 6i run time works properly but when i open URL with "?config=icc" it says form generated in previous version of forms builder, i have already compile called form (configure in default.env and formsweb.cfg) in forms builder 10g.
View 1 Replies View RelatedHow can i get URL value from Developer10gR1?
View 1 Replies View RelatedIs it possible to connect a Oracle based application designed in Developer 6i to a remote Oracle database server?
If YES then
How open can do this?
Else
How to web color in developer suite 10g?
View 1 Replies View RelatedI am using oracle developer 10g R2. Now i would like to create a java(jar) function or any other type then would like to add this jar file into my oracle form with a button and when i run this and click on this button then display the message from java function.
View 1 Replies View RelatedI have forms developer installed on a HP-UX machine. I do the following
1. connect to server (telnet)
2. export DISPLAY=my_ip:0.0
3. run f90desm
The 'ps' shows f90desm as running
now this does not show the window for forms developer in short time it takes a large amount of time Hrs before the window shows up.
I want to know can Oracle Forms 6i read data throught a BarCode scanner device.
And is there any website that provides different Oracle Data Link Libraries (DLL files) that can be attached to Forms or Reports to provide different utilities to Forms?
I just upgraded our server to Oracle Fusion Middleware 11g with Forms and Reports and now I want to update the developers workstation too.
They have Oracle Developer Suite 10g R1 for the moment. The last version of Oracle Developer Suite is 10g R2 and I don't see anything for 11g. All I can find is that it's now in Fusion Middleware 11g and JDeveloper... But, from what I can see, JDeveloper is for Java development, not for Forms/Reports development.
So, do I need to use Oracle Developer Suite 10g R2 or is there a new version of it?
I develop a form using Devloper9i AS, oracle 9i, Winxp
I need to use items like "ActiveX Control, OLE Container, Sound " but they are marked as obsolete by Developer9i AS;
so how can I use like this type of items when I establish a form design ".fmb" .
FRM: 10142 The HTTP listener is not running on <computer Name> at port 8889.
How to Solve these Error. When I searching this Problem I found OC4j Instances Startind must. How to start OC4j .
My company has acquired a technology that was written in Oracle Forms 6-8 and am looking to first compile and maintain and then upgrade to either 11g or another platform. The older versions of Oracle Development cannot be downloaded from Oracle's site. Will Oracle provide the link if asked?
View 5 Replies View Relatedi want to download the patch 17 for oracle developer 6i for. any link that i can download this patch from it?
View 5 Replies View Relatedi am running oracle 10g developer release2. i want to set item property false/true in response to a specific action, like disabling text item when check box or radio button pressed.
View 1 Replies View RelatedI am trying to install Oracle 10g Developer suite.i am trying to install oracle forms & reports.have downloaded two zip files
ds_windows_x86_101202_disk1,
ds_windows_x86_101202_disk2.
i am in middle of the installation process. installor is not recognising the second one.
i gave the path to the second file. I tried from the disk by writing the file to the disk. but of no use.how do i complete this installation process.
Unable to find the product files specified by the disk labled 'OracleDEVsuite'. Unable to continue installation , please check the value specified in variable FROM_CD_LABEL matches with the value in file disk.label or check if the disk is accessable.
i havn't find any location or relevent info in ht edisk.label file.
How to call dll file in oracle developer 10g or 6i form
View 1 Replies View Related