|
|
You're in the
sql server reporting services
group:Reporting Services Designer problem
sql server reporting services:
I have had that on occasion. The good news is it is only a problem in
design, it will work in production. When I have a report that does this I deploy and test and don't use the preview in the designer. At least it is a workaround. I haven't tried this in RS 2005 to see if the problem went away. -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Chris McKenzie" <crmckenzie@gmail.com> wrote in message news:eE00LavvFHA.3256@TK2MSFTNGP09.phx.gbl... > I'm having a serious problem with the Reporting Services designer. I have > a report with 2 parameters offered as dropdown lists. The first time I go > into the designer, I can change the value of the dropdownlists (with some > flashing behavior that doesn't make sense) and execute the report. > However, if I go back to the layout tab and then return to the Preview tab > and do the same thing, the designer acts like its caught in some kind of > endless loop. It flashes constantly as if refreshing the paramters list, > locks up Visual Studio completely, and continues to consume memory. I end > up having to kill devenv.exe in the task manager to get anything done > > Is there a fix for this? > > I'm using VIsual Studio 2003 and Sql Server Reporting Services Developer > Edition SP2. > > I can provide a sample dataset and rdl file to Microsoft if it becomes > necessary. > > Thanks, > Chris McKenzie >
I'm having a serious problem with the Reporting Services designer. I have a
report with 2 parameters offered as dropdown lists. The first time I go into the designer, I can change the value of the dropdownlists (with some flashing behavior that doesn't make sense) and execute the report. However, if I go back to the layout tab and then return to the Preview tab and do the same thing, the designer acts like its caught in some kind of endless loop. It flashes constantly as if refreshing the paramters list, locks up Visual Studio completely, and continues to consume memory. I end up having to kill devenv.exe in the task manager to get anything done Is there a fix for this? I'm using VIsual Studio 2003 and Sql Server Reporting Services Developer Edition SP2. I can provide a sample dataset and rdl file to Microsoft if it becomes necessary. Thanks, Chris McKenzie
Aye, that's what I ended up having to do to get my work done. Do you know if
this is a known bug? Chris [quoted text, click to view] "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message news:OqJ4ynvvFHA.3400@TK2MSFTNGP14.phx.gbl... >I have had that on occasion. The good news is it is only a problem in >design, it will work in production. When I have a report that does this I >deploy and test and don't use the preview in the designer. At least it is a >workaround. I haven't tried this in RS 2005 to see if the problem went >away. > > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > "Chris McKenzie" <crmckenzie@gmail.com> wrote in message > news:eE00LavvFHA.3256@TK2MSFTNGP09.phx.gbl... >> I'm having a serious problem with the Reporting Services designer. I have >> a report with 2 parameters offered as dropdown lists. The first time I go >> into the designer, I can change the value of the dropdownlists (with some >> flashing behavior that doesn't make sense) and execute the report. >> However, if I go back to the layout tab and then return to the Preview >> tab and do the same thing, the designer acts like its caught in some kind >> of endless loop. It flashes constantly as if refreshing the paramters >> list, locks up Visual Studio completely, and continues to consume memory. >> I end up having to kill devenv.exe in the task manager to get anything >> done >> >> Is there a fix for this? >> >> I'm using VIsual Studio 2003 and Sql Server Reporting Services Developer >> Edition SP2. >> >> I can provide a sample dataset and rdl file to Microsoft if it becomes >> necessary. >> >> Thanks, >> Chris McKenzie >> > >
I also have had this problem...From what I've learned it seems to be a
problem w/ report parameters being out of order when depending on one another... try changing around the order of the parameters... Cheers! Ben Sullins [quoted text, click to view] "Bruce L-C [MVP]" wrote:
> I'll try to find a report of mine that does this and see if it still does it > in RS 2005. > > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > "Chris McKenzie" <crmckenzie@gmail.com> wrote in message > news:ujnns92vFHA.1560@TK2MSFTNGP09.phx.gbl... > > Aye, that's what I ended up having to do to get my work done. Do you know > > if this is a known bug? > > > > Chris > > > > "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message > > news:OqJ4ynvvFHA.3400@TK2MSFTNGP14.phx.gbl... > >>I have had that on occasion. The good news is it is only a problem in > >>design, it will work in production. When I have a report that does this I > >>deploy and test and don't use the preview in the designer. At least it is > >>a workaround. I haven't tried this in RS 2005 to see if the problem went > >>away. > >> > >> > >> -- > >> Bruce Loehle-Conger > >> MVP SQL Server Reporting Services > >> > >> "Chris McKenzie" <crmckenzie@gmail.com> wrote in message > >> news:eE00LavvFHA.3256@TK2MSFTNGP09.phx.gbl... > >>> I'm having a serious problem with the Reporting Services designer. I > >>> have a report with 2 parameters offered as dropdown lists. The first > >>> time I go into the designer, I can change the value of the dropdownlists > >>> (with some flashing behavior that doesn't make sense) and execute the > >>> report. However, if I go back to the layout tab and then return to the > >>> Preview tab and do the same thing, the designer acts like its caught in > >>> some kind of endless loop. It flashes constantly as if refreshing the > >>> paramters list, locks up Visual Studio completely, and continues to > >>> consume memory. I end up having to kill devenv.exe in the task manager > >>> to get anything done > >>> > >>> Is there a fix for this? > >>> > >>> I'm using VIsual Studio 2003 and Sql Server Reporting Services Developer > >>> Edition SP2. > >>> > >>> I can provide a sample dataset and rdl file to Microsoft if it becomes > >>> necessary. > >>> > >>> Thanks, > >>> Chris McKenzie > >>> > >> > >> > > > > > >
I'll try to find a report of mine that does this and see if it still does it
in RS 2005. -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Chris McKenzie" <crmckenzie@gmail.com> wrote in message news:ujnns92vFHA.1560@TK2MSFTNGP09.phx.gbl... > Aye, that's what I ended up having to do to get my work done. Do you know > if this is a known bug? > > Chris > > "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message > news:OqJ4ynvvFHA.3400@TK2MSFTNGP14.phx.gbl... >>I have had that on occasion. The good news is it is only a problem in >>design, it will work in production. When I have a report that does this I >>deploy and test and don't use the preview in the designer. At least it is >>a workaround. I haven't tried this in RS 2005 to see if the problem went >>away. >> >> >> -- >> Bruce Loehle-Conger >> MVP SQL Server Reporting Services >> >> "Chris McKenzie" <crmckenzie@gmail.com> wrote in message >> news:eE00LavvFHA.3256@TK2MSFTNGP09.phx.gbl... >>> I'm having a serious problem with the Reporting Services designer. I >>> have a report with 2 parameters offered as dropdown lists. The first >>> time I go into the designer, I can change the value of the dropdownlists >>> (with some flashing behavior that doesn't make sense) and execute the >>> report. However, if I go back to the layout tab and then return to the >>> Preview tab and do the same thing, the designer acts like its caught in >>> some kind of endless loop. It flashes constantly as if refreshing the >>> paramters list, locks up Visual Studio completely, and continues to >>> consume memory. I end up having to kill devenv.exe in the task manager >>> to get anything done >>> >>> Is there a fix for this? >>> >>> I'm using VIsual Studio 2003 and Sql Server Reporting Services Developer >>> Edition SP2. >>> >>> I can provide a sample dataset and rdl file to Microsoft if it becomes >>> necessary. >>> >>> Thanks, >>> Chris McKenzie >>> >> >> > >
I don't have any dependencies between report parameters. That's a good idea
though. Chris [quoted text, click to view] "Ben Sullins" <BenSullins@discussions.microsoft.com> wrote in message news:D7651D4B-64AF-4C20-B455-5F49D1922295@microsoft.com... >I also have had this problem...From what I've learned it seems to be a > problem w/ report parameters being out of order when depending on one > another... > > try changing around the order of the parameters... > > Cheers! > Ben Sullins > > "Bruce L-C [MVP]" wrote: > >> I'll try to find a report of mine that does this and see if it still does >> it >> in RS 2005. >> >> >> -- >> Bruce Loehle-Conger >> MVP SQL Server Reporting Services >> >> "Chris McKenzie" <crmckenzie@gmail.com> wrote in message >> news:ujnns92vFHA.1560@TK2MSFTNGP09.phx.gbl... >> > Aye, that's what I ended up having to do to get my work done. Do you >> > know >> > if this is a known bug? >> > >> > Chris >> > >> > "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message >> > news:OqJ4ynvvFHA.3400@TK2MSFTNGP14.phx.gbl... >> >>I have had that on occasion. The good news is it is only a problem in >> >>design, it will work in production. When I have a report that does this >> >>I >> >>deploy and test and don't use the preview in the designer. At least it >> >>is >> >>a workaround. I haven't tried this in RS 2005 to see if the problem >> >>went >> >>away. >> >> >> >> >> >> -- >> >> Bruce Loehle-Conger >> >> MVP SQL Server Reporting Services >> >> >> >> "Chris McKenzie" <crmckenzie@gmail.com> wrote in message >> >> news:eE00LavvFHA.3256@TK2MSFTNGP09.phx.gbl... >> >>> I'm having a serious problem with the Reporting Services designer. I >> >>> have a report with 2 parameters offered as dropdown lists. The first >> >>> time I go into the designer, I can change the value of the >> >>> dropdownlists >> >>> (with some flashing behavior that doesn't make sense) and execute the >> >>> report. However, if I go back to the layout tab and then return to >> >>> the >> >>> Preview tab and do the same thing, the designer acts like its caught >> >>> in >> >>> some kind of endless loop. It flashes constantly as if refreshing the >> >>> paramters list, locks up Visual Studio completely, and continues to >> >>> consume memory. I end up having to kill devenv.exe in the task >> >>> manager >> >>> to get anything done >> >>> >> >>> Is there a fix for this? >> >>> >> >>> I'm using VIsual Studio 2003 and Sql Server Reporting Services >> >>> Developer >> >>> Edition SP2. >> >>> >> >>> I can provide a sample dataset and rdl file to Microsoft if it >> >>> becomes >> >>> necessary. >> >>> >> >>> Thanks, >> >>> Chris McKenzie >> >>> >> >> >> >> >> > >> > >> >> >>
Any more ideas? This is causing me a ton of grief. I have multiple
parameters that depend on the previous parameter or parameters and can not get it to work no matter what order of parameters I use. Gary [quoted text, click to view] Chris McKenzie wrote:
> I don't have any dependencies between report parameters. That's a good idea > though. > > Chris > > "Ben Sullins" <BenSullins@discussions.microsoft.com> wrote in message > news:D7651D4B-64AF-4C20-B455-5F49D1922295@microsoft.com... > >I also have had this problem...From what I've learned it seems to be a > > problem w/ report parameters being out of order when depending on one > > another... > > > > try changing around the order of the parameters... > > > > Cheers! > > Ben Sullins > > > > "Bruce L-C [MVP]" wrote: > > > >> I'll try to find a report of mine that does this and see if it still does > >> it > >> in RS 2005. > >> > >> > >> -- > >> Bruce Loehle-Conger > >> MVP SQL Server Reporting Services > >> > >> "Chris McKenzie" <crmckenzie@gmail.com> wrote in message > >> news:ujnns92vFHA.1560@TK2MSFTNGP09.phx.gbl... > >> > Aye, that's what I ended up having to do to get my work done. Do you > >> > know > >> > if this is a known bug? > >> > > >> > Chris > >> > > >> > "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message > >> > news:OqJ4ynvvFHA.3400@TK2MSFTNGP14.phx.gbl... > >> >>I have had that on occasion. The good news is it is only a problem in > >> >>design, it will work in production. When I have a report that does this > >> >>I > >> >>deploy and test and don't use the preview in the designer. At least it > >> >>is > >> >>a workaround. I haven't tried this in RS 2005 to see if the problem > >> >>went > >> >>away. > >> >> > >> >> > >> >> -- > >> >> Bruce Loehle-Conger > >> >> MVP SQL Server Reporting Services > >> >> > >> >> "Chris McKenzie" <crmckenzie@gmail.com> wrote in message > >> >> news:eE00LavvFHA.3256@TK2MSFTNGP09.phx.gbl... > >> >>> I'm having a serious problem with the Reporting Services designer. I > >> >>> have a report with 2 parameters offered as dropdown lists. The first > >> >>> time I go into the designer, I can change the value of the > >> >>> dropdownlists > >> >>> (with some flashing behavior that doesn't make sense) and execute the > >> >>> report. However, if I go back to the layout tab and then return to > >> >>> the > >> >>> Preview tab and do the same thing, the designer acts like its caught > >> >>> in > >> >>> some kind of endless loop. It flashes constantly as if refreshing the > >> >>> paramters list, locks up Visual Studio completely, and continues to > >> >>> consume memory. I end up having to kill devenv.exe in the task > >> >>> manager > >> >>> to get anything done > >> >>> > >> >>> Is there a fix for this? > >> >>> > >> >>> I'm using VIsual Studio 2003 and Sql Server Reporting Services > >> >>> Developer > >> >>> Edition SP2. > >> >>> > >> >>> I can provide a sample dataset and rdl file to Microsoft if it > >> >>> becomes > >> >>> necessary. > >> >>> > >> >>> Thanks, > >> >>> Chris McKenzie > >> >>> > >> >> > >> >> > >> > > >> > > >> > >> > >>
Any more ideas? This is causing me a ton of grief. I have multiple
parameters that depend on the previous parameter or parameters and can not get it to work no matter what order of parameters I use. Gary [quoted text, click to view] Chris McKenzie wrote:
> I don't have any dependencies between report parameters. That's a good idea > though. > > Chris > > "Ben Sullins" <BenSullins@discussions.microsoft.com> wrote in message > news:D7651D4B-64AF-4C20-B455-5F49D1922295@microsoft.com... > >I also have had this problem...From what I've learned it seems to be a > > problem w/ report parameters being out of order when depending on one > > another... > > > > try changing around the order of the parameters... > > > > Cheers! > > Ben Sullins > > > > "Bruce L-C [MVP]" wrote: > > > >> I'll try to find a report of mine that does this and see if it still does > >> it > >> in RS 2005. > >> > >> > >> -- > >> Bruce Loehle-Conger > >> MVP SQL Server Reporting Services > >> > >> "Chris McKenzie" <crmckenzie@gmail.com> wrote in message > >> news:ujnns92vFHA.1560@TK2MSFTNGP09.phx.gbl... > >> > Aye, that's what I ended up having to do to get my work done. Do you > >> > know > >> > if this is a known bug? > >> > > >> > Chris > >> > > >> > "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message > >> > news:OqJ4ynvvFHA.3400@TK2MSFTNGP14.phx.gbl... > >> >>I have had that on occasion. The good news is it is only a problem in > >> >>design, it will work in production. When I have a report that does this > >> >>I > >> >>deploy and test and don't use the preview in the designer. At least it > >> >>is > >> >>a workaround. I haven't tried this in RS 2005 to see if the problem > >> >>went > >> >>away. > >> >> > >> >> > >> >> -- > >> >> Bruce Loehle-Conger > >> >> MVP SQL Server Reporting Services > >> >> > >> >> "Chris McKenzie" <crmckenzie@gmail.com> wrote in message > >> >> news:eE00LavvFHA.3256@TK2MSFTNGP09.phx.gbl... > >> >>> I'm having a serious problem with the Reporting Services designer. I > >> >>> have a report with 2 parameters offered as dropdown lists. The first > >> >>> time I go into the designer, I can change the value of the > >> >>> dropdownlists > >> >>> (with some flashing behavior that doesn't make sense) and execute the > >> >>> report. However, if I go back to the layout tab and then return to > >> >>> the > >> >>> Preview tab and do the same thing, the designer acts like its caught > >> >>> in > >> >>> some kind of endless loop. It flashes constantly as if refreshing the > >> >>> paramters list, locks up Visual Studio completely, and continues to > >> >>> consume memory. I end up having to kill devenv.exe in the task > >> >>> manager > >> >>> to get anything done > >> >>> > >> >>> Is there a fix for this? > >> >>> > >> >>> I'm using VIsual Studio 2003 and Sql Server Reporting Services > >> >>> Developer > >> >>> Edition SP2. > >> >>> > >> >>> I can provide a sample dataset and rdl file to Microsoft if it > >> >>> becomes > >> >>> necessary. > >> >>> > >> >>> Thanks, > >> >>> Chris McKenzie > >> >>> > >> >> > >> >> > >> > > >> > > >> > >> > >>
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 |