I'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.
I have a report with matrixs group, when I try to add a new group in a new level, I get this message :
REP-1108 : Cannot fit default layout even in region extending to page boundaries.
How can I increase the layout in 10g?
During the Table Creation if it possible to Use the SYSDATE is Default Value for a Column.
View 3 Replies View RelatedHow the use the system parameter as currency, decimal and thousand.
View 2 Replies View RelatedWhile 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.
I 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 RelatedI 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 RelatedAttributes required on the destype parameter list. This attributes are like PRINTER
EXAMPLE:
ADD_PARAMETER(listap,'DESTYPE',text_parameter,'PRINTER');
In 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 RelatedI 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).
I know lexical parameter concept..but i want a demo report which will use lexical parameter...
View 1 Replies View RelatedI 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 RelatedI 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.
I 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]...
I 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.
In 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 RelatedI 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?
I want to hide one frame and display the other depending on the parameter value . How could i make that ?
View 1 Replies View RelatedI 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
Recently we come across DBMS_SCHEDULER issue while passing SYSDATE as default value. Job executed with corect date value on creation time, but further schedule its not incrementing date value.
Snap of the Program
BEGIN
SYS.DBMS_SCHEDULER.CREATE_JOB (
job_name => '"OBIEE_ADM"."First_Job"',
job_type => 'STORED_PROCEDURE',
job_action => '"OBIEE_ADM"."SF_INTERFACE_PKG"."SF_EXTRACT"',
number_of_arguments => 1,
start_date => NULL,
[code]....
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
the batch file is as follows
D:DevSuiteHome_1BINRWRUN p:spannawazeitspanna_wa_zeit.Rep userid=alrayatec/alrayatecprod@alraya.world
DESFORMAT=HTMLCSS DESTYPE='mail' DESNAME='sarfraz_it@hnd.com'
I am trying to open report in parameter form in drill down report.
View 7 Replies View RelatedI had report A which drill down to report B. While drilling down to report B, The parameter form of report B should be displayed which accept parameter code and then open the report B. My parameter form is displayed but not accepting the input. i am using the hyperlink to display the second report. Is there any cgimap.bat file to be configured for the parameter report? If yes then how to configure this file?
View 1 Replies View RelatedI am running a database version 11.2.0.3 on a RHEL 5.3 system.A nightly ETL job drops all tables of a certain schema and recreates them as part of this job.After recreation of the tables statistics are generated to make query execution faster.
The ETL job uses following statement to gather the statistics for each table: EXEC dbms_stats.gather_table_stats('SCHEMA', 'TABLE', cascade => TRUE); As we had performance issues on the database I analysed the statistics and found that there were no histograms collected for the tables although the data are skewed.
Therefore I searched a database wide parameter where I can change the default statistic collection method from 'SIZE AUTO' to 'SIZE SKEWONLY'. I found following method: DBMS_STATS.SET_DATABASE_PREFS () I used this package to set the database prefs to 'size skewonly' and recreated the statistics. All was fine. exec DBMS_STATS.SET_DATABASE_PREFS (pname=>'METHOD_OPT', pvalue=>'FOR ALL COLUMNS SIZE SKEWONLY');But one day later after the ETL job we had the same issue again. After a further analyse I saw that there were no histograms generated on the tables. It seems that the drop and recreation of the tables make the system wiede default parameter useless.
how to set system wide optimizer defaults even after dropping and recreating a table?
how to Run a Discoverer Reports in a Forms Menu.
View 2 Replies View RelatedSO: RHEL6
GI: 11.2.0.3
User owner: grid
The parameter ASM_DISKSTRING is null string however discovers disks.
SQL> select name, path from v$asm_disk;
NAME PATH
------------------------------ --------------------------------------------------
/dev/vg_hdisk_ora/lv_hd10
/dev/vg_hdisk_ora/lv_hd15
/dev/vg_hdisk_ora/lv_hd3
/dev/vg_hdisk_ora/lv_hd6
/dev/vg_hdisk_ora/lv_hd4
[Code] .....
20 rows selected.
SQL> show parameters string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskstring stringAfter setting asm_diskstring to "/dev/asm*", list 40 disks (kernel-assigned device file names & UDEV name)
DISK_NUMBER PATH
----------- ----------------------------------------
0 /dev/asm-disk10
39 /dev/vg_hdisk_ora/lv_hd15
2 /dev/asm-disk3
3 /dev/asm-disk6
4 /dev/asm-disk4
5 /dev/asm-disk7
[Code] ...
40 rows selected.1. Why not list only the names of devices UDEV?
2. Is this normal when creating UDEV rules to ASM?
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 RelatedWhen 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 RelatedI 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 RelatedWhen I try to manage the report the Discoverer application frozen.
View 5 Replies View Related