Re: Report label caption expression

2016-08-25 Thread rafael copquin 

I'm sorry, I read his post quickly and did not notice

My bad

The best solution then is to use a textbox

Rafael



On 25/08/2016 10:18, Laurie Alvey wrote:

Rafael, that would be fine on a form, but Joe is talking about a REPORT
label!

Laurie

On 25 August 2016 at 13:22, rafael copquin  wrote:


If you want to use a label do this:

local cText,cYear

cYear = alltrim( str( year() ) )  && if you want the current year

cText = cYear+' Auto mileage report'

thisform.lblYear.caption = cText

Rafael Copquin



On 24/08/2016 22:14, Joe Yoder 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/67c1f463-e971-87fd-3f41-d7ec9c6ea...@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.

Re: Report label caption expression

2016-08-25 Thread Laurie Alvey 
Rafael, that would be fine on a form, but Joe is talking about a REPORT
label!

Laurie

On 25 August 2016 at 13:22, rafael copquin  wrote:

> If you want to use a label do this:
>
> local cText,cYear
>
> cYear = alltrim( str( year() ) )  && if you want the current year
>
> cText = cYear+' Auto mileage report'
>
> thisform.lblYear.caption = cText
>
> Rafael Copquin
>
>
>
> On 24/08/2016 22:14, Joe Yoder 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/CAMvTR9eSqthRowd==tfUiMSsFfj=joaee-3tx1keoukd+dz...@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.

Re: Report label caption expression

2016-08-25 Thread rafael copquin 

If you want to use a label do this:

local cText,cYear

cYear = alltrim( str( year() ) )  && if you want the current year

cText = cYear+' Auto mileage report'

thisform.lblYear.caption = cText

Rafael Copquin



On 24/08/2016 22:14, Joe Yoder 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/9e68d83d-afee-fba5-474e-4ce1bba19...@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.

Re: Report label caption expression

2016-08-24 Thread Koen Piller 
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 :

> 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  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  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  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.

Re: Report label caption expression

2016-08-24 Thread Fred Taylor 
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  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  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  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/cajcbkspknwnuvlqnjmkddj-kc+wm6bmcqlw0w9mdosy_gpf...@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.

Re: Report label caption expression

2016-08-24 Thread Joe Yoder 
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  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  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/cabqednxqpxtactuhanqmchnq0xjs4jra_ptfx+itfvnhnjw...@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.

Re: Report label caption expression

2016-08-24 Thread Fred Taylor 
Be sure your putting it into a text field not a label.

Fred

On Wed, Aug 24, 2016 at 6:14 PM, Joe Yoder  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/cajcbksqm-_+qojgfnkay67m3hcpvq08ygocgpok6p2a97bc...@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.

Report label caption expression

2016-08-24 Thread Joe Yoder 
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
---

___
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/cabqednxeugkgtu_vqskmsa0barujcn7m7vbvqsgxopa5e31...@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.