Best case, I include the report date in the report header. Worst case, in
the subject line of the subscription email. I'm using SQL/RS v2000, VS 2003,
anybody know how I can do this? nothing crazy, just like this:
ReportName xx/xx/xxxx
I tried to add a text box into the header, just filling it w/this expression: select LEFT(Dateadd(mm,-0,getdate()),11) it fails indicating 'the value expression for the textbox 'textbox7' contains and error: [BC30201] Expression expected.' please advise -- Lynn [quoted text, click to view] "Lynn" wrote:
> Best case, I include the report date in the report header. Worst case, in
> the subject line of the subscription email. I'm using SQL/RS v2000, VS 2003,
> anybody know how I can do this? nothing crazy, just like this:
>
> ReportName xx/xx/xxxx
>
Please disregard, I got it. I included a text box with this as the expression, everything is fine now, thanks anyway: =Format(today()," dd MMM yy" ) -- Lynn [quoted text, click to view] "Lynn" wrote:
> I tried to add a text box into the header, just filling it w/this expression:
>
> select LEFT(Dateadd(mm,-0,getdate()),11)
>
> it fails indicating
> 'the value expression for the textbox 'textbox7' contains and error:
> [BC30201] Expression expected.'
>
> please advise
>
> -- Lynn
>
>
> "Lynn" wrote:
>
> > Best case, I include the report date in the report header. Worst case, in
> > the subject line of the subscription email. I'm using SQL/RS v2000, VS 2003,
> > anybody know how I can do this? nothing crazy, just like this:
> >
> > ReportName xx/xx/xxxx
> >
Will do, Bruce, thank you. I will check it out. -- Lynn oh, oh, just a slightly related question -- i've created my browser role and i'm trying to send out this : http://webserver/reports such that certain people can have direct access to a number of my reports right now there's a 'Users Folders' in there along with my reports. I'm unable to hide that. Do you know how to get rid of it? [quoted text, click to view] "Bruce L-C [MVP]" wrote:
> Just an FYI, you can use expression builder, look at the global variables.
> One of those has what you want.
>
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Lynn" <Lynn@discussions.microsoft.com> wrote in message
> news:DA80718F-E475-4891-93A5-EAEB1CB3D2D7@microsoft.com...
> > Best case, I include the report date in the report header. Worst case, in
> > the subject line of the subscription email. I'm using SQL/RS v2000, VS
> > 2003,
> > anybody know how I can do this? nothing crazy, just like this:
> >
> > ReportName xx/xx/xxxx
> >
> > -- Lynn
>
>
Just an FYI, you can use expression builder, look at the global variables. One of those has what you want. -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Lynn" <Lynn@discussions.microsoft.com> wrote in message
news:DA80718F-E475-4891-93A5-EAEB1CB3D2D7@microsoft.com...
> Best case, I include the report date in the report header. Worst case, in
> the subject line of the subscription email. I'm using SQL/RS v2000, VS
> 2003,
> anybody know how I can do this? nothing crazy, just like this:
>
> ReportName xx/xx/xxxx
>
> -- Lynn
Yes, you can remove the browser role from that particular folder. Normally the folder inherits from the parent so all folders initially have the same roles assigned to them. Click on the folder, properties, security and remove the browser role. Or, if it is just that you don't want them distracted by it, you could hide in list view (properties, general). -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Lynn" <Lynn@discussions.microsoft.com> wrote in message
news:CDBC9A73-7FD8-4271-9BCE-73D03A0BD3D1@microsoft.com...
> Will do, Bruce, thank you. I will check it out.
> -- Lynn
>
> oh, oh, just a slightly related question -- i've created my browser role
> and
> i'm trying to send out this : http://webserver/reports
> such that certain people can have direct access to a number of my reports
> right now there's a 'Users Folders' in there along with my reports. I'm
> unable to hide that. Do you know how to get rid of it?
>
> "Bruce L-C [MVP]" wrote:
>
>> Just an FYI, you can use expression builder, look at the global
>> variables.
>> One of those has what you want.
>>
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Lynn" <Lynn@discussions.microsoft.com> wrote in message
>> news:DA80718F-E475-4891-93A5-EAEB1CB3D2D7@microsoft.com...
>> > Best case, I include the report date in the report header. Worst case,
>> > in
>> > the subject line of the subscription email. I'm using SQL/RS v2000, VS
>> > 2003,
>> > anybody know how I can do this? nothing crazy, just like this:
>> >
>> > ReportName xx/xx/xxxx
>> >
>> > -- Lynn
>>
>>
>>
Don't see what you're looking for? Try a search.
|
