Re: Reports 2.5 Questions.....
From: Paul Dorsey <pdorsey.dulcian_at_worldnet.att.net>
Date: 20 Nov 1998 01:57:53 GMT
Message-ID: <732ib1$793_at_bgtnsc02.worldnet.att.net>
Date: 20 Nov 1998 01:57:53 GMT
Message-ID: <732ib1$793_at_bgtnsc02.worldnet.att.net>
answers below
-- Paul Dorsey Dulcian, Inc. www.dulcian.com 212 595 7223 Noah Wollowick wrote in message ...Received on Fri Nov 20 1998 - 02:57:53 CET
>
>Hi.
>
>I have a couple of questions i was hoping that someone could help me with!
>
>1) Using format masks, i was hoping to use the 'V' symbol to divide by
>100, i.e. to display 834.4 for a value of 834,400. So far, it seems that
>the 'V' symbol can only be used to multiply by 1000, not divide;
>
>Any suggestions or advice? If we can't do it using the 'V' symbol, then we
>will embed a divide by 1000 within the SQL, but we don't want to do this
>if possible.
>
Either use a round function in the SQL or in a formula column in the report. I don't know how it can be done with a format mask.
>2) On PAGE BREAKS: We are trying to develop a retail-industry report in
>which we report numerical values for a merchandise-hierarchy driven
>information (i.e. Dept/Class/Subclass)... WE are trying to Page Break
>based on department by following the Oracle Reports help instructions, and
>are having some difficulty. Does anyone have insight on this?
>
On the dept repeating frame set maximum records displayed to 1 Happy reporting. paul
>Thanks for any help,
>Noah Wollowick
>IT Consultant
>noahclerk_at_aol.com
>
>