Re: Report label caption expression

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

Re: Report label caption expression

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 >

Re: Report label caption expression

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

Re: Report label caption expression

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

Re: Report label caption expression

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

Re: Report label caption expression

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,

Re: Report label caption expression

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

Report label caption expression

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