sql server reporting services: SQL Reporting Services - Global Parameter / Email Title -- sql server reporting services

SQL Reporting Services - Global Parameter / Email Title

mentor
9/2/2005 7:15:02 AM

sql server reporting services: Hi,

I have the report which is run in the morning and shows all records
submitted during the previous day. I have created the email
subscription to send that report to users. Is there any way to input
the date (only the date) the records were submitted on in title/subject
of that email?

RE: SQL Reporting Services - Global Parameter / Email Title

daw
9/2/2005 7:41:03 AM

I put this in the Body, at the top of the report:

="For " & string.format("{0:M/d/yyyy}", parameters!Date.Value) )

[quoted text, click to view]

Re: SQL Reporting Services - Global Parameter / Email Title

mentor
9/2/2005 7:52:11 AM

But I need to have that date in email subject (email subscription).

Re: SQL Reporting Services - Global Parameter / Email Title

daw
9/2/2005 8:09:04 AM

Oops, sorry about that.

[quoted text, click to view]

Re: SQL Reporting Services - Global Parameter / Email Title

daw
9/2/2005 8:25:07 AM

Do you have to schedule it in the morning? If not, you could have the report
scheduled to run at 11:59 pm and the date would be the same as the
@ExecutionTime parameter. Not sure if you can convert that to just the date,
though.

[quoted text, click to view]

Re: SQL Reporting Services - Global Parameter / Email Title

mentor
9/2/2005 8:43:10 AM

I have a couple reports to schedule and they need to be run in the
morning. Maybe there is any way to add new global parameter or change
any existing parameter to format i need. Any ideas

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.