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 ---
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]
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]
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]
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]
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]
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]
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]
-
Fred Taylor -
Joe Yoder -
Koen Piller -
Laurie Alvey -
rafael copquin