Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. TISIBS

    In Oracle Reports, how do you suppress report block with no records?

    A good trick is to created a dummy group: - Modify your select statement adding a new column with a constant e.g. 1 AS "dummy" - Make a parent group containing only "dummy" (other columns in child group) - Create a repeating frame covering your existing repeating frame with the source of the...
  2. TISIBS

    List of Values not appearing in parameter form

    Mark the check box 'Restrict List to Predetermined Values' Timo
  3. TISIBS

    Dynamically set alignment ?

    Most of the properties you cannot change dynamically (you can use conditional formatting to see what can be changed). As a workaround, create your label twice: With vertikal and with horizontal alignment. Then hide the one not used in the format trigger dynamically. Timo
  4. TISIBS

    how to supress duplicate values in the feild

    Hi Iloveoracle, change your SQL like this: SELECT ORGANIZATION ,LOCATION ,NAME ,DISPLAY_ORDER ,MIN(display_order) over (PARTITION BY ORGANIZATION) ord1 ,MIN(display_order) over (PARTITION BY ORGANIZATION,LOCATION) ord2 FROM yourtable In the report as suggested...
  5. TISIBS

    how to supress duplicate values in the feild

    Hi, this is a typical "Group Left" report. Use the report wizard. In the second window choose "Group Left". In the window for groups add ORGANIZATION to group level 1 and LOCATION to group level 2. Timo
  6. TISIBS

    REPORT CALCULATIONS

    You can solve this in your select statement. Add the following to the select clause: SELECT SUM(wages) OVER PARTITION BY (week) AS sum_per_week or you can do it with a summary column: Function: Sum Source: wages Reset at: Group of the week Hope it helps Timo
  7. TISIBS

    flex off as preference

    Hello, every time I start oracle reports and open a report, the flex mode is 'on'. But I do not like this mode. It is unusable in complex reports and sometimes it foozled my layout if I forgot to switch it 'off'. Is there any way to save the 'flex mode off'? Perhaps in...
  8. TISIBS

    Splitting Oracle Applications report to Multiple Excel Files

    Try to use a functionality called 'bursting'. So you can create one excel file for each top level group with only one execution. Timo
  9. TISIBS

    how to use "Formula Column" in report ?

    If your formula column already exists you simply have to place a field in your layout. Then press F4 to show property inspector. Change the value of "Source" to the name of your formula column. If your formula column doesn't exist, tell us what you want to do. ... but this is the wrong forum...
  10. TISIBS

    get the value before max( )

    In SQL (scott/tiger); SELECT sal FROM (SELECT sal FROM (SELECT sal FROM emp ORDER BY 1 DESC) WHERE rownum < 3 ORDER BY 1) WHERE rownum < 2 in PL/SQL you can use SELECT INTO ... Timo
  11. TISIBS

    Covert Numeric field into Time?

    'trunc' in my last posting is obsolete ...
  12. TISIBS

    Covert Numeric field into Time?

    You simply forgot '24' Try the following: SELECT to_date(to_char(trunc(SYSDATE), 'MM/DD/RRRR') || '2315','MM/DD/RRRRHH24MI') FROM dual In your case you have to replace SYSDATE with JOB_ACTY_DT and 2315 with JOB_ACTY_TM Timo
  13. TISIBS

    Hide Non repeated Frame

    - In "data model" create a summary column "CS_print" with "Column Type = Summary" and "Function = First" and "Source = SrNo2". Place it outside any query. - Change your Trigger: function M_3FormatTrigger return boolean is begin return (:CS_print IS NOT NULL); end; Timo
  14. TISIBS

    Impromptu 7.1: getting ORA-01457 on Oracle 10g

    Hi, I want to display NUMBER columns from an Oracle 10g database (Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod) in Impromptu (7.1.339.0) but I receive the following: DMS-E-GENERAL, ... 'asynchronous open' ORA-01457: converting column overflows decimal datatype It helps...

Part and Inventory Search

Back
Top