Reports & Discoverer :: Hide One Frame And Display Other Depending On Parameter Value
Aug 22, 2010I want to hide one frame and display the other depending on the parameter value . How could i make that ?
View 1 Replies
ADVERTISEMENT
Reports & Discoverer :: Skip The Repeating Frame?
Feb 23, 2011I have a Requirement in the Report.
During the Report Runtime the Each Page Contain 55 Lines. Their as Lot of Item Groups are available in the Report Each Items Group have Maximum 10 Lines in the Report with Summary Contain in the Repeating Frame
My Requirement is During the Report Preview if the Report Not Fitted in the Page then Whole Item Group is Require to Skip to Next Page.
Reports & Discoverer :: Many Graphs In Repeating Frame?
Jun 8, 2012I have a graph inside a repeating frame, but every time a run the report, it doesn't bring me all de graph, generally skip the last one, for example i show one graph per location but never show me the last ones. What can i do? If I ask 4 location, it bring me 3, if I ask 5 it bring me 4.
View 4 Replies View RelatedReports & Discoverer :: Report Frame Overwriting
Dec 19, 2011child frame is overwriting the parent frame on next page of report. what might be the problem
View 7 Replies View RelatedReports & Discoverer :: Hide Items In Reports
Jun 8, 2013I have report consists of five fields, the user can be fill three fields only or fill four fields. How can remove blank spaces between fields if users select a less then 5 fields.
View 2 Replies View RelatedReports & Discoverer :: Graph - Repeating Frame (Change Dynamically Y And X Axis Title)
May 23, 2012I'm presently creating a Graph on a repeating frame.
I made a query with a group that pointing to the repeating frame.
The problem : I want to change dynamically the Y and X axis Title.
The graph accept user parameter inside the XML file. But how to make it dynamically based on SQL query?
I try with formula, but can't make it work with a group. I have to put the formula at Report Level, but to make it dynamically for each group i have to make it work at the group Level.
Reports & Discoverer :: To Hide The Username And Password
Dec 20, 2010I migrated the report from Developer 2000. This report has the drill down report with the following command.
procedure U_1ButtonAction is
begin
srw.run_report('rep022.rep paramform=no
p11="'||:cr_call_ref_no||'"');
end;
After Migration into Oracle Application Server 10g release 2 , I changed the code as following:
function U_1FormatTrigger return boolean is
begin
SRW.SET_HYPERLINK(' http://cpstest.exch1.mas.unb.com:7778/reports/rwservlet?report=E:CallSystem
ep022.rdf&USERID=dss/dss@dsdb&destype=cache& ;desformat=pdf&p11="'||:cr_call_ref_no||'"');
return (TRUE);
end;
-----------
Problem
When I run the report, it shows the toolbar on the link [with the user id & password] of the drilldown report.
I wish to hide the username & password or I wish to enter my message "Click the link to open the Report".
Reports & Discoverer :: How To Hide Username And Password In Web Show Document
Jul 1, 2013I want to hide the URL or Username and password in web.show_document. While accessing report through form any end user can see the url. I need to hide the credentials.
View 6 Replies View RelatedReports & Discoverer :: How To Use System Parameter As Currency
Jun 8, 2010How the use the system parameter as currency, decimal and thousand.
View 2 Replies View RelatedReports & Discoverer :: 10g Parameter Form Error?
Sep 26, 2012While calling a report I am getting the following error.
REP-546: Warning: The value of restricted LOV parameter TOPROFIT is not among the selectable values.
When I call the same report through another PC it displays parameter form.
I am using Report Builder 10g.
Reports & Discoverer :: How To Accept Parameter Between Two Report
Jul 20, 2012I am running rep_1, and before executing second rep_2 the user should enter department number, after accepting department no, the second rep_2 should be executed. But after accepting parameter the second rep_2 is not displaying any record.
View 1 Replies View RelatedReports & Discoverer :: Parameter Passing Through Report
Feb 2, 2012I had created drill down reports. rep_1 dispalying various Location_cd. by clicking location_cd The parameter form of rep_2 is displayed in which location_cd is displayed which is already selected and accept dept_cd from user. While running the rep_2 the parameter location_cd is passing null value.
View 1 Replies View RelatedReports & Discoverer :: Destype Parameter Attributes
Oct 21, 2011Attributes required on the destype parameter list. This attributes are like PRINTER
EXAMPLE:
ADD_PARAMETER(listap,'DESTYPE',text_parameter,'PRINTER');
Reports & Discoverer :: 10g - Parameter Form - Desname
Sep 3, 2010In the parameter form in my report I want to give user the facility of browsing the location where he/she wants to store the report. how can I accomodate the same?
View 1 Replies View RelatedReports & Discoverer :: How To Display Matrix Report
Dec 22, 2010I am using oracle Dev 10g R2 in windows Xp. I have a matrix report and it will produce result correctly as the attachment1. Now I want to display this report as a same format. I would like to display 0 for those that does not exist in the query.
View 2 Replies View RelatedReports & Discoverer :: Pass Parameter From Forms To Report
Oct 5, 2013I 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).
Reports & Discoverer :: How To Create Report Using Lexical Parameter
Feb 17, 2011I know lexical parameter concept..but i want a demo report which will use lexical parameter...
View 1 Replies View RelatedReports & Discoverer :: Script To Find Report Parameter
Dec 9, 2011I just have a requirement.Is there any way to write any script which can find the report parameters which are used for its execution so that manual checking for many reports is avoidable as there are about hundreds of reports in our environment.
View 2 Replies View RelatedReports & Discoverer :: Parameter Wise Report Content
Jan 10, 2012I developed a report for bar code and it is running well.the contents in one bar code are Item name,code,price.I designed 4 pieces in a page and generate also 4 pieces in a page.
But Now I want to generate the report with a parameter where I can mention how many copies of bar code will generate in a page for this specific item.
If I put 3 pieces in parameter then bar code will generate 3 pieces. or so and so.
Reports & Discoverer :: Discover Parameter Default SYSDATE?
Oct 26, 2012I've hunted everywhere, and I'm beginning to think this is impossible, however I'll give it a shot...
I would like my Discoverer report start date/end date to default to YESTERDAY.
Reports & Discoverer :: Bind Parameter Defined In Report
Oct 4, 2010I Created a Bind parmeter in report .....but when i run report it show only loc bind parameter not fyyear bind parameter...
Code is :
SELECT distinct BPT_LOC Location, BPT_DOC_DT BNP_REF_DT, BPT_DOC_NO BNP_REF_NO,
BPT_VEN_NM Vendor_Name,
BPT_BIL_NO Bill_No, BPT_BIL_DT Bill_Date ,
E.BMDT_CNTRCT_CD CONTRACT_NO,
BPT_NET_VOU Total_Amount, BPT_SAL_RT VAT_AMOUNT,
[Code]...
Reports & Discoverer :: How To Display Data Using User Variable
May 27, 2010following is my query model
SELECT INV.VENDOR_ID,inv.invoice_date,inv.po_header_id,
INV.INVOICE_ID,
INV.INVOICE_NUM,
[Code]....
WHAT i have to write in select field
Reports & Discoverer :: How To Get Profile Values To Display In RDF Report
Jul 3, 2012how I can profile values to be displayed in RDF report.Here is what I have in my before report trigger
srw.USER_EXIT ('FND SRWINIT');
apps.fnd_client_info.set_org_context(FND_GLOBAL.ORG_ID);
:CP_Fnd_User :=FND_GLOBAL.USER_NAME;
:CP_CompanyName := FND_PROFILE.VALUE('xx');
When I print the value of the user name it gets printed fine.But when I print the place holder column value for the profile I get null.
Reports & Discoverer :: Select List Of Values From Parameter Form?
Jun 9, 2012I am trying to select multiple values from a parameter form based on a select statement.
I created the parameter and write the select statement under list-of-value property However what I want is to let users choose multiple values from the select statement not only one value.
Reports & Discoverer :: Using Parameter For Maximum Rows To Fetch To Be A Number
Dec 15, 2010In Report it is possible to set the maximum rows to fetch to be a number e.g. 1+.Is it possible to use a number that is selected from another query? When I try to do this i.e. I put in the field num_lines or :num_lines I just get invalid number
View 10 Replies View RelatedReports & Discoverer :: How To Create Parameter Form In Descriptive Format
Jan 28, 2013I have developed report in reports9i and executing this report at application server but the parameter form is not displaying as its displayed in report builder.
parameter form isn't in descriptive format like you can check the department field. how to create parameter form in descriptive format or I am doing any mistake?
Reports & Discoverer :: Changing Lov Font Face To Parameter Form
Apr 11, 2012I need to change the font face from following lov value for parameter form, How?
SELECT DISTINCT CODE_ENTRY.VILLAGE_NAME, CODE_ENTRY.UNIONN_NAME
FROM CODE_ENTRY
Reports & Discoverer :: Display Text Item In Second Page Of Report
Jul 12, 2010I have a Report With Group G_Emp, having Columns Eno, Ename etc. in a Repeating frame R_1 and I have put A frame below this repeating frame R_1 with a Text Item Just for Displaying Comments, so just i want to display this Text Item in the second page and the Employee details in the first page, the restriction is that the Text item should not print in the first page.
View 2 Replies View RelatedReports & Discoverer :: Display Data Vertically (landscape Format)?
Apr 19, 2013I need the data in this below format.
I added the image...
Reports & Discoverer :: Change Number Of Column Display According To The Condition
Apr 18, 2012Recently I am facing a problem while working with Oracle reports 2.5.
My requirement is:
there is a report in which there are 5 columns right now. Now what i want is, whenever a condition will satisfy , a new column should be also display in that report otherwise it must be stay as it is.
Previously : a b c d
Now if a=1 : a b z c d
else
a b c d
where a,b,c,d,z are columns.