Can't Get a Hidden Parameter to Work

I am running 2000 with SP1.
Here's what I've tried so far.
I specified no prompt in the designer (put a blank) and deployed the report.
I got the following error: Parameter validation failed. It is not possible
to provide valid values for all parameters.
I then deleted the prompt in the Report Manager and tried again. It did not
work. I then unchecked the Prompt User box, and it still did not work. In
fact, it kept filling in the prompt field with the name of the parameter.
Therefore, I had to leave the Prompt User box checked. However, for both
scenarios, I got the following error: This report requires a default or
user-defined value for the report parameter 'EmployeeId'. To run or subscribe
to this report, you must provide a parameter value.
Here is the query string I used (not using SSL yet; still testing on my own
machine):
http://<computer
name>/Reports/Pages/Report.aspx?ItemPath=/Emileage/Emileage_Aging_Report_ByEmployee&EmployeeId=0000103518
The EmployeeId is a string so I was not sure how to denote that. I have
tried this with quotes and without quotes around the EmployeeId value, and
neither works.
The employee id is the third parameter. Does it need to be the first one?
Any help would be greatly appreciated.
LizMy suggestion is to first get it working without being hidden.
Your URL is wrong. Don't use /reports use reportserver like this. It will
pull up the report but it will not if I remember correctly fill in your
parameters for you. /reports is reportmanager, the portal that ships with
RS. reportserver is the actual Reporting Services asp.net application.
http://server/reportserver?/Sales/Northwest/Employee Sales
Report&rs:Command=Render&EmployeeID=1234Also make sure your parameter name
matches your case exactly, it is (unfortunately) case sensitive.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Liz" <Liz@.discussions.microsoft.com> wrote in message
news:FB6DFF78-8495-44E0-91C5-E16D81F3BF57@.microsoft.com...
>I am running 2000 with SP1.
> Here's what I've tried so far.
> I specified no prompt in the designer (put a blank) and deployed the
> report.
> I got the following error: Parameter validation failed. It is not possible
> to provide valid values for all parameters.
> I then deleted the prompt in the Report Manager and tried again. It did
> not
> work. I then unchecked the Prompt User box, and it still did not work.
> In
> fact, it kept filling in the prompt field with the name of the parameter.
> Therefore, I had to leave the Prompt User box checked. However, for both
> scenarios, I got the following error: This report requires a default or
> user-defined value for the report parameter 'EmployeeId'. To run or
> subscribe
> to this report, you must provide a parameter value.
> Here is the query string I used (not using SSL yet; still testing on my
> own
> machine):
> http://<computer
> name>/Reports/Pages/Report.aspx?ItemPath=/Emileage/Emileage_Aging_Report_ByEmployee&EmployeeId=0000103518
> The EmployeeId is a string so I was not sure how to denote that. I have
> tried this with quotes and without quotes around the EmployeeId value, and
> neither works.
> The employee id is the third parameter. Does it need to be the first
> one?
> Any help would be greatly appreciated.
> Liz
>|||Yippee! That worked!!
Where can I get some more information on hidden parameters? I looked at the
Books Online but there is almost nothing on Reporting Services. I also have
"The Hitchhiker's Guide" which is a great book, but it doesn't have enough on
hidden parameters. I will, however, go and look at it again. I might get
more out of it this time:-)
Thanks so much!
Liz
"Bruce L-C [MVP]" wrote:
> My suggestion is to first get it working without being hidden.
> Your URL is wrong. Don't use /reports use reportserver like this. It will
> pull up the report but it will not if I remember correctly fill in your
> parameters for you. /reports is reportmanager, the portal that ships with
> RS. reportserver is the actual Reporting Services asp.net application.
> http://server/reportserver?/Sales/Northwest/Employee Sales
> Report&rs:Command=Render&EmployeeID=1234Also make sure your parameter name
> matches your case exactly, it is (unfortunately) case sensitive.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Liz" <Liz@.discussions.microsoft.com> wrote in message
> news:FB6DFF78-8495-44E0-91C5-E16D81F3BF57@.microsoft.com...
> >I am running 2000 with SP1.
> >
> > Here's what I've tried so far.
> >
> > I specified no prompt in the designer (put a blank) and deployed the
> > report.
> > I got the following error: Parameter validation failed. It is not possible
> > to provide valid values for all parameters.
> >
> > I then deleted the prompt in the Report Manager and tried again. It did
> > not
> > work. I then unchecked the Prompt User box, and it still did not work.
> > In
> > fact, it kept filling in the prompt field with the name of the parameter.
> > Therefore, I had to leave the Prompt User box checked. However, for both
> > scenarios, I got the following error: This report requires a default or
> > user-defined value for the report parameter 'EmployeeId'. To run or
> > subscribe
> > to this report, you must provide a parameter value.
> >
> > Here is the query string I used (not using SSL yet; still testing on my
> > own
> > machine):
> > http://<computer
> > name>/Reports/Pages/Report.aspx?ItemPath=/Emileage/Emileage_Aging_Report_ByEmployee&EmployeeId=0000103518
> >
> > The EmployeeId is a string so I was not sure how to denote that. I have
> > tried this with quotes and without quotes around the EmployeeId value, and
> > neither works.
> >
> > The employee id is the third parameter. Does it need to be the first
> > one?
> >
> > Any help would be greatly appreciated.
> >
> > Liz
> >
> >
>
>|||I suggest searching 2005 books on-line on the microsoft site. For things
like url integration absolutely nothing has changed between 2000 and 2005.
How you do hidden parameters I believe has changed. There are some new
features (multi-select parameters, end user sorting) but that does not
affect URL integration. They have lots of good documentation on URL
integration (was not there in the 2000 docs).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Liz" <Liz@.discussions.microsoft.com> wrote in message
news:E328C5E9-1894-4C6F-AB8A-20904F1527D6@.microsoft.com...
> Yippee! That worked!!
> Where can I get some more information on hidden parameters? I looked at
> the
> Books Online but there is almost nothing on Reporting Services. I also
> have
> "The Hitchhiker's Guide" which is a great book, but it doesn't have enough
> on
> hidden parameters. I will, however, go and look at it again. I might get
> more out of it this time:-)
> Thanks so much!
> Liz
> "Bruce L-C [MVP]" wrote:
>> My suggestion is to first get it working without being hidden.
>> Your URL is wrong. Don't use /reports use reportserver like this. It will
>> pull up the report but it will not if I remember correctly fill in your
>> parameters for you. /reports is reportmanager, the portal that ships with
>> RS. reportserver is the actual Reporting Services asp.net application.
>> http://server/reportserver?/Sales/Northwest/Employee Sales
>> Report&rs:Command=Render&EmployeeID=1234Also make sure your parameter
>> name
>> matches your case exactly, it is (unfortunately) case sensitive.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Liz" <Liz@.discussions.microsoft.com> wrote in message
>> news:FB6DFF78-8495-44E0-91C5-E16D81F3BF57@.microsoft.com...
>> >I am running 2000 with SP1.
>> >
>> > Here's what I've tried so far.
>> >
>> > I specified no prompt in the designer (put a blank) and deployed the
>> > report.
>> > I got the following error: Parameter validation failed. It is not
>> > possible
>> > to provide valid values for all parameters.
>> >
>> > I then deleted the prompt in the Report Manager and tried again. It
>> > did
>> > not
>> > work. I then unchecked the Prompt User box, and it still did not work.
>> > In
>> > fact, it kept filling in the prompt field with the name of the
>> > parameter.
>> > Therefore, I had to leave the Prompt User box checked. However, for
>> > both
>> > scenarios, I got the following error: This report requires a default
>> > or
>> > user-defined value for the report parameter 'EmployeeId'. To run or
>> > subscribe
>> > to this report, you must provide a parameter value.
>> >
>> > Here is the query string I used (not using SSL yet; still testing on my
>> > own
>> > machine):
>> > http://<computer
>> > name>/Reports/Pages/Report.aspx?ItemPath=/Emileage/Emileage_Aging_Report_ByEmployee&EmployeeId=0000103518
>> >
>> > The EmployeeId is a string so I was not sure how to denote that. I
>> > have
>> > tried this with quotes and without quotes around the EmployeeId value,
>> > and
>> > neither works.
>> >
>> > The employee id is the third parameter. Does it need to be the first
>> > one?
>> >
>> > Any help would be greatly appreciated.
>> >
>> > Liz
>> >
>> >
>>

Can't find Report Designer

I think I've installed all of the required pieces (SRS, already had VS.NET
2005 installed, BI tools). But the BI tools (e.g. Report Designer) don't
appear on a menu anywhere, and the desired project type for reports doesn't
appear in VS.NET.
What might I have done wrong?
Thanks.
--
Dan Cooperstock
DONATION web site: http://www.FreeDonationSoftware.org
DONATION Support forums: http://forums.FreeDonationSoftware.org
E-mail: mailto:info@.FreeDonationSoftware.org
Home Phone: 416-423-9064If report designer was installed before VS 2005 then it will not be
integrated (that happened to me). Reinstall Report Designer from the SQL
Server 2005 media.
Note that RS 2005 comes with a version of VS so you did not have to have VS
2005 (this is different than the case with RS 2000).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dan Cooperstock" <dancoo@.newsgroups.nospam> wrote in message
news:Xns9876ADBF155ACdcoopssympaticoca@.207.46.248.16...
>I think I've installed all of the required pieces (SRS, already had VS.NET
> 2005 installed, BI tools). But the BI tools (e.g. Report Designer) don't
> appear on a menu anywhere, and the desired project type for reports
> doesn't
> appear in VS.NET.
> What might I have done wrong?
> Thanks.
>
> --
> Dan Cooperstock
> DONATION web site: http://www.FreeDonationSoftware.org
> DONATION Support forums: http://forums.FreeDonationSoftware.org
> E-mail: mailto:info@.FreeDonationSoftware.org
> Home Phone: 416-423-9064|||"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
news:eNhaYvEBHHA.3836@.TK2MSFTNGP02.phx.gbl:
> If report designer was installed before VS 2005 then it will not be
> integrated (that happened to me). Reinstall Report Designer from the
> SQL Server 2005 media.
> Note that RS 2005 comes with a version of VS so you did not have to
> have VS 2005 (this is different than the case with RS 2000).
>
Nope, VS.NET 2005 was installed first. I have tried installing SQL Server
(including Report Designer - via BI tools) a few times now, and nothing
appears in VS.NET.
Dan Cooperstock
DONATION web site: http://www.FreeDonationSoftware.org
DONATION Support forums: http://forums.FreeDonationSoftware.org
E-mail: mailto:info@.FreeDonationSoftware.org
Home Phone: 416-423-9064|||Not sure what to say except to make sure you are doing client tools instead
of the server but it sounds like you are doing that.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dan Cooperstock" <dancoo@.newsgroups.nospam> wrote in message
news:Xns9876B678377E8dcoopssympaticoca@.207.46.248.16...
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
> news:eNhaYvEBHHA.3836@.TK2MSFTNGP02.phx.gbl:
>> If report designer was installed before VS 2005 then it will not be
>> integrated (that happened to me). Reinstall Report Designer from the
>> SQL Server 2005 media.
>> Note that RS 2005 comes with a version of VS so you did not have to
>> have VS 2005 (this is different than the case with RS 2000).
>>
> Nope, VS.NET 2005 was installed first. I have tried installing SQL Server
> (including Report Designer - via BI tools) a few times now, and nothing
> appears in VS.NET.
>
> --
> Dan Cooperstock
> DONATION web site: http://www.FreeDonationSoftware.org
> DONATION Support forums: http://forums.FreeDonationSoftware.org
> E-mail: mailto:info@.FreeDonationSoftware.org
> Home Phone: 416-423-9064|||Hello Dan,
Would you please try to check whether you have the Business Intelligence
Projects under the folder
%Program Files%\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies ?
Also, please let me know your Visual Studio version.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||weilu@.online.microsoft.com (Wei Lu [MSFT]) wrote in news:ghfrDiJBHHA.4432
@.TK2MSFTNGXA01.phx.gbl:
> Please check you have the Business Intelligence projects under
> Program Files/Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies
The only thing I see there that looks relevant is
Microsoft.ReportDesigner.dll.
I can also clarify that while I don't see the project types when I go to
add a new Project to the solution (which the installer suggested I should I
have) I did discover that under adding a new Item to a project, I do have
Report, and it is indeed an SRS Report that it creates.
Dan Cooperstock
DONATION web site: http://www.FreeDonationSoftware.org
DONATION Support forums: http://forums.FreeDonationSoftware.org
E-mail: mailto:info@.FreeDonationSoftware.org
Home Phone: 416-423-9064|||When you do New Project you should have Business Intelligence Projects as a
choice.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dan Cooperstock" <dancoo@.newsgroups.nospam> wrote in message
news:Xns987755AA3C448dcoopssympaticoca@.207.46.248.16...
> weilu@.online.microsoft.com (Wei Lu [MSFT]) wrote in news:ghfrDiJBHHA.4432
> @.TK2MSFTNGXA01.phx.gbl:
>> Please check you have the Business Intelligence projects under
>> Program Files/Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies
> The only thing I see there that looks relevant is
> Microsoft.ReportDesigner.dll.
> I can also clarify that while I don't see the project types when I go to
> add a new Project to the solution (which the installer suggested I should
> I
> have) I did discover that under adding a new Item to a project, I do have
> Report, and it is indeed an SRS Report that it creates.
>
> --
> Dan Cooperstock
> DONATION web site: http://www.FreeDonationSoftware.org
> DONATION Support forums: http://forums.FreeDonationSoftware.org
> E-mail: mailto:info@.FreeDonationSoftware.org
> Home Phone: 416-423-9064|||"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
news:unK9bGNBHHA.3560@.TK2MSFTNGP03.phx.gbl:
> When you do New Project you should have Business Intelligence Projects
> as a choice.
>
Yes, I agree that I should. But I don't. The fact that I don't is what led
me to post about this in the first place!
Dan Cooperstock
DONATION web site: http://www.FreeDonationSoftware.org
DONATION Support forums: http://forums.FreeDonationSoftware.org
E-mail: mailto:info@.FreeDonationSoftware.org
Home Phone: 416-423-9064|||I have had people doing things with VS 2005 thinking they were using the
report designer when really they were dealing with the new controls (which
also allow designing reports). You wouldn't believe how many times people
have not installed from the SQL Server media the client BI tools. That is
why I am making sure.
I had exactly what you are talking about happen but it appeared when I
re-installed. Have you tried removing (not just re-installing) but first
removing the BI tools and then re-installing.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dan Cooperstock" <dancoo@.newsgroups.nospam> wrote in message
news:Xns9877DF702FAE7dcoopssympaticoca@.207.46.248.16...
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
> news:unK9bGNBHHA.3560@.TK2MSFTNGP03.phx.gbl:
>> When you do New Project you should have Business Intelligence Projects
>> as a choice.
>>
> Yes, I agree that I should. But I don't. The fact that I don't is what led
> me to post about this in the first place!
>
> --
> Dan Cooperstock
> DONATION web site: http://www.FreeDonationSoftware.org
> DONATION Support forums: http://forums.FreeDonationSoftware.org
> E-mail: mailto:info@.FreeDonationSoftware.org
> Home Phone: 416-423-9064|||"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
news:uZSipgaBHHA.4592@.TK2MSFTNGP03.phx.gbl:
> I have had people doing things with VS 2005 thinking they were using
> the report designer when really they were dealing with the new
> controls (which also allow designing reports). You wouldn't believe
> how many times people have not installed from the SQL Server media the
> client BI tools. That is why I am making sure.
> I had exactly what you are talking about happen but it appeared when I
> re-installed. Have you tried removing (not just re-installing) but
> first removing the BI tools and then re-installing.
>
Yes, uninstalling my whole SQL Server installation and then re-installing
it fixed it - I now have the Business Intelligence projects.
Thanks!
--
Dan Cooperstock
DONATION web site: http://www.FreeDonationSoftware.org
DONATION Support forums: http://forums.FreeDonationSoftware.org
E-mail: mailto:info@.FreeDonationSoftware.org
Home Phone: 416-423-9064|||Good. Glad it is fixed.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dan Cooperstock" <dancoo@.newsgroups.nospam> wrote in message
news:Xns987892BF57C28dcoopssympaticoca@.207.46.248.16...
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
> news:uZSipgaBHHA.4592@.TK2MSFTNGP03.phx.gbl:
>> I have had people doing things with VS 2005 thinking they were using
>> the report designer when really they were dealing with the new
>> controls (which also allow designing reports). You wouldn't believe
>> how many times people have not installed from the SQL Server media the
>> client BI tools. That is why I am making sure.
>> I had exactly what you are talking about happen but it appeared when I
>> re-installed. Have you tried removing (not just re-installing) but
>> first removing the BI tools and then re-installing.
> Yes, uninstalling my whole SQL Server installation and then re-installing
> it fixed it - I now have the Business Intelligence projects.
> Thanks!
> --
> Dan Cooperstock
> DONATION web site: http://www.FreeDonationSoftware.org
> DONATION Support forums: http://forums.FreeDonationSoftware.org
> E-mail: mailto:info@.FreeDonationSoftware.org
> Home Phone: 416-423-9064

Can't delete or overwrite report

When I try to delete this report from the admin it times out, same if I try
to republish from the report designer. I am admin on the box and in reporting
services.
Error looks like:
System.Web.Services.Protocols.SoapException: Server was unable to process
request. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding. at
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior,
RunBehavior runBehavior, Boolean returnStream) at
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at
Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Library.DBInterface.DeleteObject(String
objectName) at
Microsoft.ReportingServices.Library.RSService._DeleteItem(String item) at
Microsoft.ReportingServices.Library.RSService.DeleteItem(CallParameters
parameters) at
Microsoft.ReportingServices.Library.RSService.ExecuteBatch(Guid batchId) at
Microsoft.ReportingServices.WebServer.ReportingService.ExecuteBatch() --
End of inner exception stack trace --
How can I delete the report?I have the exact same problem. I can move the report to another folder but
any attempt to delete it or overwrite it via Designer results in the Server
going to 100% CPU utilisation and everything grinding to a halt until the
timeout error below appears.
Can someone please help us? Thanks.
"bmurtha" wrote:
> When I try to delete this report from the admin it times out, same if I try
> to republish from the report designer. I am admin on the box and in reporting
> services.
> Error looks like:
> System.Web.Services.Protocols.SoapException: Server was unable to process
> request. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server is
> not responding. at
> System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior,
> RunBehavior runBehavior, Boolean returnStream) at
> System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at
> Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery()
> at Microsoft.ReportingServices.Library.DBInterface.DeleteObject(String
> objectName) at
> Microsoft.ReportingServices.Library.RSService._DeleteItem(String item) at
> Microsoft.ReportingServices.Library.RSService.DeleteItem(CallParameters
> parameters) at
> Microsoft.ReportingServices.Library.RSService.ExecuteBatch(Guid batchId) at
> Microsoft.ReportingServices.WebServer.ReportingService.ExecuteBatch() --
> End of inner exception stack trace --
> How can I delete the report?|||I finally deleted the culprit report by removing it from the ReportServer
database. First identify the datasource it is using and then delete the
datasource from this table:
reportserver.dbo.[datasource]
If it's shared you will have to recreate it again afterwards.
Then delete the offending report from:
reportserver.dbo.[catalog]
That did it for me, but obviously I have no idea what the consequences might
be!
"bmurtha" wrote:
> When I try to delete this report from the admin it times out, same if I try
> to republish from the report designer. I am admin on the box and in reporting
> services.
> Error looks like:
> System.Web.Services.Protocols.SoapException: Server was unable to process
> request. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server is
> not responding. at
> System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior,
> RunBehavior runBehavior, Boolean returnStream) at
> System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at
> Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery()
> at Microsoft.ReportingServices.Library.DBInterface.DeleteObject(String
> objectName) at
> Microsoft.ReportingServices.Library.RSService._DeleteItem(String item) at
> Microsoft.ReportingServices.Library.RSService.DeleteItem(CallParameters
> parameters) at
> Microsoft.ReportingServices.Library.RSService.ExecuteBatch(Guid batchId) at
> Microsoft.ReportingServices.WebServer.ReportingService.ExecuteBatch() --
> End of inner exception stack trace --
> How can I delete the report?