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_vQSKMSA0bArUJcN7m7VBvQSGxOpA5E31d-Q@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.
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/CAJCBksqm-_+qojGFNKay67M3HCPvq08YgOCgPoK6P2A97bc-5Q@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.
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/CABQeDnXqPXtActUhaNqmChNQ0xjs4jrA_ptfx+itFvNHnjWSdg@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.
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/CAJCBkspkNwnUVLQnjMKddJ-kc+wM6bMcqLw0w9Mdosy_gPfL3A@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.
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.
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-4ce1bba19b3d@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.
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 <rafael.copquin@gmail.com> 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+dz8Eg@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.
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 <rafael.copquin@gmail.com> 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-d7ec9c6ea4b4@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.