Geeks With Blogs
Everything IT Programmer, SQL and Server Admin

After spending some time with Reporting Services over the past couple weeks, I have noticed a few issues that I find rather odd, at least in my opinion.

If you create a report and use a parameterized query, report services will nicely add the parameters to the report for you as well.  This is a great feature and I really like that aspect.

What is different however, is when you want to call that report from within an ASP.NET web application.  Ideally, you would like to be able to pass the values for the parameters in the URL. For the most part, this should not create any problems, but it does.

If you were to go into reporting services and view the report, you will not get any data returned until you enter the values required for the parameters in the SQL SELECT statement in your datasource.  This is by design as you have not told reporting services what you want returned yet.

The way that Reporting Services works in this case is to present you with two text boxes with appropriate labels allowing you to enter the parameters required by the SQL string.  Once you enter the values and view the report, your data displays.  You can also do this from within Visual Studio by selecting the Preview option in the report designer.  All seems to work well until you notice that when you run the report in the browser, you see the prompts at the top of the form for the parameters.  If you have passed in the values in the URL, the report should display properly but the values will also be displayed in the text boxes.  This is not desirable most times.

By going into Reporting Services directly in the browser, http://localhost/reports/Pages/Folder.aspx, you can set various properties of the report, one of which is to not prompt the user.  This is found under the Parameters link for the report you wish to work with.  I caution you, DO NOT do this.  Once you have set the prompt check boxes to cleared, your reports will now issue this infamous error;

Reporting Services Error

  • The report parameter 'paramnamehere' is read-only and cannot be modified. (rsReadOnlyReportParameter) Get Online Help

Microsoft Reporting Services

Click the Get Online Help link to find out that there is very little help available for this error message other than to say;

Explanation

This error occurs when you attempt to set a value for a parameter that is read-only.

   
User Action

Search Books Online for more information about the parameter. There are conditions that you can control that determine whether the parameter is read-only.


Currently there are no Microsoft Knowledge Base articles available for this specific error or event message. For information about other support options you can use to find answers online, see http://support.microsoft.com/default.aspx.

Nice?  NOT!

Here is what I have found to be the solution.  Go back into the report manager on your computer and set the Prompt User check boxes to checked.  Now, you still don't want the prompts to be displayed on the page because you are passing them in the URL. 

Go back to your project and select the report viewer control, if you are using it, and set the Parameters property to false.  If you are not using the viewer, you can set the property in code.  Once you set the parameter property to false, the prompts will not display at the top of the report in the browser anymore.

BTW, you can supposedly also suppress parameters in the URL by adding a query string parameter of rs:parameters=false.

 

Gerry

Posted on Friday, July 30, 2004 3:57 PM | Back to top


Comments on this post: Reporting Services Report Parameters

# re: Reporting Services Report Parameters
Requesting Gravatar...
I ran into the same problem, but as I am writing a form based reporting services managenment tool, I need to have control over the Promp User check boxes. eg I need a way for my users to check/uncheck the Prompt User within my app, which I just cannot figure out how to do. And when I create a new subscription I cannot pass new parameter values, if the Promp User check boxes are not checked in the report manager.

Another problem I have got is that I just cannot find a way do display some parameter values. They appear in the reoport manger but when I try to display them their state is "DynamicValuesUnavailable" although they are visible in the report manager.

So the abouve workaroud is not good enough for me, and I have not found any sites dealing with that problem.

Gash
Left by Gash on Aug 02, 2004 6:28 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Sounds like you have some more serious issues than I was having. I haven't gone to that extent with RS yet. I do know that the prompt check boxes really threw me for awhile. It just doesn't make sense.

I will keep your issues in mind as I work more with RS and if I come across a solution, I'll be sure to let you know.

Gerry
Left by Gerry on Aug 02, 2004 8:23 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
You say to "set the Parameters property to false". How/where exactly do you do that?

Thanks,

Leon
Left by Leon on Aug 04, 2004 12:53 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
You can do this using two possible methods.

1) If you are using the reportviewer control in your application, you can set the parameter property in the property window to False. NOTE: This is only available in the reportviewer control.

2) You can set the parameters to false in the URL of the request for your report if you are going to view it as a report relying on report manager rather than the control. Add this to your URL;

rc:Parameters=false

This belongs in the URL query string portion.

Gerry

Left by Gerry on Aug 04, 2004 1:24 PM

# Length of parameter to a report
Requesting Gravatar...
Hi ,
Help is greatly appreciated.
I am rendering the reports thru code.
I want to pass as parameter a huge xml string.The report is just hanging. Is there any limitation to the size of the parameter i can send to the report.
Left by Raj on Aug 24, 2004 11:45 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
I haven't run across that yet nor have I searched the documentation but there is a limit on the whole URL length anyway of 2048 characters.

I'm assuming there is a length limit on the parameters as well.

Gerry
Left by Gerry on Aug 24, 2004 11:50 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Your limitation is an ASP problem. The url cannot be longer that something like the 2048 characters
Left by Hennie van Dyk on Sep 20, 2004 10:41 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Hmm I've run into the same problem. Unfortuantely I need more flexbility to. I'd like some parameters to be passed without interaction, and some where interaction would be nice. This is a really horrible bug! Is there anything in the RDL code that can be modified to sort this out?
Left by David Boyd on Oct 11, 2004 11:32 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Actually if you edit the RDL file and put in the prompt, but put prompt in blank for the parameter i.e. <Prompt></Prompt>
seems to work
Left by David Boyd on Oct 11, 2004 11:42 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
This was informative, and answers a different question I was getting ready to investigate. However, I have a more central question that I'm really hoping you can answer.

I have a query with a parameter being passed in. Something like:

select myvalue from mytable where myparam = @param

This query needs to be used multiple times in the report, and the only difference is the value of @param. I have researched extensively, but have not found a way to pass in the parameter from the report (not from the url). I.e., I would like to be able to do something like:

= SUM(Field!myvalue.value, "mydataset?param=1") (or something analogous) for the equation, where I am passing in a value for @param. There are multiple situations (dozens) where, if I can't do this, then I literally have to have datasets where the only difference is the value of @param. So I would end up with something like:

dataset1: select myvalue from mytable where myparam = 1

dataset2: select myvalue from mytable where myparam = 2

etc, etc.

This is, to say the least, immensely cumbersome.

Any ideas? Does this make sense? I'm on a massive deadline, so any hints would be most deeply appreciated.
Left by Gregory S. Hill on Oct 22, 2004 10:45 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
hi

Is there a way to control the toolbar Of the Parameters
For example to enter a calander For date Parameters?
tanks
Left by ofir shoval on Nov 17, 2004 9:38 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Eu quero saber se tem algum parametro para exibir o botão de imprimir...
Left by Nice on Jan 06, 2005 2:33 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Hello All,
Ques: I have a three parameter on my reports. Out of which One I am passing as a quesrystring and rest two I need on the Report pae to do Filter. Now setting "rc:Parameters=false" removes all the paramters from the report page. Where as i need only one to be removed and rest two to be there. Any Suggesion?
Left by HEMAL RAVAL on Feb 21, 2005 1:52 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
I labored for hours trying to hide parameters. I kept getting errors such as the parameter you are trying to set is read only. Finally I realized that the designer could not help me. So I told the designer to have the Prompts... such as 'UserID' for the parameter UserID.

Then I went into the XML code, by right clicking on the {report}.rdl and edited the XML.

I made the <Prompt> have an empty set. If you just go into the designer and make the Prompt: blank, it takes that element out of the XML which seems to make the parameter the dreaded readonly.

<ReportParameter Name="UserID">
<DataType>Integer</DataType>
<Prompt></Prompt>
</ReportParameter>
<ReportParameter Name="PlanID">
<DataType>Integer</DataType>
<Nullable>true</Nullable>
<Prompt></Prompt>
</ReportParameter>

Then I rebuilt, and deployed... and walla.. I could set the parameters in the query string.
Left by Robert Koernke on Feb 24, 2005 4:55 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
I'm using Report Services with a ReportViewer on my WebForm. Is there a way to change the reports datasource (connectionstring, query..) from my ReportViewer?
Left by Marinus on Mar 02, 2005 8:11 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
I facing problem in passing using large number of parameters(say around 500 which hold the key to the filter criteria of my application )to URL. Can some one tell me what is the solution to it or at least what is the maximum no. of parameters that can be passed....
Reply me at alkesh.patel@patni.com
Left by Alkesh on Mar 04, 2005 8:51 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
I can't recall the max parameters right off but I think you will find that you are running into a problem with the length of the URL.

THe parameters are being passed using GET which appends the parameters to the URL.

Check the length of your URL with all of your parameters.

Gerry
Left by Gerry on Mar 04, 2005 9:01 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
What exactly are you trying to do with changing the datasource?

Can you provide a little more information?

Thanks

Gerry
Left by Gerry on Mar 04, 2005 9:04 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Has anyone answered this question above:

Another problem I have got is that I just cannot find a way do display some parameter values. They appear in the reoport manger but when I try to display them their state is "DynamicValuesUnavailable" although they are visible in the report manager.

I'm having a similar problem in the dropdown list, and can not find anything that would provide possible reason for this error
Left by RG on Mar 08, 2005 6:43 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Hi,
I am running into an issue , any time the length of the url and parameters combination are greater than 2048 characters. It brings up the report page and sits on the "Report is being generated" screen forever.
i am trying to solve this problem for real long time now , can some one plz help !!!
i have tried using the render method (web service),but the major problem is, i cant use the toolbar with this method... which is my requirement :-)
could u plz tell me any method to view the report after rendering the report, instead of saving it as a file and then displaying it.... is display the rendered report in image format the only way to do it ?
it would be seriously kind of u if u could give me a solution for the URL length problem !
Left by Vivek on Mar 09, 2005 1:51 PM

# Reporting Services Change connectionstring
Requesting Gravatar...
I'm using Report Services with a ReportViewer on my WebForm. Is there a way to change the reports datasource (connectionstring, query..) from my ReportViewer?

When my ASP.NET application is used, it depends on the user where the ReportViewer/Report S. will get the data. So, in runtime I would need a possibility to change the name of the Database (from "Northwind" to "Southwind").
I also wunder how I could change the SQL for the report. Example: change from "where User=123" to "where User = 456".
Left by Marinus on Mar 11, 2005 9:34 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
I believe the max length of the URL is 1024 characters. That means your URL with all params is twice that length.

Try shortening your URL and see if that helps.

Gerry
Left by Gerry on Mar 11, 2005 9:37 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
For your first issue, you might try changing the connection string in code when the user logs in. You would have to write that yourself as I don't think you can do it by default in the Reportviewer.

As for issue #2, change your report to a parameterized report and provide the user id on the request.

Gerry
Left by Gerry on Mar 11, 2005 9:40 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Help, I have tried everything to be able to do the following in reporting services:

I need to have one value passed in the url that will not appear as a prompt and that will be hidden from the user. I have three other parameters that the user will choose.

In the URL I set the string as follows:
rc: parameter=true&hiddenparam=102

It all works but I cannot hide this parameter (hiddenparam) from the user since I have to set prompt user in the Report Manager to prevent the dreaded read only error. I have also edited out the prompt in the xml but that does not seem to work. I always get the prompt.

Left by Mark on Mar 13, 2005 5:07 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Marinus,

The way I handle using connections is through linked servers. I fire a dynamic stored procedure that lives on one server. That stored procedure dyanmically builds based on some params that I pass in. I can determine what database to hit based on this. And to tell you the truth, this works great. I have the majority of my reports setup this way.
Left by Bob on Mar 14, 2005 4:19 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Bob,
That sounds great! But I can not imagine how this stored procedure should look like... Could you give a sort of an example of that. If you please...
Left by Marinus on Mar 15, 2005 8:59 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
you guys who figured out how to do the <prompt></prompt> thing in the XML rock. Just what I needed. Hopefully they don't break this in a future version.
Left by Andy on Mar 22, 2005 7:41 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
If, like me, you are trying to hide something like ... say ... a user ID, you should use the user collection's User!UserID instead of trying to pass it. you can put =User!UserID as a stored procedure parameter value, for example. Here it is from the "horse's mouth":

http://blogs.msdn.com/tudortr/archive/2004/07/20/189398.aspx

Of note, I _am_ using a custom security extension.
Left by Andy on Mar 24, 2005 1:01 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Regarding Mark's trouble with the hidden parameters not working (3/13/2005 5:07), I found that if you have a default value on your hidden param that it will not work. Also make sure that you save your xml specifically and verify the changes. Also, this worked for me on SP1; I haven't tested without SP1.
Left by Johnny D. on Mar 29, 2005 1:43 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
I wonder if Mr.HEMAL RAVAL already has the answer of his posted question, because I'm facing the same problem as his. I want to hide/remove 2 of 5 parameters, does anyone has the answer?
Left by Liany on Mar 29, 2005 9:47 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Hi ,
I am new to RS - I want to know if we want to call another report from current report-passing values to the new one-and displaying the value-how to do that?
Left by Vrushali Chaudhary on Mar 30, 2005 2:21 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Now that is scenario I haven't thought of before. I'll have to look into it.

Gerry
Left by Gerry on Mar 30, 2005 8:37 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
I have a question. I've a query that i want to limit the results based on a report parameter. How do i represent that parameter in the SQL for the query. for example

select employer, state from table where employer = ???

If i add a query parameter, and then try and associate it with a report parameter, i always get no results in the preview pane. At this point i can't figure out how to represent the value in the Report Parameter to take effect on the query. Thanks in advance.

Daryl
Left by Daryl on Mar 30, 2005 4:04 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
HOW CAN I ET A REPORT PARAMETER THAT IS A LISTBOX TO BE MULTIPLE SELECT ENABLED?
Left by sanhel on Apr 21, 2005 8:41 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
HOW CAN I ET A REPORT PARAMETER THAT IS A LISTBOX TO BE MULTIPLE SELECT ENABLED?
Left by sanhel on Apr 21, 2005 8:41 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
HOW CAN I SET THE REPORT PARAMETER THAT IS A LISTBOX TO BE MULTI SELECT ENABLED????
Left by sanhel on Apr 21, 2005 8:42 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Are you referring to the parameter drop down that is provide by RS or one that you add to a form?

Gerry
Left by Gerry on Apr 23, 2005 3:56 PM

# Q: Reporting Services Report Parameters
Requesting Gravatar...
i have 2 questions:
1- how can i add a calender to a parameter from type datetime ?
2- how can i change the format of date from
mm/dd/yyyy TO dd/mm/yyyy and use it in parameter ?
can anyone help me quickly ..
Left by Nezar on Apr 24, 2005 7:20 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
For the first question, add a calendar control to the page you are taking parameters from. Get the date from that calendar in the click event and pass it as a parameter to the report.

For question #2, the date format is controlled by regional settings on the computer that is executing it.

Gerry
Left by Gerry on Apr 24, 2005 12:27 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Dear Gerry:
there is no Calender Control in RS.
its a bug in RS.
could u provide me with alternative solution plz.

for the second question, thank u very much
Left by Nezar on Apr 25, 2005 8:03 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
You're right, sorry. I thought you were trying to get the date from another form to pass as a parameter to the report.

I wouldn't call it a bug necessarily as perhaps a feature that should be added. You have no control over dates in RS because of this. You must use the dates in the format that computer's cultureinfo specifies.

Gerry
Left by Gerry on Apr 25, 2005 8:46 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
I'm not certain that is possible. Reporting Services provides the controls that you use for parameters from basic .NET controls but doesn't implement the entire functionality behind those controls. I have not found a way yet to enable multi-select on a list box.

This would require you to do some parsing prior to the parameters getting passed to the report as you will have more than one parameter coming from the control. RS expects one parameter per control.

Gerry
Left by Gerry on Apr 25, 2005 8:50 AM

# Reporting Services Report Parameters (rendring through web form)
Requesting Gravatar...
Hi,

I have been playing with Reporting Services for sometime now and it seems to work great so far. I am now trying to render these reports into a web application. I am using the web service to render them. However, when I try to pass my paramters, it gives an "System.NullReferenceException: Object reference not set to an instance of an object.
" exception. The following is the code I am trying to use.

ParameterValue[] parameters = new ParameterValue[3];
parameters[0].Value = "20055";
parameters[1].Value = "000047";
parameters[2].Value = "83";

Can someone please help. It seems like I am not defining my paramters correctly.

Regards.
Left by Moosa on Apr 25, 2005 5:58 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Actually i got it fixed. it should be like this.

ParameterValue p1 = new ParameterValue();
p1.Name = "<parameter name>";
p1.Value = "20055";

ParameterValue p2 = new ParameterValue();
p2.Name = "<parameter name>";
p2.Value = "000047";

ParameterValue p3 = new ParameterValue();
p3.Name = "<parameter name>";
p3.Value = "83";

ParameterValue[] parameters = new ParameterValue[3];
parameters[0] = p1;
parameters[1] = p2;
parameters[2] = p3;
Left by Moosa on Apr 25, 2005 6:49 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Re post from Gerry on 4/25 8:50 a.m.
Hi. I am just starting to learn RS and need to rewrite a large number of reports that currently have a web front end to let the user select report criteria prior to running the (Crystal) report.

I want to eliminate the web front end and instead have an RS form collect these user choices. Making an RS form listbox multiselect enabled is critical since almost every report has one or more listboxes where the user can optionally select multiples. How could MS omit something this basic? Since MS RS is supposed to be extensible by adding custom program code, is there anyway that you could add code that would assemble the multiple selected codes into a single string that can then be the 'single' parameter for that control? Any ideas?

Left by Bob Fitz on Apr 29, 2005 6:44 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Hi Moosa I'm rendering my RS by the web service and adding the paramethers like u've shown here , but a error is being threw "The report parameter 'parameterName' is read-only and cannot be modified" Can you help me?! hhehehe Thanks
Left by Diego on Jun 03, 2005 3:06 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
HOW CAN I SET THE REPORT PARAMETER THAT IS A LISTBOX TO BE MULTI SELECT ENABLED
Left by kate on Jun 14, 2005 1:33 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
HOW CAN I SET THE REPORT PARAMETER THAT IS A LISTBOX TO BE MULTI SELECT ENABLED ..
Can you help me ASAP ?! Thanks
Left by kate on Jun 14, 2005 1:35 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
How do you pass a parameter from Reporting Services to SQL query (Dataset) for ORDER BY clause
Left by RP on Jun 22, 2005 11:56 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
rc:parameters=false....it works....thank you so much, Gerry for solving my problem.
Left by smy on Jul 08, 2005 4:50 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
I desperately need to find a solution to a parameter issue. I've read through all of the above posts and tried to implement some of the suggestions to no avail.

I have an HTML page where I'm sending the a parameter in the URL string. I have rc:Parameters=False and have edited the xml data to a have a blank prompt.

I have unchecked the Prompt checkbox on the report and also cleared the Prompt String in the report server.

Here is the error I receive.
Parameter validation failed. It is not possible to provide valid values for all parameters. (rsParameterError)

ANY help is appreciated as this report must not give the user the option to enter a parameter
Left by yrmeyer on Jul 09, 2005 10:10 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
I have problems with parameter DateTime format on Reporting services 2005 beta. Date format on my PC is dd.mm.yyyy and same on IIS server.
Its ok if I use Reporting portal URL:
http://<My Server>/Reports/Pages/Report.aspx?ItemPath=%2fTimeSheet%2fDailyReport
but if I use URL:
http://<My Server>/ReportServer/Pages/ReportViewer.aspx?%2fTimeSheet%2fDailyReport&rs%3aCommand=Render
its not ok, date format is mm/dd/yyyy.

Thx for any idea
Left by Tomaz on Jul 12, 2005 6:17 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Hello All!
I have a problem with hiding 2 of 3 report parameters. How could I send 2 report parameters in URL and provide user with possibility to select remaining one?

I've tried to realize this, but after selecting remaining parameter and clicking 'View report' I just see nothing, no errors and no report.
Left by Timur on Jul 14, 2005 6:37 AM

# rc:Parameters:false Not Working!?
Requesting Gravatar...
I have a form that calls a report, and passes several parameters to it. I simply want to hide the parameters when the report is displayed.

I've added &rc:Parameters:false to the end of the URL and it has no effect. Everything else with the report works great.

I have NO default values on the parameters.

Any help is appreciated.

-Scott
Left by Scott on Aug 04, 2005 9:36 AM

# re: rc:Parameters:false Not Working!? 8/4/2005 9:36 AM Scott
Requesting Gravatar...
OOps I mean I have &rc:Parameters=false in my URL.
Left by Scott on Aug 04, 2005 9:37 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
I am trying to call a report using URL method by doing form post method. I have some document map in my report. I am running into the issue where document map does not show in the report output. Also, I want to keep the toolbar visible but I don't see the toolbar (with all the exporting options etc) either. Can someone please help?

Left by Khan on Aug 08, 2005 7:17 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
I am trying to hide 1 parameters out of 4 in the reports. This paremeter will come from url while the other parameters will be calculated depending on the first parameter value. Any ideas would be highly appreciated....
Left by Aditya on Aug 08, 2005 3:29 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Hi,

Is it possible to embed a fillable web form in the body of a report. I would like to collect information from the subscribers of the report.

Thank You,

Roman
Left by Roman on Aug 16, 2005 1:07 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
I found when rendering reports via the webservice I would run into the rsReadOnlyReportParameter error when a param was set to not prompt the user. I use this code to check the report parameters for this condition prior to calling the render method via the webservice. It basically looks for this condition and changes the PromptUser property = True and the Prompt="" (an empty string) so it doesn't display in the report manager.

Dim reportParams() As ReportParameter
reportParams = rs.GetReportParameters(ReportPath, Nothing, True, Nothing, Nothing)

' to get around the rsReadOnlyReportParameter exception that gets thrown when
' the 'PromptUser' property of a parameter is set to false, loop through all the
' parameters and if they PromptUser is false set it to true but then set the
' Prompt property = to an emptry string "" so that the parameter does not
' display in the report manager
Dim rp As ReportParameter
For Each rp In reportParams
If rp.PromptUser = False Then
rp.PromptUser = True
rp.Prompt = ""
End If
Next
rs.SetReportParameters(ReportPath, reportParams)
Left by Nick @ INDATA on Aug 24, 2005 9:42 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
THanks Robert Koernke for tip to turn off individual report parameters from showing
The DEsigner bites back if, after typing <Prompt></Prompt> in the RDL Code, you dare just to CLick Report>REport Parameters in the Designer: as you Click OK it wipes out your <Prompt></Prompt> from the RDL anf you're back to square 1.

So: Switching off the prompts in the RDL is the last thing you do to report parameters - a bit like setting your burglar alarm before leaving home!
Left by Dan on Sep 02, 2005 3:33 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Is there any way to have multiple select like a listbox in the parameter dropdown.
Left by Topgun on Sep 12, 2005 6:55 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
I have a similar issue like the one posted by Gregory S. Hill

I'm creating a report that does some calculation for all the months. I wrote a Stored Proc that does it and takes Month as a Parameter and created a dataset for it. But i have to execute the same SP for all 12 months, means 12 times in the same report with different month as a Parameter. Does it mean i have to create 12 datasets with different Report Parameters ? Is there any other better way to do it like automating Parameters in a single dataset ?

Thanks.
Left by Girija on Oct 03, 2005 12:31 PM

# Hiding Report Parameters
Requesting Gravatar...
Hiding the report parameters by deleting the prompt string in the RDL will not work unless you have service pack 1 or 2 installed.
Left by Mark Fruhling on Oct 14, 2005 9:17 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Girija,
Perhaps you could build a report with your report as 12 separate subreports. Each subreport can supply a different parameter. When you run the main report, you will run all 12 subreports. Or, maybe, can your stored proc accept the entire year, then RS can page the resulting data by month.
Left by Jusme on Nov 03, 2005 8:43 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
The report parameters can be hidden by having a space(do not have it empty , press space bar) in prompt string
Left by Jack on Nov 11, 2005 1:03 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
In response to Gregory S. Hill and others asking about using a single stored procedure accessed by multiple datasets on a report, passing a dynamic parameter can be done by going to the report menu and adding new report parameters. Make one for each dataset that you've created that requires different parameter values. For each new report parameter, make the parameter "non-queried" and set the expression value to what you want.

Then, go back to your datasets, go the the parameters tab and in the value field, you'll notice your newly-created parameters in your available drop-down parameters. At this point, select the parameter specific to your dataset (I would name my parameters similar to my dataset to avoid confusion).

The report should run and set the parameters individually, now.

I had this same problem, and with no help from anyone, figured this out after long hours of "playing." I hope this helps someone!

(Note: if the parameter is based off another query within the report, this method can not be done unless the queried parameter is in a subreport. You can also choose a "queried" parameter in the report parameter properties for you new parameter to get a dynamic parameter from the report.)
Left by Stuart on Jan 24, 2006 11:37 AM

# size Limit on Parameters
Requesting Gravatar...
I would like to know for sure,
whether there is a size limit on parameters or not?


Any help is greatly appeciated.

Anil
Left by Anil on Jan 26, 2006 4:29 AM

# Sql Injection in Reporting Services Report Parameters
Requesting Gravatar...
Hello,
I have web based application which used sql reporting services to generate web based reports. My application has dynamic columns reports. Entire application get displayed in a pop up window ,hence there is no problem with sql injection. But while I do import to excel or any other format it opens another b
rowser where I found the Sql injection (sql clause).This can be achieved if there is any fascility to use form post method. If this is possible then please let me know the configuration or any other solution to do not display parameteres value in querystring.
Help me. Thanks in advance.
Left by Pramod Pawar (email: pramod3681@ on Jan 26, 2006 8:25 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
One of the reports I'm working with in SRS 2005 (RTM) currently
produces:

--
w3wp!library!1!01/27/2006-14:24:28:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. ---> System.NullReferenceException: Object reference not
set to an instance of an object.

--

when trying to run this specific report only,
while running from the reporting server.

This report works correctly about 50% of the time, but the other
times, generates the null reference error as shown. Interestingly
enough, running the exact same .rdl report file in 2 other SRS 2005
environments produces no errors.

Also, on the server that does produce errors, this is the only report
that does so - other reports generate correctly when run. We're not
using any subreports.

The config file for reporting services is rather default, and has the
same memory/timeout/etc values as other SRS deployments in our test
environment.

Any help would be very much appreciated.!!!!
Left by Joshua (email: joshuaga@avanade. on Jan 31, 2006 3:01 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Hello everyone,

I have a web application in VBScript/ASP. I need to pass parameters to Reporting Services 2005 report. I also need to have the parameters hidden in the URL so the users can not change their value, or use any other method of passing the parameter to the report.

I am new to Reporting Services and just can not find any help about it.

Thank you.
Left by Asad on Feb 22, 2006 3:53 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
When you pass parameters to RS and you don't want them to be seen by the users, you can implement the POST method rather than the GET method for your form action.

This will still not restrict a knowledgeable user from changing them. If they are familiar with HTML, they can simply to a View/Source from the browser and see what the query string looks like. They can then generate their own request in the address bar by typing in a URL with the parameter names and values of their own choosing.

Not sure if anyone else has found a way to hide the parameters but I haven't found one yet.

Gerry
Left by Gerry on Feb 22, 2006 4:02 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
I don't monitor this board, but thought that this method may help. I've implemented the reports behind ASP.Net webpages, using a ReportViewer control. I then:

Dim params As New System.Collections.Generic.List(Of Microsoft.Reporting.WebForms.ReportParameter)
Dim param As Microsoft.Reporting.WebForms.ReportParameter

' Begin Repeat

param = SignalServerSide.GetReportParameter(params, "NumberDays")
param.Values.Clear()
param.Values.Add(90)

' Repeat Above for ALL parameters

Me.ReportViewer1.ServerReport.SetParameters(params)

Public Shared Function GetReportParameter(ByRef paramList As Collections.Generic.List(Of Microsoft.Reporting.WebForms.ReportParameter), ByVal paramName As String) As Microsoft.Reporting.WebForms.ReportParameter
Dim param As Microsoft.Reporting.WebForms.ReportParameter
For Each param In paramList
If param.Name = paramName Then Return param
Next
' if we got here then it's not in there yet
param = New Microsoft.Reporting.WebForms.ReportParameter(paramName)
paramList.Add(param)
Return param
End Function

This system works well for me - only took me most of the day to figure this out! MS should consider putting out a book on this kind of thing, I know that others are using RS for extranet reporting yet can't/won't add everyone to AD who uses the website...
Left by Chris Wiegand on Mar 03, 2006 12:56 PM

# Re: Reporting Services Change connectionstring
Requesting Gravatar...
Has anyone had any luck changing a report's connection string through code? (using the ReportViewer control)

Gerry's advice of changing the connection string when the user logs in isn't good because the application's connection string and the report's connection string may not be the same.

I thought the SetDataSourceCredentials() method would do it, but it doesn't, or at least it doesn't for me.

Scott.
Left by Scott on Mar 06, 2006 10:45 AM

# heterogeneous reporting
Requesting Gravatar...
I'm trying to use ALL the results from a dataset in the query of another dataset and I can't seem to figure it out.

similar to select * from table where ("values from other dataset")

Because the other dataset is consider a parameter I get a drop down to select from and plug into my query. I would like to see all the results.

Can anyone help? Thanks.
Left by Phil on Mar 10, 2006 5:23 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
a parameter as DateTime returns always mm/dd/yyyy hh:mm:ss AM or PM, i just want to get the mm/dd/yyyy, i need this type of format cause im using oracle's to_char(<date>,'mm/dd/yyyy')

thanks
Left by Oz on Apr 17, 2006 6:25 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Please, advise!!! Using Reporting Service() Render method I pass five parameters and the report produces: --->System.Web.Services.Protocols.SoapException: Error during processing one of the report parameters. It complains of the only parameter. Additional info: it does not accept a parameter that originally(in the report) is chosen from a data set using usp_ and there is no a default value.
I have a combobox with the same data on the form I am working with; so, I get a value and a label from there and then pass it. Here is how I pass the params:
ParameterValue[] parameters=new ParameterValue[5];
parameters[0]=new ParameterValue();
parameters[0].Name="pDateOOS";
parameters[0].Value= this.datDateOOS.Value.ToString();
parameters[1].Name="pPortfolioID";
parameters[1].Value=this.cmbDealPortfolio.SelectedValue.ToString();
this.PortfolioID=Convert.ToInt32(this.cmbDealPortfolio.SelectedValue.ToString());
DataRow SelectedRow=(DataRow)this.dsDealPortfolioList.Tables["DealPortfolioList"].Select(String.Format("portfolioid={0}",this.PortfolioID.ToString())).GetValue(0);
parameters[1].Label= SelectedRow[1].ToString(); ........
Please,help!
Left by msu on May 03, 2006 10:44 AM

# Creating Reports using Analysis Services Data Source
Requesting Gravatar...
I'm currently using RS 2005 with an analysis services data source. Now, what I'm trying to do is a simple parameter pass in the URL after I have built and deployed my report. Listed below are things I've already tried:

1) Adding the parameter to the report, leaving the default value NULL and unselecting the multiple value option. I then go to http://localhost/ReportServer?/Folder/ReportName&rs:Command=render&paramName=SomeValue. After the page loads, the drop down box for the parameter appears, but without "SomeValue" being selected. In other words, my passed value in the URL was ignored, but no error message was received.
2) Repeated step #1 but kept the prompt for the parameter hidden.
3) Repeated step #1 but made the parameter internal.

Needless to say after trying all these methods, nothing has worked. Any ideas?
Left by Joel on Jun 07, 2006 10:08 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Gerry:

Create a Linked Report (based on your original called report) in the browser - then edit this and Hide the parameter(s) (rather than uncheck Prompt User). That's using RS2005, not sure about 2000 though. This should do the trick. You can hide the original and/or linked report too of course.

Hope that helps!
Left by Chris on Jun 08, 2006 1:20 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Actually, it doesn't have to be a linked report, but for my purposes it suits because I want to run a report from another report as well as independantly. It's nice not to have to display the parameters when running the second report through the link.
Left by Chris on Jun 08, 2006 11:02 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Hi! About setting parameter type datetime from format mm/dd/yyyy to dd/mm/yyyy, i have searched a lot but cannot do in RS. There is just one way to do that is : set CultureInfo in aspx (Me.Culture = "en-AU" example of Australia Culture written in aspx when Page_Load) . I think this suggest could help you!
I got a problem, I want to remove the default value of RS Parameter (Value:"<Select a Value>") but don't know how. Is anyone here can help me out? If you can, please send an email to me: vt3hiepbee@yahoo.com . Thank a lot
Left by Henry on Jun 23, 2006 1:19 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
I have a problem too? I have a web app, which a user can use an advanced search, enter a keyworkd the can select from year and to year, ect. the user is then presensented with a results page, from there they click on generate report which gives the an option to group by the report by e.g., program, fiscal year, state etc. How, can I generate a report that passes in those parameters and will reflect the search criteria and they entered along with the grouping selection they chose. I'm usining RS 2005 and VS .net 1.4, The advance search and group by was done using C#. I have no clue and have been baning my head agains a brick wall.
Left by MIZOD on Jul 12, 2006 3:02 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
In your article you wrote: hiding the parameters is don by rs:parameters=false but it should be rc: parameters = false.

Left by Adrian on Jul 24, 2006 4:24 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
To Gerry and sanhel:
Passing multiple parameter values to the report viewer via the URL is possible if you just repeat the parameter key-name pair several times. Like this:
http://xxxx/ReportServer?/TestReport&Param1=A&Param1=B&Param1=C&Param2=1&Param2=2&Param2=3&rs:Command=Render&rc:Zoom=Whole Page%&rc:Toolbar=true&rc:Parameters=false

Param1 and Param2 must be defined as multi-value in the report designer (VS).

I struggled a lot with this one. I hope this helps!

Kaarew
Left by Kaarew on Aug 11, 2006 5:40 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
could any one help me, how can increase width size of parameter dropdown in SSRS 2005......upendrap@aztecsoft.com
Left by upendra on Aug 15, 2006 9:55 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
You don't have hide the parameters. If you leave the prompt checkbox checked, BUT remove the text from the prompt, RS will allow you to pass the parameter in the URL, but not display the control in the parameters bar at the top of the ReportViewer window. This will allow you to pass some parameters, but leave others for the user to select when running the report.
Left by Philip on Aug 18, 2006 4:10 PM

# Reporting Services(2000) Report Parameters
Requesting Gravatar...
I am trying to set single parameter from to fields i.e. FirstName+LastName are two fields in the table and i want to set a parameter like "Name" which joins those two fields.
Is it possible in 2000 version?
Thanks,
Left by Raja on Aug 24, 2006 4:27 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Is it possible to increase the size of Textbox or dropdown in Report Parameter?
Thanks
Left by Bab on Aug 25, 2006 1:31 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Has anyone knows how to chang a report's connection string through code? (using the ReportViewer control)


Please mail me if any one get the solution
Mail Id : Vinodagrawal80@hotmail.com

Vinod
Left by Vinod Agrawal on Oct 07, 2006 12:25 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
for Raja

You probably have worked this out but anyway - this does not have to be a parameter - in layout view

=Fields!Firstname.value & " " & Fields!Lastname.value
Left by jewelfire on Oct 17, 2006 10:54 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Hi Gerry, Great info on the Reporting Services Report Parameters problem.

rc:parameters=false -solved my problem.

BR,
Frederick
Left by Frederick on Oct 25, 2006 1:29 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Hi,
I have a web app which is using RS 2005. Now I have deployed it to production server and it's start giving error. error says.
An error occurred during rendering of the report.
Specified argument was out of the range of valid values.

Any help pls. It's urgent.

Amit
Left by Amit Shrivastava on Nov 11, 2006 9:09 AM

# re: Reporting Services Report Rendring
Requesting Gravatar...
Hi,
I have a web app which is using RS 2005. Now I have deployed it to production server and it's start giving error. error says.
An error occurred during rendering of the report.
Specified argument was out of the range of valid values.

Any help pls. It's urgent.

Amit
Left by Amit Shrivastava on Nov 11, 2006 9:11 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Does it give you any indication as to which argument is out of range?

Can you look at the query string to validate the data that is passed to the report?
Left by Gerry on Nov 11, 2006 9:32 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Hi,
This is related to hiding the parameters in RS2000.I am using 3 parameters out of which one I want to make hidden.For that I checked the prompt user check box in report manager parameter properties and making promt string textbox clear.When I call this report file from ASP.net web page using report viewer control I get to see two prompted parameters.The other parameter I passed internally.But when I pass values for other two parameters and click View Report button(in rdl file) I see nothing.Simply a blank page. Point to be noted here is, I get a javascript error. Probably there lies the clue to solve this issue.
And when I specify default value for parameter in Report Manager and uncheck the prompt user check box and call it from web page I get this error:
"The report parameter 'strUserID' is read-only and cannot be modified. (rsReadOnlyReportParameter) "

where 'strUserID' is parameter name.

Ankan Pal.
Left by Ankan Pal on Nov 20, 2006 1:48 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Hi, iam using java EE web service client to access reporting service 2005. Iam calling ReportExecution2005 service and having trouble seting up session variable. Tried many ways but culd'nt solve it. I keep on getting rsMissionSession identifier.

first call to loadReports works fine but next call to the same service is failing.

Any help would be greatly appreciated
Left by San on Nov 20, 2006 12:59 PM

# Conditionally hiding Report Parameters: Reporting Services 2005
Requesting Gravatar...
Hi,
I have a report with 5 parameters. The 1st one has values of Geography - Continent, Country, Zone, State. Now based on the value selected in this first parameter, I want to conditionally show only 1 of the other 4 parameters. i.e.If Continent is selected as the 1st paramter, I should only see the paramter for Continent and the rest should be hidden. Is this possible in SSRS 2005?
Any help would be greatly appreciated.
Prachi
Left by Prachi on Nov 23, 2006 4:52 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Greetings,
I was affected with the read only parameter problem. It happened after I upgraded to sp1 or when I applied ssl. I found a kludgy solution.

I am setting the parameters by the url.

Go to the parameter that is being set to read only. Then uncheck all parameter options and give it a default prompt. Deploy the report. Log into the Report Manager and open that report, select properties and Parameters. Locate the parameter and first clear out the prompt, then set prompt to false then set hidden to true. Press apply. Go back into visual studio and remove the prompt and set hidden to true. This in a quasi like way syncs with report manager because you can deploy and it will not change anything in report manager. Dont know why it worked but it did.
Left by Ross B. on Dec 18, 2006 10:47 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
How to pass parameters from VB.Net to Olap report (Reporting services 2005).

I am generating reports using SQL Server Reporting services 2005. I am not
able to pass any parameter to the OLAP report. For example I have to pass the
week of year . The data source is cube (SQL Analysis Service 2005). I am
trying to modify the MDX Query after taking the necessary dimension in rows
and column. The query doesnt get saved. Please assist.


How do we pass parameters in MDX ? ..What is the syntax for it. Is the following syntax correct?
[Date].[WeekOfYear].&[DateWeekofYear].
This is what I have provided in Where clause and here date is the dimenstion and dateWeekOfYear is the member name and DateWeekOfyear is the parameter.

Left by UmaMohan on Jan 03, 2007 11:34 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
I am stumped. I have read and done what was previously stated about passing a parameter through the URL. But I still get the error that the "...parameter is missing a value." I originally had a report based on a stored proc that took one ID parameter. I put a list of IDs, just to have some, and then passed the parameter but no luck. Then I read and followed the advice stated here, no luck. Then I thought I try a query that has a parameter, no luck. I am pulling my hair out. Help someone PLEASE!
Left by YosiP on Jan 24, 2007 4:52 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
I have a stored procedure which takes the following parameters fromdate,todate,projectid and displays the report, now the report should generate another report(link report) by clicking on a field say "module",the next report also is generated through another stored procedure which takes 4 parameters including the previuos three parameters that is fromdate,todate,projectid and a new parameter that is "module" , how to send the previuos 3 parameters declared in the first report to the second report and also send the clicked "module" field value as a parameter without asking the user to enter any....Can anyone please help me on this
Left by Nirupa on Feb 14, 2007 9:09 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
I got a problem, I want to remove the default value of RS Parameter (Value:"<Select a Value>") but don't know how. Is anyone here can help me out? If you can, please send an email to me: krupali@excellenceinfonet.com . Thank a lot
Left by krupali on Feb 16, 2007 12:57 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Thanks for your blog from july of 2004, it helped me a ton in february 2007.

Does it make any sense why the solution is to turn on allow prompt in the report manager but then ad &rc:Parameters=false to turn it of in the url?

who cares, it works!

thanks
Left by webmoneymon on Feb 19, 2007 12:17 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Hi,
I'm passing the parameter"CAllID" for subreport from the main report's field CallID.But when the
CallID is null.Subreport section gives error:-
"One or more parameters required to run the report have not been specified."
I'm trying to change the expression of the parameter of subreport to:
=IIF(IsNothing(Field!CallID.Value),-1,Field!CallID.Value)

Seems like its not working.Please Help.

May
Left by May on Feb 26, 2007 10:01 AM

# re: Reporting Services Report Parameters solved for me
Requesting Gravatar...
I had the read only error "The report parameter is read-only and cannot be modified. (rsReadOnlyReportParameter)


So I was thinking that the the &rs:Parameters=false did not work. However it does work.

the problem for me was not the parameters=false did not work it was that the syntax of my url was incorrect.

In a responses.redirect you need to break up the url like this.

Response.Redirect("http://ourserver/reportserver?/ taskreports/rptName&Tskid=" & TskId & "&rc:Parameters=false")

This allowed me to pass the parameter to the report without a prompt.

the books I was using were not showing the url in a response.redirect so the books were not using this syntax.

Note: I still had to go against common sense and select the prompt checkbox in the report manager even though I do not want the report to prompt the user for a parameter.

hope this helps someone.


Left by webmonkey on Mar 01, 2007 5:16 AM

# ReportViewer WinForms Report Parameters
Requesting Gravatar...
Does anybody know how to set "url parameters" using reportViewer control in WinForms application?

I want to customize the report look using style sheets so I would like to add &rc:StyleSheetName=MyStyleSheet to the parameter list.

Is that possible or is there another way to customize the parameter panel in the reportviewer control?


Tnx in advance,
L.
Left by Luka Gospodnetic on Mar 16, 2007 12:03 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
here's another tip: if your parameter is query-based, it will be ignored in the url.
Left by Donovan on Mar 27, 2007 9:49 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Hi I keep getting 'Value not specified for parameter1' when I am using storedprocedure for reports. But I did add the Report parameter and in the dataset?? Can anyone help
Left by Jaya B.Rayasam on Mar 28, 2007 12:18 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
The format of the parameter depends on the settings of internet explorer (tools >options>languages... choose the right language, and get the right format.
Left by Binabik on Apr 04, 2007 4:41 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
I am using webservice to access reports and using expand collapse on the report. when i click on expand link then it gives error as Reporting Services Error

* The report parameter 'paramnamehere' is is not valid value. Get Online Help

Microsoft Reporting Services
Left by Jay Dixit on Apr 06, 2007 4:44 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Hi,

I am using SQL Reportingservices with ASP.NET, I am trying to render the report by the ASP.NET code and is acheived it, but what i need is if the RDL that i am rendering needs parameters to be specifed with value, but i want to render without specfiying value for the parameter, is it possible to do this in the ASP.NET code.

Thanks in advance.
Left by Jagathesh on May 05, 2007 5:47 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Hi there,

in brazil we type the datetime like dd/mm/yyyy, but for some reason the rporting services don't accept it. The fact is that everytime i type aa/bb/yyyy the sql searchs for bb/aa/yyyy. It wouldn't be a problem, but what happens is that the program opens a calendar to make it easy for the user to check the date. And, when it cheks it, it goes like dd/mm/yyyy, what obviously brings a problem. Do you know how to fix it??

Thanks in advance!

Alberto
Left by Alberto on May 31, 2007 3:53 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
I have designed report using reporting service. in that i have 4 parameter.among the 4 parameter,i want to pass one parameter from URL(Query String).is it possible to pass the string via URL to Report parameter...

Reply soon...
Left by Riyath on Jun 01, 2007 9:19 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
append "&<Param>=xxxx" to your URL
Jluc
Left by jluc on Jun 12, 2007 7:35 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Hey guys,

I've got a parameter that can accept multiple account name. Although it works just by using the drop box, I'd love to be able to put a search function so the user can search an account with out problem instead of scrolling down through thousands of account names.

Thanks if anyone can help....
Left by UN4G1V3N on Jun 13, 2007 2:14 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
How would I set a default value to TODAYS DATE in a report parameter ?

Thanks.
Left by David on Jun 14, 2007 2:29 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
How to display two sub-report in same report page where Sub report parameter depend upon the main report.
Left by praveen on Jun 27, 2007 12:27 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
I am trying to pass a parameter to a Reporting Services report from an application written in Visual Studio 2005 and it just isn't working. The report is called from an xml page like so:

openWindow('http://path?itempath=%2freport+name%26parm=value')

where %2f and %26 are the hexadecimal representations of "/" and "&", respectively. But when I click the link, although the report appears, my parameters are not populated. Has anyone had this problem? I would appreciate any advice. Thanks.
Left by HHoward on Jul 06, 2007 11:34 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
David -- in order to default your parameter to today's date, use 'Now'. i.e.:

cDate(FormatDateTime(Now, DateFormat.ShortDate))
Left by Anonymous on Jul 06, 2007 11:50 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
I'm passing an integer parameter on the URL but report won't excute until I type same value in the report viewer parameter field. Tried just about every combo of hidden/prompt/rc:parameters available. This is basic functionality that just doesn't work. Is there a new service pack available to fix this?
Left by MarkB on Jul 11, 2007 8:16 AM

# Q: Reporting Services - blank Page suppres
Requesting Gravatar...
Hi All,
How to suppress blank page in SQL Reporting?
Can you help out from this issue.

Thanks
Anwaar
Left by Anwaar on Jul 12, 2007 2:45 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Found the answer to my question from 7/11/07...I was calling the Url as //localhost/Reports/..... when I should have bein calling //localhost/ReportServer/.... After that he query paramater worked and so did theoptions to turn of display of paramters, etc.
Left by MarkB on Jul 12, 2007 2:22 PM

# Reporting Services Report Parameters
Requesting Gravatar...
Conditionally hiding report parameters based on the selected value of the first parameter.
Does anyone have an answer to Prachi’s question (see bellow) I have exactly the same problem:
“I have a report with 5 parameters. The 1st one has values of Geography - Continent, Country, Zone, State. Now based on the value selected in this first parameter, I want to conditionally show only 1 of the other 4 parameters”.
Left by Codi on Jul 20, 2007 9:11 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
I, too, have the same problem that Prachi and Codi are asking about. I need to hide and show other parameters based on the choice of the first parameter. ANy help would greatly be appreciated.
Left by Shelia on Aug 23, 2007 11:49 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Is it possible to decrease the size of Textbox or dropdown in Report Parameter?
Thanks
Left by Sriram on Sep 19, 2007 4:37 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Hi,

I have totally three Parameter. I need to align the parameter first parameter in first row and second and third Parameter in second Row. Please let me know How to impletment
Left by Shyamala Shankar on Sep 19, 2007 6:35 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
hi,
thanks for ur solution/idea..
but for me..i try to do as ur solution but failed...


Problem for the prompts will display at the top of the report in the browser

1)go to the report manager on computer and set the
set the Prompt User check boxes to checked.
--> auto check

2)select the report viewer control, if you are using it, and set the Parameters property to false.
--> the eror mesage will be display
" The ' field' parameter is missing value. "

so..any idea...
thanks in advance...





Left by muz on Sep 26, 2007 8:37 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
plz any one find out & send to me how to pass the parameters in Dot net with c# website using SQL server Reporting Services 2005.

It is more urgenttttttt.


Thanks in advance
Left by senthilnathan on Nov 13, 2007 5:42 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
How do I provide a default Date to a DateTime Field so, that it would not trigger a PostBack?
The DateTimeFileds are not the first Parameters to be entered, but also aren't dependent on any other Parameters.
If I enter =cDate(FormatDateTime(Now, DateFormat.ShortDate)) for the Default, the PArameters are not displayed until I have selected the previous Parameters and this triggers a PostBack
Left by Dan on Nov 15, 2007 5:37 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
plz this Msg bop to me after preview report in local BC

" valid values are between 1 and 9666"

if change parametar datetime to string dosen't show this
Msg
Left by mansor on Nov 27, 2007 1:04 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Thanks for the <Prompt></Prompt> tip. That did the trick for me.
Left by David on Dec 07, 2007 12:43 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
I am using SSRS with custom auhentication. On the role basis, the reports are displayed to the User. Now, I want to pass the parameters on runtime. But, I don't know that How much parameters are required by a report on runtime? How can I get the list of parameters required by the report on runtime??
Can anybody help, it's urgent.
Thanks in advance.
Lokesh
Left by Lokesh on Dec 26, 2007 4:09 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
i am trying to set a default date parameters for my RS 2005 Report using report manager. any help?

Left by Gideon on Feb 16, 2008 6:02 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Hi,

I have couple of queries regarding SSRS

1)
I am new to SSRS and have a very common requirement to fulfill, here the requirement,

I need to generate reports based on any input parameters, i.e. reports should be generated on any combination of StoreName, District or State
• By StoreName
• By District
• By State

Here is the table structure,

StoreID StoreName District State
1 Store1 District1 State1
2 Store2 District2 State1
3 Store3 District2 State2
4 Store4 District3 State2
5 Store5 District1 State2


How can I make my parameters dynamic so that when I select State value, District value gets changed accordingly. Currently I have three different dataset for 3 parameters (StoreName, District and State) but in that case user can choose any value for anything. For example user can select Store5, District3 and Stat1, which is an invalid combination.

Can anyone give me some details on how to implement this.

2)

There is a one more requirement, if we set that parameters can have multiple values how to handle them in query?

Select * from tblStore where StoreName = @StoreName

This query will work only for single storename, how to pass multiple storenames to the query?

Any help in the above queries will be greatly appreciated.

Thanks,
Dhaval Patel
Left by Dhaval Patel on Mar 08, 2008 4:02 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Hi All,

I need a help.

I want to Display the Parameter Prompt value dynamically is it possible?

I have a drop down list in the parameters and i have a text box. too.. Bases on the dropdown list selected value i want to change the Text box label..

For example if the dropdown has the items like
<XYZ something>
<ABC someting>

If the selected item is ABC Something then the Text box should display like

ABC : <Actual Text box>

Is is possible to do or not?

Thanks in advance.

Thanks
Sudheeer Kumar K
Left by Sudheer Kumar Kondragunta on Apr 09, 2008 11:32 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Hi,
I want to have the Report Parameter prompts (Labels) change based on some other parameter value. Like I am passing UserID parameter to every report from the ReportViewer control and other parameters are within the report(rdl). Now based on this UserID I want to have multi-lingual prompt (Labels). For this I have created an c# class library and hosted the assembly in hte SSRS. So for anything that supports EXPRESSION I can use this as below.
=Assembly.Class.Method(UserID,ParamName)
and the above function will return me the multi-lingual value for a specific parameter name from the database.

But as the PROMPT for a report parameter is a static string the above expression is not evaluated and shown as string..
Is there any other work arround to achieve this?
Please suggest..

Paresh
Left by Paresh on Apr 11, 2008 6:32 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
How to display a datetime picker or calendar with textbox in filtering in Report server project
Left by Leema on Apr 16, 2008 3:32 AM

# Reporting Services Report Parameters
Requesting Gravatar...
I got a problem, I want to remove the default value of RS Parameter (Value:"<Select a Value>") but don't know how. Is anyone here can help me out? If you can, please send an email to me: srini_slm@hotmail.com
Left by Srini on May 09, 2008 4:44 AM

# Reporting Services Report Parameters
Requesting Gravatar...
i want to hide the parameter of report.
where i have to write
&rc:parameters=false


Actually i have

report server url:
http://localhost/ReportServer

and
report path:
/ExecutiveSummary/ExecutiveReport

and page render by
"executiveReport.aspx"

where i have to write this.can any one explain with detail with example?


Left by srini on Jun 03, 2008 6:08 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
A some what similar problem.... I am creating a report that requires multiple enties in one parameter @Memberid.

E.g Memberid (12345,23446,22334,33333,44445)or
E.g Memberid ('12345','23446','22334','33333','44445')
The problem is the query ONLY accepts one parameter at a time.
What I want to do is enter all the member id as in the example above. I tried using <Prompt></Prompt> as suggested by someone else and all I get is an error message...'The Memberid Parameter is missing a value'

Any idea?

Thnx
Left by cris on Jun 18, 2008 5:52 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
I run my report with the URL:

http://kxdev/Reports/Pages/Report.aspx?ItemPath=%2fProyectoReporteVentas%2fSupraregiones&Fecha1=20070801

And the report prompt me for the value of parameter Fecha1.

How can I do to not enter this value, and the value is take from the URL?

Thanks
Left by Alejandro on Jul 01, 2008 5:09 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
I am trying to develope one sql report .In the hyperlink URL i would like to pass queystring like
http:\\localhost\mysite?t=FieldID.value
Now this FieldID.value will be dynamic based on the row for which the link will be clicked.FieldID.value
is a field in my dataset
I do not know how to do this. My URL opens the site perfect but the querystring value comes as t=FieldID.value
insted of the actual value of FieldID.value
which should be like 1,2 ,3 based on the row cliked.

Can some one help me on this.
Left by mzmishra on Jul 10, 2008 8:57 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
to cris...

If you have a multi-select parameter, in your query filter, you use the syntax

In(@yourparameter)
Left by woeleman on Jul 17, 2008 1:45 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
to mzmishra:

try this ..

="https://server//reportserver/myreports....ParameterName=" + Fields!FieldID.Value

hope it helps.. :)
Left by dan on Jul 22, 2008 11:21 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
I have a report1 that jump to the report2. The report2 has defaul value=null.I want to input value to this parameter.
I have received an error at run time(report manager )when I set the parameter=nul;

error: " the parameter is missing a value ".
How can I jump o report2 to display the parameter to input the value?
Thanks in advance.
Left by indy on Jul 28, 2008 3:57 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
To the person requesting info about how to remove the "<select a value>" option, it appears that you cannot remove it, but you can select default options (to make the report show immediately) by accessing the "Parameters" section of the "Properties" tab when you view the report via the Report Manager ON THE ASP.NET site.

This bugged me for ages too :)

Hope this helps.
Left by Twisted.Mellow on Jul 29, 2008 6:04 PM

# # re: Length of parameter to a report
Requesting Gravatar...
You can set it in the web.config of the ssrs with:
<httpRuntime maxRequestLength="9000"></httpRuntime>

The above will set it to 9 mb

Hope this helps..!!!!
Left by Avinash on Aug 01, 2008 1:47 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
can any one tell the syntax to pass mutiple parameters to a mDX query
Left by buddha on Aug 28, 2008 3:43 PM

# Reporting Services change connection string
Requesting Gravatar...
I need to change the server and the database (and therefore the userID and password) of the connection string dinamically before runing the report.
I'm using the report viewer in a windows form application.
I've try SetDataSourceCredential() method but it's not working
Can anyone help me ? email-me niurkap@gmail.com
Left by Niurka on Sep 12, 2008 10:23 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Can anyone help me? I have two tables with diferent datasets, but I need the value of one cell of the first table in other cell of the second table. How can I do this? Thank you!
Left by filipe on Oct 20, 2008 12:14 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
How Can I Dynamically set the Report Parameters?.
Left by Syed on Nov 27, 2008 2:42 AM

# Multiple parameter in reporting services
Requesting Gravatar...
How to use Multiple parameter in reporting services.
Left by Vikash Mishra on Dec 03, 2008 4:52 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
I am trying to execute a stored proc and pass in param but I get an error saying that my @fromdate and @todate needs a convert from a variant to datetime since I decared the @fromdate and @todate as datetime in the stored proc. I have used convert when i am passing in the param but i get an error on the convert????
Left by Jackie on Jan 28, 2009 10:08 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Thanks so much for keeping this post open so long. I have gotten further along with this single post that with 10 other posts!

My problem is my second parameter on my report dataset requires a value from the 1st parameter to populate the drop-down list for the second parameter. So even when I supply the parameter on the querystring, It still prompts for the value... (Unless I put &rc:Parameters=False in, then I get a msg about a missing parameter).

Query for the first parameter is like: select countrycode from countrytable where userid=@MyUserId

Query for the second parameter is like: select statecode from statetable where countrycode=@MyCountryCode and userid=@MyUserId

So even though I supply MyUserId and MyCountryCode in the querystring, the report still prompts for CountryCode.
Does anyone know an answer here?


Left by DCoppock on Feb 19, 2009 8:29 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
how to change parameter filed from drop-down to a normal text field...
best regards,
Besim
Left by Besim Ismaili on Mar 12, 2009 5:57 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
hi all,
I am trying to set the parameters in the sql query but all the times its showing me the same error message of invalid identifier.

SELECT GEO_RGN_NM, GEO_RGN_CD
FROM REF_GEO_RGN_UNIT
WHERE (AFFL_CD = @AFFL)
ORDER BY GEO_RGN_NM

In this , @AFFL is the parameter defined in report parameters with sm string values set by using query

pls respond @ kapil.dangey@gmail.com
Left by kapil dangey on Mar 17, 2009 9:37 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
The parameter setting through the reports manager helped. Thanks a ton!
Left by Sheetal on May 17, 2009 11:43 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Hi All,

My report has 4 parameters and I want to pass only one parameter from the aspx page which hold the report and all other 3 paremeters from SSRS report itself.
Does anybody know how to do this.
I can pass all parameters from aspx but I dont want to do that because there is no Multiselect check box list in aspx

james

Left by James on Jun 16, 2009 6:55 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Reporting Services use Multiple parameter. That's right,
Left by quang cao online on Jun 19, 2009 4:08 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Great article, thank you.
Left by quang cao online on Jun 19, 2009 4:12 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Hi,

I've got a parameter that can accept multiple data. Although it works just by using the drop box and I'd like to be able to enlarge this box instead of scrolling down through about50 of account names.

Thanks if anyone can help....
Left by Ladik on Jul 01, 2009 7:25 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Hi,
Regarding the daytime parameter.
I want it to be displayed in the dd/MM/yyyy format. i have changed my regional settings and still it is displayed in MM/dd/yyyy.
Do you know how i can control it?
Thanks,
Dan
Left by Dan Timor on Jul 02, 2009 2:30 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Hi,

Anybody can tell me how can we pass multiple parameter to a ReportViewer Control. when i pass the value to the parameter array as param1=1 and param1=2 it's throwing paramter is specified multiple times error

thanks
Fareeth
Left by Fareeth on Jul 08, 2009 11:14 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Fareeth, pass the parameter only once with the actual values separate by commas:

param1=1,2,3,4,5

That should work.
Left by Tom Bell on Jul 11, 2009 7:10 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Thanks Tom it worked, but i just did it in a different way i passed a string array
Left by Fareeth on Jul 17, 2009 11:06 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
i am writing ssrs report in this report i have different departments
Say:Dept1
Dept2
Dept3
Dept4
I am using these as a parameter dropdown.
Now when user clicks Dept1 in second dropdown employee of that department will come
like:
All
Tom
Jerry
Herry
similarly when user clicks on Dept2
dropdown will look like:
All
Rita
Sita
Gita
Now every thing works fine when i click one employee at a time it gives me correct report
but when i click "All " it gives me report for "All " the employees in "All" the departments .
I want "All" for each department .Like if i hit "All" for "Dept1" then it should give me report
only for "All" the employees in "Dept1" which are
Tom
Jerry
Herry
similarly "All" in "Dept2" should give me reports for "All" employess of "Dept2"
which are:
Rita
Sita
Gita

please someone suggest how is this possible?
Thanks!
Left by sid on Jan 20, 2010 5:04 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
I need some help. I have a report in Reporting services 2005 with 3 parameters which are all drop down selection. I need the third parameter to be populated dynamically on run-time based on the selection of the first two parameters. Can anyone help me out on this issue and provide with a running script if possible? Thanks.
Left by Mohamed EL TANNIR on Jan 28, 2010 8:50 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
thanks!

I think this is a good idea.
---
http://www.hplaptopbattery.co.uk
Left by smith on Feb 09, 2010 7:52 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Hi,
I am trying to add parameters to an mdx statement and am having some problems - params in general are fine: I've established my query by building it dynamically from concatenated strings. that works great until i try to express the cube name as a parameter. for example:

="with "
+"MEMBER [Measures].[ParameterCaption] AS "
+"[Time].[TimeHier].CURRENTMEMBER.MEMBER_CAPTION "
+" select [Measures].[ParameterCaption]"
+" on columns "
+" from ["
+Parameters!DMartSName.Value+"]"

this fails every time with a "cannot set commandtext" error. but, if i replace the parameter with the text for the cube name it works fine... it would really help to be able to do this dynamically! thanks...

Left by Allen Maxwell on Mar 08, 2010 5:12 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
hmm... looks like i figured it out. i had to remove the xml designer code - then it would let me set the datasource connection string database name AND the query cube name dynamically... thanks (I got the idea from reading some of the threads above....)
Left by Allen Maxwell on Mar 08, 2010 5:31 PM

# re: Reporting Services Report Date Parameters
Requesting Gravatar...
Left by Gerry at 4/25/2005 8:46 AM
This is a BUG.
Stop this Microsoft "FEATURE" thing.
After some decades copying others' ideas and technologies you 're still just pathetic amateurs!
It seems that just Marketing doesn't do it all.
We all know what you do.
Left by dev on May 11, 2010 3:18 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
I’m populating multivalued parameter from Database table (Ex:- Select distinct (Id) from table1) so when Id count is 1000 they are coming as default selection in multivalued parameter of report in SSSR2008 but if Id count is 1500+ all then default selction is blank in report mutlivalued parameter. But when i click on multivalued parameter i can see all values CHECKED.pLEASE LET ME KNOW IF ANY BODY SOLVED THIS PROBLEM.tILL I THINK IT BUG IN MULTIVALUED PARAMETER.
Left by Kunal Singh on May 25, 2010 4:29 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Are you allowed to pass in a value to a parameter whose available values come from a query? I'm having a problem with this. My reports all have the same first two parameters... servername and databasename. The 1st parameter is a simple text one, the 2nd has a query that uses the first parameter to populate its combo box with a list of available database names. The idea here is simple... if a user goes to the report via ReportManager, they specify the server and database they want to run the report against. If the report is called from a VB.NET application we pass in the server and database names. Whats happening is the reportviewer control opens up... report does not display... all the parameters are populated correctly accept for the databasename. If I use the report service I get a similar error... something along the lines of their being a problem with the database name parameter. So my question is am I attempting something here that isn't supported? I certainly hope not. Any ideas or work arounds?
Left by Brian Stobbe on May 26, 2010 8:40 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Is it possible to create custom controls for report parameters?
Left by Robert Dennyson on Jun 07, 2010 12:17 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
I have a problem when i a list of customer in parameter list drop down in ssrs 2008.
And want to show only those record inside the datatable which i bring from mDX query.
Is it possible then please reply.
I will be very oblidged.
Left by Ramesh on Aug 24, 2010 7:19 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Do we have any output parameters for report?
Left by duckyvideos on Sep 01, 2010 10:47 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Your post helped me solve a problem I was having with optional parameters. For some reason, in Report Manager, the "Has Default" boxes were not checked for 3 out of 4 of my parameters even though I had set this up in Bids. You saved my day :-)
Left by debbie on Oct 06, 2010 12:45 PM

# Passing parameters to report thru Excel as backend
Requesting Gravatar...
How do we validate thru the query If I am having the EXCEL as the datasource for SSRS 2005. I dont know the syntax for where clause with Excel as backend.

Any help is higly appreciated
Left by Robin on Oct 15, 2010 11:25 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
Hwo do I passed multiple values from aspx page to report server(reporting services)? For example, I want to pass param1 as parameter, but param1 has multiple values like, 'A01', 'A02', and so forth.
In sql, it is like this, select ... from city where cityname in ('A01', 'A02',...)
Thank you.
Left by Arnold on Nov 09, 2010 9:14 PM

# re: Reporting Services Report Parameters
Requesting Gravatar...
For those still struggling with this issue:
The good news is that Update Rollup 16 for Microsoft Dynamics CRM 4.0 seems to address the issue.
http://support.microsoft.com/kb/2477743

To quote the notes, it says the following issue has been resolved:

Assume that you create a custom report in an instance of Microsoft SQL Server 2008.
Additionally, the report contains the CRM pre-filtering criteria.
When you run the report, you receive the following error message:
Reporting Error. The report cannot be displayed
Error Number: 0x80040494 Error Description: The report parameter 'P1' is read-only and cannot be modified. (rsReadOnlyReportParameter)
Left by Graham Stalley on Mar 18, 2011 9:54 AM

# re: Reporting Services Report Parameters
Requesting Gravatar...
i have two tables a and b(case (a.salary)-(b.pf) when =>1,80,000 then ESI else TTK) THIS IS CONDITION AND I WANT TO CREATE PARAMETER 'ESITTK' THAT’S FINE THEN HOW TO PASS THE VALUES ON PARAMETER i cont understand
Left by madhan on May 04, 2012 6:12 AM

Your comment:
 (will show your gravatar)


Copyright © Gerry O'Brien | Powered by: GeeksWithBlogs.net