Re: Report label caption expression

Author: Koen Piller

Posted: 2016-08-24 at 23:55:48

You can use a label if you want,

try with

=STR(m.Year) + 'Auto Mileage'

however how did you define the variable m.Year ?

so try it with

=TRANSFORM(YEAR(DATE()))+' Auto Mileage'

or if it is not a variable but a field than you should get year from your

reportcursor and in that case use a textbox

Regards,

Koen

2016-08-25 4:31 GMT+02:00 Fred Taylor <fbtaylor@gmail.com>:

> I've always used a textbox if there is variable data to be displayed.

> Labels are for fixed/constant text.

>

>

> Fred

>

> On Wed, Aug 24, 2016 at 7:22 PM, Joe Yoder <joe@wheypower.com> wrote:

>

> > I thought I had found a way to do it in a label field but maybe I just

> gave

> > up and used a textbox. Is that what you are suggesting?

> >

> > Joe

> >

> > On Wed, Aug 24, 2016 at 9:58 PM, Fred Taylor <fbtaylor@gmail.com> wrote:

> >

> > > Be sure your putting it into a text field not a label.

> > >

> > > Fred

> > >

> > > On Wed, Aug 24, 2016 at 6:14 PM, Joe Yoder <joe@wheypower.com> wrote:

> > >

> > > > I want the header on a report to display the year from a variable

> along

> > > > with some text. When I set the value to "str(m.Year) + 'Auto Mileage

> > > > Report'" that string is displayed rather than "2015 Auto Mileage

> > Report."

> > > >

> > > > I think I solved this years ago with the use of a special character

> or

> > > > syntax but I can't remember what it was.

> > > >

> > > > Thanks in advance for any help,

> > > >

> > > > Joe

> > > >

> > > >

> > > > --- StripMime Report -- processed MIME parts ---

> > > > multipart/alternative

> > > > text/plain (text body -- kept)

> > > > text/html

> > > > ---

> > > >

[excessive quoting removed by server]

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/CACUu1Su0TsYDcr5jD5QNUbZJKy6+HgNWzvQH1fYVcue=XgMy=w@mail.gmail.com

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

©2016 Koen Piller