Showing posts with label subscription. Show all posts
Showing posts with label subscription. Show all posts

Monday, March 19, 2012

Date in the file name for a subscription

I'm in desperate need for insight into how I can use the current date, or
part of the current date, in the filename of a report delivered through a
data-driven subscription and snapshot? Any info is appreciated, apparently
this is possible but there's no info anywhere on how this can be completed
and my company is depending on a solution. I'm at the point where I don't
know what to say to them and I don't know where to look for a resolution for
this request. Thank you.
ChrisJust have the query used for the Data Driven subscription return the file
name. You can then have the sql statement get the current date.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chris" <idroppeddabomb@.hotmail.com> wrote in message
news:e3zS1BiqEHA.3428@.TK2MSFTNGP11.phx.gbl...
> I'm in desperate need for insight into how I can use the current date, or
> part of the current date, in the filename of a report delivered through a
> data-driven subscription and snapshot? Any info is appreciated, apparently
> this is possible but there's no info anywhere on how this can be completed
> and my company is depending on a solution. I'm at the point where I don't
> know what to say to them and I don't know where to look for a resolution
for
> this request. Thank you.
> Chris
>

Date in subject line of email subscription

Hi,
is there any way to automatically put the date of previous day in
subject line of email subscription? Can anybody tell me how to do it?The only way to do this would be with Data Driven subscriptions. First you
have to have Enterprise edition or Data Driven subscriptions are not
present. If you do have the Enterprise edition then you can generate the
subject from a SQL query.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"mentor" <daniel.pater@.pl.ibm.com> wrote in message
news:1126166552.090643.170840@.f14g2000cwb.googlegroups.com...
> Hi,
> is there any way to automatically put the date of previous day in
> subject line of email subscription? Can anybody tell me how to do it?
>|||Thanks a lot
i resolved this problem in different way. I save the reports to shared
folder and send them using vbs file :)

Wednesday, March 7, 2012

Date Format Data Driven Subscription

I'm getting the typical error that the format of my date parameters is not correct. Although i'm getting my dates in a select from a datetime field.

Is there really no universal format that can be delivered to RS that he can interprete the date right, whatever language the report has been set to.

Kind Regards .....

You can define your datetime parameters as YYYY-MM-DDTHH:MM:SS. This format is independent of the language of the report.

See http://msdn2.microsoft.com/en-us/library/ms159825.aspx for moer details.