I 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.
I am using oracle developer 10g R2.also using Crystal Report 9. Now i want to call the report created by crystal report.
View 8 Replies View RelatedIn Sales Order Form there is a print receipt button. In current situation On Clicking the 'Print Receipt Button' it submits a XML Publisher report(PDF output) to the concurrent manager. Currently to print that report i need to go view--> requests--> view output and then print. According to my new Requirement i need to print that report directly to local printer on one simple Print receipt button click in form.
I am trying to call the printers on server using custom.pll. The report is running successfully but it is not printing output to the local printer. I need to print the report to the local printers based on responsibility. Local printers are available on apps server.
Is it possible to print the document using custom.pll? Is there any other alternative to print the report on simple button click in form.
I searched many forums but i found customizations on form level. I am trying to customize the form using custom.pll. I found many examples like URL..... but i don't think i can use these practices in custom.pll. ADD_PARAMETER & RUN_PRODUCT dont work in custom.pll. I need to complete this requirement immediately.
Environment: Apps 11.5.10.2, Forms 6i
Here is the code that i am using in my custom.pll.
if (v_form_name = 'OEXOETEL' --and v_block_name = 'LINES_SUMMARY'
and name_in('parameter.ACTIONS') = 'PAYMENT_RECEIPT' )THEN
l_organization_id := Name_In('PARAMETER.OE_ORGANIZATION_ID');
l_order_header_id := Name_In('ORDER.header_id');
select to_number(oe_sys_parameters.value ('SET_OF_BOOKS_ID')) into l_sob_id from dual;
xml_layout := FND_REQUEST.ADD_LAYOUT('XXAFP','XXAFPOEXPMTRCRTF','en','US','PDF');
[code]....
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 RelatedI 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
I have a report that contains a name that I want to pass in to a field in a form on a different region on the same page. My button located on the report is has its own column called ADD_LINK. Here is the button.
<button id="apexir_btn_ADD" class="apexir-button" type="button" value="Add" onclick=""><span>Add</span></button>
Once that button is clicked, I have the form region fade in. The region is called Add Tag to Employee, which has P4_ROWID, P4_EMPLOYEE_ID, and P4_TAG_ID. Once the region is displayed, I want the #NAME# to show in the P4_EMPLOYEE_ID.
I did copy this form from another page, where I had it working before. It made more sense to move it to this page for interface purposes, so maybe that tidbit will work as well.
I would like to ask a very small question. what is the code that should be written to open a picture inside the button.
I have already made the button, and the trigger is when push button, what I want is when I click the button it opens a picture in this directory:
F:AmjadAmjadamjad1.jpg
the name of the picture is taken from table1 the colum serial_number
i create form in which first block is non database having 2 items from_date and to_date and one button is there.when i click on button i.e when button pressed new window is open having new database block
i write code on when button pressed
HIDE_WINDOW('XX_RFQ_FIND');
SET_WINDOW_PROPERTY('XX_RFQ_FIND', visible, property_false);
SHOW_WINDOW('XX_RFQ_ACKT');
GO_ITEM('LE_NAME');
SEARCH_REQ;
[code]...
my problem is that when i click on button i fetch only one record
I want a code for a button to click and calendar show. Select the date and year for enter in text field.
View 4 Replies View Relatedi have field in DB that taken ( 1 or 2 or 3 ) am added it as text item at first and then change it to ( radio group ) contain 3 radio as :
value for first 1 = 1 , = 2 , = 3 and mapping = 1
initial value for the group = 1
but when am working with the form and commit form there is no data add in this field when am change the radio value by click on any other on ( 2 or 3 ) it's saved no problem in it ..
why this thing happen coz i need to set the first radio as default for the form .
I am working on form builder 6i.I have FIND widnows and MAIN window.
FIND Window: contains field1 and field2, FIND Button.
block A: Multi record data block on table t1. It contains field1,field2,field3.
block B: non datablock, it contains field4, field5.
If i enter something and click FIND button, it will populate data in Block A.If i put the cursor in any record in block A, and after that put the cursor in Block B, it will populate block B related to Block A record.For this, In Block A--> post record(block level) trigger, i am capturing values in variables.
:GLOBAL.f1:=:BlockA.field1
:GLOBAL.f2:=:BlockB.field2
In Block B--> When-New-Block-instance(Block Level)
select field3, field 4 from t2 where t1=:global.f1 and t2=:global.f2;
and populating data in block B.It's working fine.
REQUIREMENT: If i click the FIND second time, in Block B--> it's retaining previous value. I want to clear the block B once i click the FIND button. I tried to write in POST-BLOCK (Block B-->block level)
CLEAR_BLOCK('NO_VALIDATE');
But it's not working.In which trigger i have to write code to clear block.
I have created one tab canvased form
On first tab I am taking input (search criteria)
on that input i am trying to display all records one by one as user click on next record button....
for that i used when-tab-page-change trigger for first record display and it display correctly.but for further record what should i need to write on next_record command button so all record i can see one by one.
we 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 got a form with few columns and a check_box. If the user selects n number of check boxes and click the button Save. The corresponding records should be inserted to XX_AP_CUSTOM table.
I have written the following below code in when-button-pressed trigger. With this i am able to insert only one record i.e where the current record indicator is there, even though multiple check-boxes(records) are selected.
declare
begin
IF :XXFBI_INV_QUOTE_ANAL_BLK.CHECK_BOX = 'Yes' THEN
--IF CHECKBOX_CHECKED(:XXFBI_INV_QUOTE_ANAL_BLK.CHECK_BOX) = TRUE Then
--app_insert.insert_record('WHEN-BUTTON-PRESSED');
insert into xxfbi.XXFBI_INV_QUOTE_ANAL(Item,
[code]......
I know that i have to use last_record and first_record and for loop to insert multiple selected records, but dont know how to do it.
I have a list box from which the user can select a client's name, I want them to be able to press a button next to the box which will then open another form and display all the client's details. How do I attach a button to a list box? and how can I call another form to open on a specific record?
View 3 Replies View Relatedi design one master detail block and one command button for saving the data....as i click on save button data get saved and after that if i want to close form then at this time it again asking me for save changes window..
View 8 Replies View RelatedI 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 developed an Point of sales software using developer 6i and database 10g XE.Now I want to use this software online. Can I do it ? If it is, then how?
View 1 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 RelatedWe are converting Oracle 6i reports to 10g. I have a report with a button on it that when clicked, it runs PL/SQL code in a program unit defined within the report. The only documentation I have run across says to replace buttons with a hyperlink but this seems to refer to when a report calls another report. This is not the case for this situation.
The button on the report came into 10g as a Text Item. I tried applying the following documentation to the hyperlink property:
"Example 5: Static hyperlink The following example shows a value for the Hyperlink property that specifies a link to a destination identified as LINK1: #LINK1"
The program unit is named: U_UPDATEBUTTONBUTTONACTION and I referenced it as #U_UPDATEBUTTONBUTTONACTION in the hyperlink property.
The open browser window is not what I need.
How 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 RelatedIn 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 RelatedI migrated a Oracle 6i Report to Oracle Report 9i so I'm trying to execute a this report in the Run Web Layout, but this doesn't bring me any information, how can i run this reports in the Web layout?
When i run this report en the Paper Layout it's bring me data. When a run the report just bring me a blank web page.
i have a table say 'temp' with 4 columns as seq, name, event, id and i have a pg with 3 text fields as name, event, id now ma issue is,if i enter values into those 3 text fields in that page and on a button click (say create), i wanted dose values to get inserted into 'temp' table andregarding , 'seq' column i hav created a sequence for it. so
1. how to insert values into the table by entering values in the page
2. wat shd b done for seq column.. (shd anyth b done from apex pages or wil it automatically get values for each row entered)
I am using APEX 4.1 to build the application. I have 2 select list region in the page where one region consist of certain values.On calling a javascript function it is able to move the value from one select region to another. After this I click on the modify button where in the value move out of the first select list region to the second will be updated in the table.
Although I could see the values are not being updates. On putting alerts after the value being fetched in the javascript function and clicking the Modify button I can see that no data is being reflected in the alert. Hence the data is not being passed from the second select list APEX item to the javascript function.
I have a requirement wherein onclick of button I want to open/close list/popup (which is displayed below button, just like in select list) and can select any item from list to do some action.
View 7 Replies View Relatedi need to call report from button in form but when i call the report which have parameter in it ,it run direct without show me the parameter field to be entered now i need to do the following run report normally as when i press in the button the parameter filed appear.
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 ?