Reporting Services SP1 Designer Cache Problem

Reporting Service SP1 provides an option to cache the data during
design time for preview, which seems to be making the preview to take
lot longer time than pre SP1.
This is what Reporting Services SP1 is doing:
During preview it is making a call to SQL and in between it is writing
into report data file, which is taking longer time just because it is
reading and writing into data file before even rendering.
Why can't it cache the data after it gets the entire data instead of
holding the sql connection or after rendering?
One of my reports is used to take 10 secs prior to SP1 now it is
taking 6 mins.
After turning of the configuration to false we started getting the
report in 10 secs.
Is there any resolution for this?
Thanks
RI have a couple of questions. Does this type of performance difference
occur for all reports or just this one? What is the structure of the data:
number of rows returned, etc. I would expect caching to take longer but not
in the magnitude you are describing.
The report is cached and rendered as we get the data (it is not buffered).
On the surface it seems quite in efficient to render the report and then
potentially round trip to the server again. Buffering is an issue since we
do not know the size of result set in advance.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"am_i_dotnet" <am_i_dotnet@.hotmail.com> wrote in message
news:ac7b2754.0407151240.2374c78b@.posting.google.com...
> Reporting Service SP1 provides an option to cache the data during
> design time for preview, which seems to be making the preview to take
> lot longer time than pre SP1.
> This is what Reporting Services SP1 is doing:
> During preview it is making a call to SQL and in between it is writing
> into report data file, which is taking longer time just because it is
> reading and writing into data file before even rendering.
> Why can't it cache the data after it gets the entire data instead of
> holding the sql connection or after rendering?
> One of my reports is used to take 10 secs prior to SP1 now it is
> taking 6 mins.
> After turning of the configuration to false we started getting the
> report in 10 secs.
> Is there any resolution for this?
> Thanks
> R|||There are around 20000+ records in this report and the report is in
tabular format.
I may not agree with you on "The report is cached and rendered as we
get the data". Because I observed the data file keep growing when I
tried to preview the report and report showed up only after the entire
data file created.
I know it is inefficient to make second round trip to server just to
cache the data but do we have any thoughts on using the data in the
report. I mean first render the report and cache the data
asynchronously from report data.
Thanks
R
"Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> wrote in message news:<#dyED4qaEHA.3684@.TK2MSFTNGP09.phx.gbl>...
> I have a couple of questions. Does this type of performance difference
> occur for all reports or just this one? What is the structure of the data:
> number of rows returned, etc. I would expect caching to take longer but not
> in the magnitude you are describing.
> The report is cached and rendered as we get the data (it is not buffered).
> On the surface it seems quite in efficient to render the report and then
> potentially round trip to the server again. Buffering is an issue since we
> do not know the size of result set in advance.
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "am_i_dotnet" <am_i_dotnet@.hotmail.com> wrote in message
> news:ac7b2754.0407151240.2374c78b@.posting.google.com...
> > Reporting Service SP1 provides an option to cache the data during
> > design time for preview, which seems to be making the preview to take
> > lot longer time than pre SP1.
> >
> > This is what Reporting Services SP1 is doing:
> > During preview it is making a call to SQL and in between it is writing
> > into report data file, which is taking longer time just because it is
> > reading and writing into data file before even rendering.
> >
> > Why can't it cache the data after it gets the entire data instead of
> > holding the sql connection or after rendering?
> >
> > One of my reports is used to take 10 secs prior to SP1 now it is
> > taking 6 mins.
> >
> > After turning of the configuration to false we started getting the
> > report in 10 secs.
> >
> > Is there any resolution for this?
> >
> > Thanks
> > R

Reporting Services Query designer toolbar disabled

Hi to all , i'm trying to modify an mdx generated by query designer in "Design" mode.
I would like to switch to query designer in "Query" mode but the query designer toolbar and its button "Change Type" appears to be disabled.
In this project i use a shared data source and the data source type is Analysis Services.
In another project I followed the first basic Tutorial on Reporting Service ("Sales Order" report) so data source it's SQL Server and query designer it is locked to Query Mode and i cannot change it to Design Mode.
Thanks for help.
Alberto De MarcoI'm not sure which buttons you are referring to. Could you attach a picture of what you are seeing?

-Albert

Reporting Services Query designer toolbar disabled

Hi to all , i'm trying to modify an mdx generated by query designer in "Design" mode.
I would like to switch to query designer in "Query" mode but the query designer toolbar and its button "Change Type" appears to be disabled.
In this project i use a shared data source and the data source type is Analysis Services.
In another project I followed the first basic Tutorial on Reporting Service ("Sales Order" report) so data source it's SQL Server and query designer it is locked to Query Mode and i cannot change it to Design Mode.
Thanks for help.
Alberto De MarcoI'm not sure which buttons you are referring to. Could you attach a picture of what you are seeing?

-Albert

Reporting services passing parameters

I have a report that is link from another report, I've created this link in the report designer by using the rightclick textbox>select properties>Navigation tab > jump to report.

Now I have passed 4 parameters over to the new report, these are hidden and shouldn't be seen by the user. There is however a fifth parameter that should be set by the user at run time, as this controls what the report shows. This works perfectly when I'm in the designer using the preview tab. However once I upload the report to the server, I get an error message saying that the fifth parameter is missing a value! Even though in report manager the fifth parameter is set to prompt User, it will not display a prompt and allow a user to input the data, it just says that the parameter is missing a value and that's as far as it gets.

I think this must have something to do with how report manager renders the parameters of a report but I can't seem to find any information on it anywhere. Can anyone help at all?

Hi James,
Two days ago I encountered the same issue with one of my reports. On the local designer studio everything worked fine and as soon as I uploaded it to Report Manager the parameter was not prompting for value but kept on complaining.
All I had to do was, save the report locally, reboot the machine and upload it again. I know its a crazy answer but it worked for me. On a hindsight, I guess it was caused by RDL file not getting updated or getting corrupt for some reason.
HTH
Uday
|||

Cheers hedgeu

I tried that though and it's still not working, i'm not sure if it's the way that i'm passing the parameters or weather it's a rendering problem all i know is i can't seem to get it to work.

James

|||

I'm not sure if this will fix your problem, but I have an idea you can try if you are still stuck.

Go to: http://localhost/Reports (keep in mind this is a different location from ReportServer)

Find the report which is accepting the parameters (ie, the one in which the user should enter a value for the parameter) and open the report.

Now, at the top of the page, click "Properties". Then select "Parameters"

Verify that your fifth parameter has a check for the prompt user option and that the hidden checkbox is not selected.

Once that is fixed, you should be good to go. Try to link to that report now.

reporting services oracle connection

I have SQL Server 2005 Enterprise edition setup. I am creating reports with
oracle as the data source. I can make the connection in report designer and
preview the reports with no error. And also deploy them to the report server.
But when I try to view them through report manager I get an error
'A processing error has occurred. ORA-12154 TNS:could not resolve the
connect identifier specified '
Any suggestions?
Thanks!If you're developing reports on a workstation and they look good
locally, but error when you deploy, make sure the Oracle client on the
SSRS box is pointing to the correct Oracle Home directory. Best way to
do that is with the Oracle Network Config tool.
I've got mine setup to use the Oracle Supplied .Net 2.0 Connector and I
have to say that it is a much better connection than either OLE DB
Connector. Of course, you still need to setup TNS names correctly.
Garth H
webdev511@.spamcop.net
Microsoft Certified Professional
Macromedia Certified Developer

Reporting Services in VS 2005

I have installed Reporting Services as part of the SQL Server 2005 developer installation. I know Crystal Reports is installed as a report designer by default. How do I enable Reporting Services as a Report Designer in VS 2005? Does it install as part SQL Server 2005 client tools? In the previoius version, I believe there was a seperate client installation for Reporting Services in VS 2003..

Thanks!

dotnetnow

In RS2000 you had to use VS 2003 to build reports, now RS 2005 includes a Report Builder.http://msdn2.microsoft.com/en-us/library/ms155933(en-US,SQL.90).aspx|||

Thanks for the information.

Is the RS client part of the SQL Server 2005 client software installation?

Thanks again!

dotnetnow

Reporting services in 2005

Hi,

How do i get the "Data" "Layout" and "Preview" tabs in the report designer like displayed in Brian Welckers video "Report Authoring Tips and Tricks"

http://msdn.microsoft.com/msdntv/episode.aspx?xml=episodes/en/20050609SQLServerBW/manifest.xml

When I add a report to my project, all I get is the layout view.

When I click the menu Reports -> Data Dources, all I get is a list of my DataSources from my main project, I have no ability to Add a SQL server source, or OLEDB source, or even write a SQL statement like in the video.

Did I miss something I need when installing?

:-)It sounds like you need to install the "Workstation Components" from the SQL Server 2005 disk on the dev machine you're working on. A quick way to check is to look for the Business Intelligence Projects in the Add New Project dialogue, if it's not there, you need to install them.|||

When you use Visual Studio 2005 and SQL Server 2005 Reporting Services together, you have 2 options for desiging reports:
1) Using the WinForms or WebForms ReportViewer control in you application.
2) Using the Report Designer that installs with the workstation components of SQL Server 2005.

For #1 - you're actually adding an embedded report to your application. You need to provide data to the report that you author. This is the cause you're running into.

For #2 - if you want to publish a report to the report server, Peter is right, you'll need to install the Report Designer. The report designer includes the 3 panes for data, layout, and preview that you are accustomed to see in SQL Server 2000 Reporting Services.

Hope that helps,
-Lukasz

|||hello,
I have VS2005 installed along with RS 2000. I have developed reports using the report wizard. I have also uploaded the reports to the report server which is in a different location.
Now, my problem is when i use report viewer control to access the reports in the report server, I get this error message.

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.

The request failed with HTTP status 404: Not Found.|||

Hello,

I do have designer installed, but still it's abig difference between Woelcker's Training Designer Screen and mine.

For example, I don't see the image of the tables and joins.

Thanks,

Seva Akkerman

|||I just watched (a lot of) this video. When he set his list to be multi-value, his preview rendered with the select all.

In mine, I can set a multi-value parameter; but it won't show up until I deploy to the server.

Does anyone know what causes that?

Reporting services in 2005

Hi,

How do i get the "Data" "Layout" and "Preview" tabs in the report designer like displayed in Brian Welckers video "Report Authoring Tips and Tricks"

http://msdn.microsoft.com/msdntv/episode.aspx?xml=episodes/en/20050609SQLServerBW/manifest.xml

When I add a report to my project, all I get is the layout view.

When I click the menu Reports -> Data Dources, all I get is a list of my DataSources from my main project, I have no ability to Add a SQL server source, or OLEDB source, or even write a SQL statement like in the video.

Did I miss something I need when installing?

:-)It sounds like you need to install the "Workstation Components" from the SQL Server 2005 disk on the dev machine you're working on. A quick way to check is to look for the Business Intelligence Projects in the Add New Project dialogue, if it's not there, you need to install them.|||

When you use Visual Studio 2005 and SQL Server 2005 Reporting Services together, you have 2 options for desiging reports:
1) Using the WinForms or WebForms ReportViewer control in you application.
2) Using the Report Designer that installs with the workstation components of SQL Server 2005.

For #1 - you're actually adding an embedded report to your application. You need to provide data to the report that you author. This is the cause you're running into.

For #2 - if you want to publish a report to the report server, Peter is right, you'll need to install the Report Designer. The report designer includes the 3 panes for data, layout, and preview that you are accustomed to see in SQL Server 2000 Reporting Services.

Hope that helps,
-Lukasz

|||hello,
I have VS2005 installed along with RS 2000. I have developed reports using the report wizard. I have also uploaded the reports to the report server which is in a different location.
Now, my problem is when i use report viewer control to access the reports in the report server, I get this error message.

The

attempt to connect to the report server failed. Check your connection

information and that the report server is a compatible version.

The

request failed with HTTP status 404: Not Found.|||

Hello,

I do have designer installed, but still it's abig difference between Woelcker's Training Designer Screen and mine.

For example, I don't see the image of the tables and joins.

Thanks,

Seva Akkerman

|||I just watched (a lot of) this video. When he set his list to be multi-value, his preview rendered with the select all.

In mine, I can set a multi-value parameter; but it won't show up until I deploy to the server.

Does anyone know what causes that?

Reporting services in 2005

Hi,

How do i get the "Data" "Layout" and "Preview" tabs in the report designer like displayed in Brian Welckers video "Report Authoring Tips and Tricks"

http://msdn.microsoft.com/msdntv/episode.aspx?xml=episodes/en/20050609SQLServerBW/manifest.xml

When I add a report to my project, all I get is the layout view.

When I click the menu Reports -> Data Dources, all I get is a list of my DataSources from my main project, I have no ability to Add a SQL server source, or OLEDB source, or even write a SQL statement like in the video.

Did I miss something I need when installing?

:-)It sounds like you need to install the "Workstation Components" from the SQL Server 2005 disk on the dev machine you're working on. A quick way to check is to look for the Business Intelligence Projects in the Add New Project dialogue, if it's not there, you need to install them.|||

When you use Visual Studio 2005 and SQL Server 2005 Reporting Services together, you have 2 options for desiging reports:
1) Using the WinForms or WebForms ReportViewer control in you application.
2) Using the Report Designer that installs with the workstation components of SQL Server 2005.

For #1 - you're actually adding an embedded report to your application. You need to provide data to the report that you author. This is the cause you're running into.

For #2 - if you want to publish a report to the report server, Peter is right, you'll need to install the Report Designer. The report designer includes the 3 panes for data, layout, and preview that you are accustomed to see in SQL Server 2000 Reporting Services.

Hope that helps,
-Lukasz

|||hello,
I have VS2005 installed along with RS 2000. I have developed reports using the report wizard. I have also uploaded the reports to the report server which is in a different location.
Now, my problem is when i use report viewer control to access the reports in the report server, I get this error message.

The

attempt to connect to the report server failed. Check your connection

information and that the report server is a compatible version.

The

request failed with HTTP status 404: Not Found.|||

Hello,

I do have designer installed, but still it's abig difference between Woelcker's Training Designer Screen and mine.

For example, I don't see the image of the tables and joins.

Thanks,

Seva Akkerman

|||I just watched (a lot of) this video. When he set his list to be multi-value, his preview rendered with the select all.

In mine, I can set a multi-value parameter; but it won't show up until I deploy to the server.

Does anyone know what causes that?

Reporting services in 2005

Hi,

How do i get the "Data" "Layout" and "Preview" tabs in the report designer like displayed in Brian Welckers video "Report Authoring Tips and Tricks"

http://msdn.microsoft.com/msdntv/episode.aspx?xml=episodes/en/20050609SQLServerBW/manifest.xml

When I add a report to my project, all I get is the layout view.

When I click the menu Reports -> Data Dources, all I get is a list of my DataSources from my main project, I have no ability to Add a SQL server source, or OLEDB source, or even write a SQL statement like in the video.

Did I miss something I need when installing?

:-)It sounds like you need to install the "Workstation Components" from the SQL Server 2005 disk on the dev machine you're working on. A quick way to check is to look for the Business Intelligence Projects in the Add New Project dialogue, if it's not there, you need to install them.|||

When you use Visual Studio 2005 and SQL Server 2005 Reporting Services together, you have 2 options for desiging reports:
1) Using the WinForms or WebForms ReportViewer control in you application.
2) Using the Report Designer that installs with the workstation components of SQL Server 2005.

For #1 - you're actually adding an embedded report to your application. You need to provide data to the report that you author. This is the cause you're running into.

For #2 - if you want to publish a report to the report server, Peter is right, you'll need to install the Report Designer. The report designer includes the 3 panes for data, layout, and preview that you are accustomed to see in SQL Server 2000 Reporting Services.

Hope that helps,
-Lukasz

|||hello,
I have VS2005 installed along with RS 2000. I have developed reports using the report wizard. I have also uploaded the reports to the report server which is in a different location.
Now, my problem is when i use report viewer control to access the reports in the report server, I get this error message.

The

attempt to connect to the report server failed. Check your connection

information and that the report server is a compatible version.

The

request failed with HTTP status 404: Not Found.|||

Hello,

I do have designer installed, but still it's abig difference between Woelcker's Training Designer Screen and mine.

For example, I don't see the image of the tables and joins.

Thanks,

Seva Akkerman

|||I just watched (a lot of) this video. When he set his list to be multi-value, his preview rendered with the select all.

In mine, I can set a multi-value parameter; but it won't show up until I deploy to the server.

Does anyone know what causes that?

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

Reporting Services Designer Install/Product Key

We installed reporting services on our MS SBS Premium server. The
installation was fine, except that the machine doesn't have Visual Studio
tools. No worries-- since we plan to develop reports on client machines with
VS.
That's where the problem is: we can't install the RS designer on the client
machines with VS 2003. When we get to the product key page, we enter in the
same key that worked for the SBS-P machine, but no love. Message: "This is
an invalid Product Key value. Please check the number located on your Product
Key sticker." The number we enter is the same as both the sticker on the
server case and the reg key on the server.
What do I need to do to install the designer for VS?Anyone have a possible solution to the product key problem with Small
Business Server 2003 Premium?
"New to the game" wrote:
> We installed reporting services on our MS SBS Premium server. The
> installation was fine, except that the machine doesn't have Visual Studio
> tools. No worries-- since we plan to develop reports on client machines with
> VS.
> That's where the problem is: we can't install the RS designer on the client
> machines with VS 2003. When we get to the product key page, we enter in the
> same key that worked for the SBS-P machine, but no love. Message: "This is
> an invalid Product Key value. Please check the number located on your Product
> Key sticker." The number we enter is the same as both the sticker on the
> server case and the reg key on the server.
> What do I need to do to install the designer for VS?