PB403: Report DW problem

PB403: Report DW problem

Post by Scott Gren » Thu, 11 Jan 1996 04:00:00




>    I have a simple free-form report and a big headache.  The report
>consists of a job header line for past Work Experience [varchar2(80)]
> (e.g.  'Software Engineer, Telsis Co, March 93 to April 96')

>and one directly following it for Job Accomplishment [varchar2(2000)]
> (e.g.  '   Created an enterpise database system to handle...')

>Both are in the detail band.  My problem is that I need to somehow variably
>adjust the height of the detail band to fit the physical needs of the
>accomplishment data on a row by row basis.  Right now the report column
>for accomplishment data is a fixed size so if the accomp text for a row
>is large it looks great but when it's small there is a huge gap between
>records.  I need to eliminate the gap.  

If you right-click on the detail band while in the datawindow painter,  
select "Autosize Height".  Do the same for the Job Accomplishment column.
The height of the detail band will adjust to the size of the column.

Quote:>I also noticed when I include this datawindow or any datawindow in a
>composite report the backgrounds are all white instead of their normal
>colors.  How do I fix this?

This is also a big complaint of mine.  When you have a composite
datawindow,  PB forces you into print preview.  Their rational is that
composite dw's are only for reports as you can't do updates so they force
the preview mode.  I have found no way around this.

Good Luck,

- Scott

Opinions expressed herein are my own and may not represent those of 3M.

 
 
 

PB403: Report DW problem

Post by Joe McNama » Thu, 11 Jan 1996 04:00:00


    I have a simple free-form report and a big headache.  The report
consists of a job header line for past Work Experience [varchar2(80)]
 (e.g.  'Software Engineer, Telsis Co, March 93 to April 96')

and one directly following it for Job Accomplishment [varchar2(2000)]
 (e.g.  '   Created an enterpise database system to handle...')

Both are in the detail band.  My problem is that I need to somehow variably
adjust the height of the detail band to fit the physical needs of the
accomplishment data on a row by row basis.  Right now the report column
for accomplishment data is a fixed size so if the accomp text for a row
is large it looks great but when it's small there is a huge gap between
records.  I need to eliminate the gap.  

I also noticed when I include this datawindow or any datawindow in a
composite report the backgrounds are all white instead of their normal
colors.  How do I fix this?

Any help would be greatly appreciated.  

  Thanks in advance,

            Joe M.
--

 
 
 

1. PB403: Composite DW probs.

   Pull'in my hair out about Composite DW reports.  I have a composite report
with about a dozen smalled DW reports and I need to access the inner
Datawindows.   For instance I want to check (via SQL in a PB script) if
any records exists in an inner DW report so I can make the report DW
invisible.  Also in another inner DW report I need to translate some data
with is not (and cannot be) normalized.  

   My composite report is dw_watson.

   An inner report is dw_wat_summary with an object name of 'watson_summary'

 I've tried both the following:

   if dw_watson.dw_wat_summary.RowCount() ....

and

   if dw_watson.watson_summary.RowCount() ....

Neither work.  In both cases I get a 'Incompatible field "watson_summary" for
type dw_watson' and 'Incompatible field "dw_wat_summary" for type dw_watson'.

 Help!  I absolutely need to access the inner datawindows from PB script.

   Much Thanks in Advance,

           Joe M.

--

2. MIDI player for S5/3C ?

3. PB403: Composite DW/Child Prob

4. Check state of FTP service ?

5. Nested DW Report problems

6. Win2k mirroring

7. Different Heading for dw report

8. PowerPlant TextEditView Help

9. Report Title for Grid style dw

10. Nested DW's, Nested Reports

11. Extra blank pages printing with report DW

12. DW's overlap in composite report