Parameters not getting refreshed?

Hi All,

I am getting some wierd problem in my reports. I have deployed several reports on the server and when I am giving some parameters for the report, it does not take it and runs the report on complete database. What can be the reason.?

Few days ago, everything was working fine.

I was using a separate datasource for each report. But then I created a shared datasource. Can that be the reason?

Please help me out !!!

TIA

I have had this happen to me before as well, generally I have found it is because within the dataset for the report, the parameters have been dropped. to check, go to the Data tab for the report in VS, edit the selected dataset by clicking the "..." button

Then go to the parameters tab, make sure your parameters are displayed in there.

|||Another alternative to determining whether or not your parameters are functioning properly is to click out of the design mode and view the MDX query. There will be a "Query Parameters" button in the toolbar directly to the left of the "Prepare Query" and "Execute Query" buttons.

Parameters I add to URL do not do anything

I am new to reporting services. I'm using 2005. I have some reports
deployed and working. When I go to them directly by URL with some parameters
in the URL, the parameters don't do anything. I've tried some of the built
in rc parameters and my own parameter values. Is there a setting I'm
missing or something? Thanks.My guess is you are going to Reports instead of ResportServer. Reports is
the portal that ships with RS. ReportServer is the asp.net application that
is Report Server.
Books Online has lots of good examples. Look for URL Access (if you are on
RS 2000 then look on the Books Online on the microsoft site (i.e. RS 2005
Books Online, URL integration is the same).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"jlmjr" <jlmjr@.discussions.microsoft.com> wrote in message
news:74438560-1960-4900-A165-E87B1A94E1F3@.microsoft.com...
>I am new to reporting services. I'm using 2005. I have some reports
> deployed and working. When I go to them directly by URL with some
> parameters
> in the URL, the parameters don't do anything. I've tried some of the
> built
> in rc parameters and my own parameter values. Is there a setting I'm
> missing or something? Thanks.|||That's what I needed to know. Thanks!
"Bruce L-C [MVP]" wrote:
> My guess is you are going to Reports instead of ResportServer. Reports is
> the portal that ships with RS. ReportServer is the asp.net application that
> is Report Server.
> Books Online has lots of good examples. Look for URL Access (if you are on
> RS 2000 then look on the Books Online on the microsoft site (i.e. RS 2005
> Books Online, URL integration is the same).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "jlmjr" <jlmjr@.discussions.microsoft.com> wrote in message
> news:74438560-1960-4900-A165-E87B1A94E1F3@.microsoft.com...
> >I am new to reporting services. I'm using 2005. I have some reports
> > deployed and working. When I go to them directly by URL with some
> > parameters
> > in the URL, the parameters don't do anything. I've tried some of the
> > built
> > in rc parameters and my own parameter values. Is there a setting I'm
> > missing or something? Thanks.
>
>

Parameters are disabled

I've set three parameters in the reports. However, when it is deployed, the
three parameters (textbox & dropdown list) become disabled? Is there
anything that need to set to make it enable?
Please advise.On Dec 2, 10:12 pm, YeungTakYan
<YeungTak...@.discussions.microsoft.com> wrote:
> I've set three parameters in the reports. However, when it is deployed, the
> three parameters (textbox & dropdown list) become disabled? Is there
> anything that need to set to make it enable?
> Please advise.
Are you using a different datasource for the parameters than you are
for the report itself? If so, make sure that the datasource is
available in the Report Manager on the production server. Also, by
default, the datasource for the report when it is first deployed is
not set. You normally set it by selecting the Properties tab (I
believe it is) and then select Datasources and select the datasource
from the top. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant