Re: [dabo-users] report writer ?'s

Author: johnf

Posted: 2008-11-30 at 17:03:22

On Sunday 30 November 2008 01:16:36 pm Paul McNett wrote:

> johnf wrote:

> > I have a few questions concerning the ReportDesigner and the related

> > output. I have 17 text fields that need to be part of a report (don't a=

sk

> > why 17 not my idea). When I add the text fields how does the report

> > writer determine how to expand to meet the size requirements? Is there=

a

> > setting like in VFP?

>

> First, I believe by "text field" you mean a "string object". You can have

> as many string objects in your report as you need. You size them by setti=

ng

> properties, such as Width, Height, and FontSize. Combining this with the

> Align property ("left", "center", or "right") you should get close to what

> you need as far as layout goes.

sorry I mean a postgres text data type. I think mysql calls them BLOB or=20

TEXT. A VFP memo.=20

>

> If you need more than one line of output from the String object, such as =

an

> invoice description that can wrap to multiple lines, there's a 'paragraph

> object' that can do that for you, but as of now it isn't available for

> placement by the ReportDesigner. You can see an example of the Paragraph

> object in the invoice sample from the old dabodemo:

>

> http://svn.dabodev.com/dabodemo/trunk/reports/

>

> Note that it needs to be part of something called a FrameSet, which can

> contain multiple columns or paragraphs.

>

> I don't know what VFP setting you are referring to.

I was thinking about stretch and float with overflow, remove if blank, etc..

> > In the part 1 of the screencast it was suggested that the printing of a

> > field could use a boolean to determine if printing was required. Could

> > someone explain how I can determine if a text field contains data and h=

ow

> > to tell the report writer not to print or to print the field. While

> > playing I discovered Record.textField =3D Null still attempted to print.

>

> You set the Show property of the String object to an expression like:

>

> "len(self.Record.last_name.strip()) > 0". This gets evaluated at runtime,

> so in this case if there's data in the last_name field, that data will

> print. Else, it won't. Of course, in this case it doesn't matter to set t=

he

> Show field because a blank is a blank in any case.

True blank is blank. But what about the label for the field. Again I was=

=20

making a ref to text data type field. Most of the time it's value is Null.=

=20

Does 'None' apply?

>

> The best way for me to help though is with specific examples. Post your

> rfxml file to the trac wiki and let me take a look at specific things

> you've tried, instead of trying to interpret what you mean in your prose.

>

> > How can I determine page length? I'm worried about insuring that the

> > fields fit on the page without extending to the next page. For example

> > when creating an invoice I do not want to start a new detail line if the

> > line will start within =C2=BD inch of the page footer.

>

> You'll probably find that the report writer is smart enough in this regar=

d,

> but you can handle this with report groups, mostly like it works in VFP.

> Add a group on an expression like "self.Record.invoice_num". Now you can

> choose things like whether to reprint the group header on the next page,

> etc.

>

> Paul

>

Hope so. Let me play a little more by providing more data. But I still wa=

nt=20

to know what happens with the text data types.

=2D-=20

John Fabiani

©2008 johnf