|
|
You're in the
sql server reporting services
group:Expressions for parameter values??
sql server reporting services:
date. -- Rajeev Karunakaran [MSFT] Microsoft SQL Server Reporting Services This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] "Arthur Dent" <hitchhikersguideto-news@yahoo.com> wrote in message news:u7NwrsrSFHA.3140@TK2MSFTNGP14.phx.gbl... > Hello all.... im trying to figure out... how can i use an expression in a > parameter formula? > > I have a report which takes a date parameter. I want to make a > subscription using last week as the date. So for example, i want to set up > the subscription to run every Sunday, and use a value of TODAY() - 7. If i > enter that as a value though, it says its an invalid type. I also tried it > with an equal sign on the front ( =TODAY()-6 ). > > Is there a way to do this? > > Thanks in advance, > - Arthur Dent. >
Hello all.... im trying to figure out... how can i use an expression in a
parameter formula? I have a report which takes a date parameter. I want to make a subscription using last week as the date. So for example, i want to set up the subscription to run every Sunday, and use a value of TODAY() - 7. If i enter that as a value though, it says its an invalid type. I also tried it with an equal sign on the front ( =TODAY()-6 ). Is there a way to do this? Thanks in advance, - Arthur Dent.
It sounds like you are trying to type an expression into the date field in
report manager. This won't work - you can only type date constants there. You should rather load the report in report designer and set the default value of the date parameter to something like =Today.AddDays(-7). Before publishing to the report server, make sure to delete the existing report *before* publishing. Then, you can create a subscription which will use an expression-based default value for the date parameter. -- Robert This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] "Arthur Dent" <hitchhikersguideto-news@yahoo.com> wrote in message news:eYecTDtSFHA.3184@TK2MSFTNGP14.phx.gbl... > Thanks for the reply. Unfortunately, that doesnt seem to work either. When > i type in "DATEADD(d,-7,TODAY())" for my parameter, i get an error as so: > > The value provided for the report parameter 'ForWeekOf' is not valid for > its type. (rsReportParameterTypeMismatch) > TIA- > > > "Rajeev Karunakaran" <rajeevkarunakaran@online.microsoft.com> wrote in > message news:edMnSbsSFHA.3672@TK2MSFTNGP10.phx.gbl... >> You can use the DateAdd function to add a day/hour/minute/month etc to a >> date. >> >> -- >> Rajeev Karunakaran [MSFT] >> Microsoft SQL Server Reporting Services >> >> This posting is provided "AS IS" with no warranties, and confers no >> rights. >> >> "Arthur Dent" <hitchhikersguideto-news@yahoo.com> wrote in message >> news:u7NwrsrSFHA.3140@TK2MSFTNGP14.phx.gbl... >>> Hello all.... im trying to figure out... how can i use an expression in >>> a parameter formula? >>> >>> I have a report which takes a date parameter. I want to make a >>> subscription using last week as the date. So for example, i want to set >>> up the subscription to run every Sunday, and use a value of TODAY() - 7. >>> If i enter that as a value though, it says its an invalid type. I also >>> tried it with an equal sign on the front ( =TODAY()-6 ). >>> >>> Is there a way to do this? >>> >>> Thanks in advance, >>> - Arthur Dent. >>> >> >> > >
Thanks for the reply. Unfortunately, that doesnt seem to work either. When i
type in "DATEADD(d,-7,TODAY())" for my parameter, i get an error as so: The value provided for the report parameter 'ForWeekOf' is not valid for its type. (rsReportParameterTypeMismatch) TIA- "Rajeev Karunakaran" <rajeevkarunakaran@online.microsoft.com> wrote in message news:edMnSbsSFHA.3672@TK2MSFTNGP10.phx.gbl... [quoted text, click to view] > You can use the DateAdd function to add a day/hour/minute/month etc to a > date. > > -- > Rajeev Karunakaran [MSFT] > Microsoft SQL Server Reporting Services > > This posting is provided "AS IS" with no warranties, and confers no > rights. > > "Arthur Dent" <hitchhikersguideto-news@yahoo.com> wrote in message > news:u7NwrsrSFHA.3140@TK2MSFTNGP14.phx.gbl... >> Hello all.... im trying to figure out... how can i use an expression in a >> parameter formula? >> >> I have a report which takes a date parameter. I want to make a >> subscription using last week as the date. So for example, i want to set >> up the subscription to run every Sunday, and use a value of TODAY() - 7. >> If i enter that as a value though, it says its an invalid type. I also >> tried it with an equal sign on the front ( =TODAY()-6 ). >> >> Is there a way to do this? >> >> Thanks in advance, >> - Arthur Dent. >> > >
Ah, yes, that sounds like it would do exactly what i need.
Thanks!! [quoted text, click to view] "Robert Bruckner [MSFT]" <robruc@online.microsoft.com> wrote in message news:O69jArtSFHA.2556@TK2MSFTNGP12.phx.gbl... > It sounds like you are trying to type an expression into the date field in > report manager. This won't work - you can only type date constants there. > > You should rather load the report in report designer and set the default > value of the date parameter to something like =Today.AddDays(-7). Before > publishing to the report server, make sure to delete the existing report > *before* publishing. > Then, you can create a subscription which will use an expression-based > default value for the date parameter. > > > -- Robert > This posting is provided "AS IS" with no warranties, and confers no > rights. > > > "Arthur Dent" <hitchhikersguideto-news@yahoo.com> wrote in message > news:eYecTDtSFHA.3184@TK2MSFTNGP14.phx.gbl... >> Thanks for the reply. Unfortunately, that doesnt seem to work either. >> When i type in "DATEADD(d,-7,TODAY())" for my parameter, i get an error >> as so: >> >> The value provided for the report parameter 'ForWeekOf' is not valid for >> its type. (rsReportParameterTypeMismatch) >> TIA- >> >> >> "Rajeev Karunakaran" <rajeevkarunakaran@online.microsoft.com> wrote in >> message news:edMnSbsSFHA.3672@TK2MSFTNGP10.phx.gbl... >>> You can use the DateAdd function to add a day/hour/minute/month etc to a >>> date. >>> >>> -- >>> Rajeev Karunakaran [MSFT] >>> Microsoft SQL Server Reporting Services >>> >>> This posting is provided "AS IS" with no warranties, and confers no >>> rights. >>> >>> "Arthur Dent" <hitchhikersguideto-news@yahoo.com> wrote in message >>> news:u7NwrsrSFHA.3140@TK2MSFTNGP14.phx.gbl... >>>> Hello all.... im trying to figure out... how can i use an expression in >>>> a parameter formula? >>>> >>>> I have a report which takes a date parameter. I want to make a >>>> subscription using last week as the date. So for example, i want to set >>>> up the subscription to run every Sunday, and use a value of TODAY() - >>>> 7. If i enter that as a value though, it says its an invalid type. I >>>> also tried it with an equal sign on the front ( =TODAY()-6 ). >>>> >>>> Is there a way to do this? >>>> >>>> Thanks in advance, >>>> - Arthur Dent. >>>> >>> >>> >> >> > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |