Search results for query: *

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...

Mark the check box 'Restrict List to Predetermined Values' Timo

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

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...

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

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

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...

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

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...

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

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

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

- 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

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...