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