|
|
You're in the
sql server reporting services
group:Dynamic Parameter Date Ranges
sql server reporting services:
1.)Daterange 2.)EndDate 3.)Start Date Selecting an option from the DateRange Parameter (eg. option = today) automatically populates the EndDate and StartDate Fields. I also want to give the user the option to extend the date range to one which is not defined as a daterange option of desired by editing the EndDate and StartDate Fields.
Hi,
I have exactly the same problem, did you found a solution? Thanks, Elisabeth [quoted text, click to view] "SAcanuck" wrote:
> I require three parameter fields: > > 1.)Daterange > 2.)EndDate > 3.)Start Date > > Selecting an option from the DateRange Parameter (eg. option = today) > automatically populates the EndDate and StartDate Fields. I also want to give > the user the option to extend the date range to one which is not defined as a > daterange option of desired by editing the EndDate and StartDate Fields. >
No I havent found a solution that works like I want it to.
[quoted text, click to view] "Elisabeth" wrote:
> Hi, > > I have exactly the same problem, did you found a solution? > Thanks, > Elisabeth > > "SAcanuck" wrote: > > > I require three parameter fields: > > > > 1.)Daterange > > 2.)EndDate > > 3.)Start Date > > > > Selecting an option from the DateRange Parameter (eg. option = today) > > automatically populates the EndDate and StartDate Fields. I also want to give > > the user the option to extend the date range to one which is not defined as a > > daterange option of desired by editing the EndDate and StartDate Fields. > >
Bruce:
I have tried this before but it doesnt perform as expected... When you run your report the first time and select the first parameter the other two dates are populated correctly, but when you change your first parameter (date range) the other dates are not automatically changed. [quoted text, click to view] "Bruce Loehle-Conger" wrote:
> I would have to play with this but it seems like if you have three > parameters and the second and third parameters have an expression as the > default with the expression referencing the first parameter. I can't try > this right now but it should work. > > Bruce L-C > > "SAcanuck" <SAcanuck@discussions.microsoft.com> wrote in message > news:FDF1B605-75D3-4BF5-9E05-B28202D35A12@microsoft.com... > > No I havent found a solution that works like I want it to. > > > > > > "Elisabeth" wrote: > > > >> Hi, > >> > >> I have exactly the same problem, did you found a solution? > >> Thanks, > >> Elisabeth > >> > >> "SAcanuck" wrote: > >> > >> > I require three parameter fields: > >> > > >> > 1.)Daterange > >> > 2.)EndDate > >> > 3.)Start Date > >> > > >> > Selecting an option from the DateRange Parameter (eg. option = today) > >> > automatically populates the EndDate and StartDate Fields. I also want > >> > to give > >> > the user the option to extend the date range to one which is not > >> > defined as a > >> > daterange option of desired by editing the EndDate and StartDate > >> > Fields. > >> > > >> > Any help is appreciated. > >
I would have to play with this but it seems like if you have three
parameters and the second and third parameters have an expression as the default with the expression referencing the first parameter. I can't try this right now but it should work. Bruce L-C [quoted text, click to view] "SAcanuck" <SAcanuck@discussions.microsoft.com> wrote in message news:FDF1B605-75D3-4BF5-9E05-B28202D35A12@microsoft.com... > No I havent found a solution that works like I want it to. > > > "Elisabeth" wrote: > >> Hi, >> >> I have exactly the same problem, did you found a solution? >> Thanks, >> Elisabeth >> >> "SAcanuck" wrote: >> >> > I require three parameter fields: >> > >> > 1.)Daterange >> > 2.)EndDate >> > 3.)Start Date >> > >> > Selecting an option from the DateRange Parameter (eg. option = today) >> > automatically populates the EndDate and StartDate Fields. I also want >> > to give >> > the user the option to extend the date range to one which is not >> > defined as a >> > daterange option of desired by editing the EndDate and StartDate >> > Fields. >> > >> > Any help is appreciated.
Bruce,
I have tried it also and it didn't work. I hope you will find time to try it.... waiting, Elisabeth [quoted text, click to view] "SAcanuck" wrote:
> Bruce: > > I have tried this before but it doesnt perform as expected... > > When you run your report the first time and select the first parameter the > other two dates are populated correctly, but when you change your first > parameter (date range) the other dates are not automatically changed. > > "Bruce Loehle-Conger" wrote: > > > I would have to play with this but it seems like if you have three > > parameters and the second and third parameters have an expression as the > > default with the expression referencing the first parameter. I can't try > > this right now but it should work. > > > > Bruce L-C > > > > "SAcanuck" <SAcanuck@discussions.microsoft.com> wrote in message > > news:FDF1B605-75D3-4BF5-9E05-B28202D35A12@microsoft.com... > > > No I havent found a solution that works like I want it to. > > > > > > > > > "Elisabeth" wrote: > > > > > >> Hi, > > >> > > >> I have exactly the same problem, did you found a solution? > > >> Thanks, > > >> Elisabeth > > >> > > >> "SAcanuck" wrote: > > >> > > >> > I require three parameter fields: > > >> > > > >> > 1.)Daterange > > >> > 2.)EndDate > > >> > 3.)Start Date > > >> > > > >> > Selecting an option from the DateRange Parameter (eg. option = today) > > >> > automatically populates the EndDate and StartDate Fields. I also want > > >> > to give > > >> > the user the option to extend the date range to one which is not > > >> > defined as a > > >> > daterange option of desired by editing the EndDate and StartDate > > >> > Fields. > > >> > > > >> > Any help is appreciated. > > > >
Elisabeth:
Maybe the following link helps you...Im not a SQL Guru (far from it....) so it doesnt help me much. http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?pg=4&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&fltr= [quoted text, click to view] "Elisabeth" wrote:
> Bruce, > > I have tried it also and it didn't work. > I hope you will find time to try it.... > waiting, > Elisabeth > > "SAcanuck" wrote: > > > Bruce: > > > > I have tried this before but it doesnt perform as expected... > > > > When you run your report the first time and select the first parameter the > > other two dates are populated correctly, but when you change your first > > parameter (date range) the other dates are not automatically changed. > > > > "Bruce Loehle-Conger" wrote: > > > > > I would have to play with this but it seems like if you have three > > > parameters and the second and third parameters have an expression as the > > > default with the expression referencing the first parameter. I can't try > > > this right now but it should work. > > > > > > Bruce L-C > > > > > > "SAcanuck" <SAcanuck@discussions.microsoft.com> wrote in message > > > news:FDF1B605-75D3-4BF5-9E05-B28202D35A12@microsoft.com... > > > > No I havent found a solution that works like I want it to. > > > > > > > > > > > > "Elisabeth" wrote: > > > > > > > >> Hi, > > > >> > > > >> I have exactly the same problem, did you found a solution? > > > >> Thanks, > > > >> Elisabeth > > > >> > > > >> "SAcanuck" wrote: > > > >> > > > >> > I require three parameter fields: > > > >> > > > > >> > 1.)Daterange > > > >> > 2.)EndDate > > > >> > 3.)Start Date > > > >> > > > > >> > Selecting an option from the DateRange Parameter (eg. option = today) > > > >> > automatically populates the EndDate and StartDate Fields. I also want > > > >> > to give > > > >> > the user the option to extend the date range to one which is not > > > >> > defined as a > > > >> > daterange option of desired by editing the EndDate and StartDate > > > >> > Fields. > > > >> > > > > >> > Any help is appreciated. > > > > > >
Hi Bruce:
It does work after deploying... slightly annoying though. Thanks for the effort. [quoted text, click to view] "Bruce Loehle-Conger [MVP]" wrote:
> OK, I just tried this out and in the development environment it does as you > say. However, when I deploy it and try it from the server then it works as > you would expect. Can you try it after deploying it? > > Bruce L-C [MVP SQL Server Reporting Services] > > "SAcanuck" <SAcanuck@discussions.microsoft.com> wrote in message > news:450111A7-157F-4000-B331-F36758529639@microsoft.com... > > Bruce: > > > > I have tried this before but it doesnt perform as expected... > > > > When you run your report the first time and select the first parameter the > > other two dates are populated correctly, but when you change your first > > parameter (date range) the other dates are not automatically changed. > > > > "Bruce Loehle-Conger" wrote: > > > > > I would have to play with this but it seems like if you have three > > > parameters and the second and third parameters have an expression as the > > > default with the expression referencing the first parameter. I can't try > > > this right now but it should work. > > > > > > Bruce L-C > > > > > > "SAcanuck" <SAcanuck@discussions.microsoft.com> wrote in message > > > news:FDF1B605-75D3-4BF5-9E05-B28202D35A12@microsoft.com... > > > > No I havent found a solution that works like I want it to. > > > > > > > > > > > > "Elisabeth" wrote: > > > > > > > >> Hi, > > > >> > > > >> I have exactly the same problem, did you found a solution? > > > >> Thanks, > > > >> Elisabeth > > > >> > > > >> "SAcanuck" wrote: > > > >> > > > >> > I require three parameter fields: > > > >> > > > > >> > 1.)Daterange > > > >> > 2.)EndDate > > > >> > 3.)Start Date > > > >> > > > > >> > Selecting an option from the DateRange Parameter (eg. option = > today) > > > >> > automatically populates the EndDate and StartDate Fields. I also > want > > > >> > to give > > > >> > the user the option to extend the date range to one which is not > > > >> > defined as a > > > >> > daterange option of desired by editing the EndDate and StartDate > > > >> > Fields. > > > >> > > > > >> > Any help is appreciated. > > > > > > > > > > >
I think something is missing in the link you send to me....
[quoted text, click to view] "SAcanuck" wrote:
> Elisabeth: > > Maybe the following link helps you...Im not a SQL Guru (far from it....) so > it doesnt help me much. > > http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?pg=4&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&fltr= > > "Elisabeth" wrote: > > > Bruce, > > > > I have tried it also and it didn't work. > > I hope you will find time to try it.... > > waiting, > > Elisabeth > > > > "SAcanuck" wrote: > > > > > Bruce: > > > > > > I have tried this before but it doesnt perform as expected... > > > > > > When you run your report the first time and select the first parameter the > > > other two dates are populated correctly, but when you change your first > > > parameter (date range) the other dates are not automatically changed. > > > > > > "Bruce Loehle-Conger" wrote: > > > > > > > I would have to play with this but it seems like if you have three > > > > parameters and the second and third parameters have an expression as the > > > > default with the expression referencing the first parameter. I can't try > > > > this right now but it should work. > > > > > > > > Bruce L-C > > > > > > > > "SAcanuck" <SAcanuck@discussions.microsoft.com> wrote in message > > > > news:FDF1B605-75D3-4BF5-9E05-B28202D35A12@microsoft.com... > > > > > No I havent found a solution that works like I want it to. > > > > > > > > > > > > > > > "Elisabeth" wrote: > > > > > > > > > >> Hi, > > > > >> > > > > >> I have exactly the same problem, did you found a solution? > > > > >> Thanks, > > > > >> Elisabeth > > > > >> > > > > >> "SAcanuck" wrote: > > > > >> > > > > >> > I require three parameter fields: > > > > >> > > > > > >> > 1.)Daterange > > > > >> > 2.)EndDate > > > > >> > 3.)Start Date > > > > >> > > > > > >> > Selecting an option from the DateRange Parameter (eg. option = today) > > > > >> > automatically populates the EndDate and StartDate Fields. I also want > > > > >> > to give > > > > >> > the user the option to extend the date range to one which is not > > > > >> > defined as a > > > > >> > daterange option of desired by editing the EndDate and StartDate > > > > >> > Fields. > > > > >> > > > > > >> > Any help is appreciated. > > > > > > > >
OK, I just tried this out and in the development environment it does as you
say. However, when I deploy it and try it from the server then it works as you would expect. Can you try it after deploying it? Bruce L-C [MVP SQL Server Reporting Services] [quoted text, click to view] "SAcanuck" <SAcanuck@discussions.microsoft.com> wrote in message news:450111A7-157F-4000-B331-F36758529639@microsoft.com... > Bruce: > > I have tried this before but it doesnt perform as expected... > > When you run your report the first time and select the first parameter the > other two dates are populated correctly, but when you change your first > parameter (date range) the other dates are not automatically changed. > > "Bruce Loehle-Conger" wrote: > > > I would have to play with this but it seems like if you have three > > parameters and the second and third parameters have an expression as the > > default with the expression referencing the first parameter. I can't try > > this right now but it should work. > > > > Bruce L-C > > > > "SAcanuck" <SAcanuck@discussions.microsoft.com> wrote in message > > news:FDF1B605-75D3-4BF5-9E05-B28202D35A12@microsoft.com... > > > No I havent found a solution that works like I want it to. > > > > > > > > > "Elisabeth" wrote: > > > > > >> Hi, > > >> > > >> I have exactly the same problem, did you found a solution? > > >> Thanks, > > >> Elisabeth > > >> > > >> "SAcanuck" wrote: > > >> > > >> > I require three parameter fields: > > >> > > > >> > 1.)Daterange > > >> > 2.)EndDate > > >> > 3.)Start Date > > >> > > > >> > Selecting an option from the DateRange Parameter (eg. option = today) > > >> > automatically populates the EndDate and StartDate Fields. I also want > > >> > to give > > >> > the user the option to extend the date range to one which is not > > >> > defined as a > > >> > daterange option of desired by editing the EndDate and StartDate > > >> > Fields. > > >> > > > >> > Any help is appreciated. > > > > > >
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 |