Reporting Services Designer problem

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 McKenzieI 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
>|||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
"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 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
> >>
> >>
> >>
> >
> >
>
>|||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
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
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
> >> >>
> >> >>
> >> >>
> >> >
> >> >
> >>
> >>
> >>