<< Developing Without Admin Privileges is Most Frustrating! | Home | Blogging From SauceReader to This Site >>

Reporting Services Report Parameters

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

Print | posted on Friday, July 30, 2004 3:57 PM

Feedback

# re: Reporting Services Report Parameters

Left by Gash at 8/2/2004 6:28 AM
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

# re: Reporting Services Report Parameters

Left by Gerry at 8/2/2004 8:23 AM
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

# re: Reporting Services Report Parameters

Left by Leon at 8/4/2004 12:53 PM
Gravatar You say to "set the Parameters property to false". How/where exactly do you do that?

Thanks,

Leon

# re: Reporting Services Report Parameters

Left by Gerry at 8/4/2004 1:24 PM
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

# Length of parameter to a report

Left by Raj at 8/24/2004 11:45 AM
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.

# re: Reporting Services Report Parameters

Left by Gerry at 8/24/2004 11:50 AM
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

# re: Reporting Services Report Parameters

Left by Hennie van Dyk at 9/20/2004 10:41 AM
Gravatar Your limitation is an ASP problem. The url cannot be longer that something like the 2048 characters

# re: Reporting Services Report Parameters

Left by David Boyd at 10/11/2004 11:32 AM
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?

# re: Reporting Services Report Parameters

Left by David Boyd at 10/11/2004 11:42 AM
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

# re: Reporting Services Report Parameters

Left by Gregory S. Hill at 10/22/2004 10:45 PM
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.

# re: Reporting Services Report Parameters

Left by ofir shoval at 11/17/2004 9:38 AM
Gravatar hi

Is there a way to control the toolbar Of the Parameters
For example to enter a calander For date Parameters?
tanks

# re: Reporting Services Report Parameters

Left by Nice at 1/6/2005 2:33 PM
Gravatar Eu quero saber se tem algum parametro para exibir o botão de imprimir...

# re: Reporting Services Report Parameters

Left by HEMAL RAVAL at 2/21/2005 1:52 AM
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?

# re: Reporting Services Report Parameters

Left by Robert Koernke at 2/24/2005 4:55 PM
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.

# re: Reporting Services Report Parameters

Left by Marinus at 3/2/2005 8:11 AM
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?

# re: Reporting Services Report Parameters

Left by Alkesh at 3/4/2005 8:51 AM
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

# re: Reporting Services Report Parameters

Left by Gerry at 3/4/2005 9:01 AM
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

# re: Reporting Services Report Parameters

Left by Gerry at 3/4/2005 9:04 AM
Gravatar What exactly are you trying to do with changing the datasource?

Can you provide a little more information?

Thanks

Gerry

# re: Reporting Services Report Parameters

Left by RG at 3/8/2005 6:43 PM
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

# re: Reporting Services Report Parameters

Left by Vivek at 3/9/2005 1:51 PM
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 !

# Reporting Services Change connectionstring

Left by Marinus at 3/11/2005 9:34 AM
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".

# re: Reporting Services Report Parameters

Left by Gerry at 3/11/2005 9:37 AM
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

# re: Reporting Services Report Parameters

Left by Gerry at 3/11/2005 9:40 AM
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

# re: Reporting Services Report Parameters

Left by Mark at 3/13/2005 5:07 PM
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.

# re: Reporting Services Report Parameters

Left by Bob at 3/14/2005 4:19 PM
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.

# re: Reporting Services Report Parameters

Left by Marinus at 3/15/2005 8:59 AM
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...

# re: Reporting Services Report Parameters

Left by Andy at 3/22/2005 7:41 PM
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.

# re: Reporting Services Report Parameters

Left by Andy at 3/24/2005 1:01 AM
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.

# re: Reporting Services Report Parameters

Left by Johnny D. at 3/29/2005 1:43 PM
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.

# re: Reporting Services Report Parameters

Left by Liany at 3/29/2005 9:47 PM
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?

# re: Reporting Services Report Parameters

Left by Vrushali Chaudhary at 3/30/2005 2:21 AM
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?

# re: Reporting Services Report Parameters

Left by Gerry at 3/30/2005 8:37 AM
Gravatar Now that is scenario I haven't thought of before. I'll have to look into it.

Gerry

# re: Reporting Services Report Parameters

Left by Daryl at 3/30/2005 4:04 PM
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

# re: Reporting Services Report Parameters

Left by sanhel at 4/21/2005 8:41 AM
Gravatar HOW CAN I ET A REPORT PARAMETER THAT IS A LISTBOX TO BE MULTIPLE SELECT ENABLED?

# re: Reporting Services Report Parameters

Left by sanhel at 4/21/2005 8:41 AM
Gravatar HOW CAN I ET A REPORT PARAMETER THAT IS A LISTBOX TO BE MULTIPLE SELECT ENABLED?

# re: Reporting Services Report Parameters

Left by sanhel at 4/21/2005 8:42 AM
Gravatar HOW CAN I SET THE REPORT PARAMETER THAT IS A LISTBOX TO BE MULTI SELECT ENABLED????

# re: Reporting Services Report Parameters

Left by Gerry at 4/23/2005 3:56 PM
Gravatar Are you referring to the parameter drop down that is provide by RS or one that you add to a form?

Gerry

# Q: Reporting Services Report Parameters

Left by Nezar at 4/24/2005 7:20 AM
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 ..

# re: Reporting Services Report Parameters

Left by Gerry at 4/24/2005 12:27 PM
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

# re: Reporting Services Report Parameters

Left by Nezar at 4/25/2005 8:03 AM
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

# re: Reporting Services Report Parameters

Left by Gerry at 4/25/2005 8:46 AM
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

# re: Reporting Services Report Parameters

Left by Gerry at 4/25/2005 8:50 AM
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

# Reporting Services Report Parameters (rendring through web form)

Left by Moosa at 4/25/2005 5:58 PM
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.

# re: Reporting Services Report Parameters

Left by Moosa at 4/25/2005 6:49 PM
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;

# re: Reporting Services Report Parameters

Left by Bob Fitz at 4/29/2005 6:44 PM
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?

# re: Reporting Services Report Parameters

Left by Diego at 6/3/2005 3:06 PM
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

# re: Reporting Services Report Parameters

Left by kate at 6/14/2005 1:33 PM
Gravatar HOW CAN I SET THE REPORT PARAMETER THAT IS A LISTBOX TO BE MULTI SELECT ENABLED

# re: Reporting Services Report Parameters

Left by kate at 6/14/2005 1:35 PM
Gravatar HOW CAN I SET THE REPORT PARAMETER THAT IS A LISTBOX TO BE MULTI SELECT ENABLED ..
Can you help me ASAP ?! Thanks

# re: Reporting Services Report Parameters

Left by RP at 6/22/2005 11:56 AM
Gravatar How do you pass a parameter from Reporting Services to SQL query (Dataset) for ORDER BY clause

# re: Reporting Services Report Parameters

Left by smy at 7/8/2005 4:50 AM
Gravatar rc:parameters=false....it works....thank you so much, Gerry for solving my problem.

# re: Reporting Services Report Parameters

Left by yrmeyer at 7/9/2005 10:10 AM
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

# re: Reporting Services Report Parameters

Left by Tomaz at 7/12/2005 6:17 AM
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

# re: Reporting Services Report Parameters

Left by Timur at 7/14/2005 6:37 AM
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.

# rc:Parameters:false Not Working!?

Left by Scott at 8/4/2005 9:36 AM
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

# re: rc:Parameters:false Not Working!? 8/4/2005 9:36 AM Scott

Left by Scott at 8/4/2005 9:37 AM
Gravatar OOps I mean I have &rc:Parameters=false in my URL.

# re: Reporting Services Report Parameters

Left by Khan at 8/8/2005 7:17 AM
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?

# re: Reporting Services Report Parameters

Left by Aditya at 8/8/2005 3:29 PM
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....

# re: Reporting Services Report Parameters

Left by Roman at 8/16/2005 1:07 PM
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

# re: Reporting Services Report Parameters

Left by Nick @ INDATA at 8/24/2005 9:42 AM
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)

# re: Reporting Services Report Parameters

Left by Dan at 9/2/2005 3:33 AM
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!

# re: Reporting Services Report Parameters

Left by Topgun at 9/12/2005 6:55 AM
Gravatar Is there any way to have multiple select like a listbox in the parameter dropdown.

# re: Reporting Services Report Parameters

Left by Girija at 10/3/2005 12:31 PM
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.

# Hiding Report Parameters

Left by Mark Fruhling at 10/14/2005 9:17 AM
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.

# re: Reporting Services Report Parameters

Left by Jusme at 11/3/2005 8:43 AM
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.

# re: Reporting Services Report Parameters

Left by Jack at 11/11/2005 1:03 PM
Gravatar The report parameters can be hidden by having a space(do not have it empty , press space bar) in prompt string

# re: Reporting Services Report Parameters

Left by Stuart at 1/24/2006 11:37 AM
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.)

# size Limit on Parameters

Left by Anil at 1/26/2006 4:29 AM
Gravatar I would like to know for sure,
whether there is a size limit on parameters or not?


Any help is greatly appeciated.

Anil

#  Sql Injection in Reporting Services Report Parameters

Left by Pramod Pawar (email: pramod3681@ at 1/26/2006 8:25 PM
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.

# re: Reporting Services Report Parameters

Left by Joshua (email: joshuaga@avanade. at 1/31/2006 3:01 PM
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.!!!!

# re: Reporting Services Report Parameters

Left by Asad at 2/22/2006 3:53 PM
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.

# re: Reporting Services Report Parameters

Left by Gerry at 2/22/2006 4:02 PM
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

# re: Reporting Services Report Parameters

Left by Jason at 2/24/2006 3:08 AM
Gravatar Need some help desperatly.
I have several drop down lists but an issue has come to light where they would like to pick more than one item from each list how do i do this???? Please help.

regards Jason

# re: Reporting Services Report Parameters

Left by Chris Wiegand at 3/3/2006 12:56 PM
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...

# Re: Reporting Services Change connectionstring

Left by Scott at 3/6/2006 10:45 AM
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.

# heterogeneous reporting

Left by Phil at 3/10/2006 5:23 AM
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.

# re: Reporting Services Report Parameters

Left by Oz at 4/17/2006 6:25 AM
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

# re: Reporting Services Report Parameters

Left by msu at 5/3/2006 10:44 AM
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!

# Creating Reports using Analysis Services Data Source

Left by Joel at 6/7/2006 10:08 AM
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?

# re: Reporting Services Report Parameters

Left by Chris at 6/8/2006 1:20 AM
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!

# re: Reporting Services Report Parameters

Left by Chris at 6/8/2006 11:02 PM
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.

# re: Reporting Services Report Parameters

Left by Henry at 6/23/2006 1:19 AM
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

# re: Reporting Services Report Parameters

Left by MIZOD at 7/12/2006 3:02 AM
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.

# re: Reporting Services Report Parameters

Left by Adrian at 7/24/2006 4:24 AM
Gravatar In your article you wrote: hiding the parameters is don by rs:parameters=false but it should be rc: parameters = false.

# re: Reporting Services Report Parameters

Left by Kaarew at 8/11/2006 5:40 AM
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

# re: Reporting Services Report Parameters

Left by upendra at 8/15/2006 9:55 PM
Gravatar could any one help me, how can increase width size of parameter dropdown in SSRS 2005......upendrap@aztecsoft.com

# re: Reporting Services Report Parameters

Left by Philip at 8/18/2006 4:10 PM
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.

# Reporting Services(2000) Report Parameters

Left by Raja at 8/24/2006 4:27 AM
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,

# re: Reporting Services Report Parameters

Left by Bab at 8/25/2006 1:31 AM
Gravatar Is it possible to increase the size of Textbox or dropdown in Report Parameter?
Thanks

# re: Reporting Services Report Parameters

Left by Vinod Agrawal at 10/7/2006 12:25 AM
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

# re: Reporting Services Report Parameters

Left by jewelfire at 10/17/2006 10:54 PM
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

# re: Reporting Services Report Parameters

Left by Frederick at 10/25/2006 1:29 AM
Gravatar Hi Gerry, Great info on the Reporting Services Report Parameters problem.

rc:parameters=false -solved my problem.

BR,
Frederick

# re: Reporting Services Report Parameters

Left by Amit Shrivastava at 11/11/2006 9:09 AM
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

# re: Reporting Services Report Rendring

Left by Amit Shrivastava at 11/11/2006 9:11 AM
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

# re: Reporting Services Report Parameters

Left by Gerry at 11/11/2006 9:32 AM
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?

# re: Reporting Services Report Parameters

Left by Ankan Pal at 11/20/2006 1:48 AM
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.

# re: Reporting Services Report Parameters

Left by San at 11/20/2006 12:59 PM
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

# Conditionally hiding Report Parameters: Reporting Services 2005

Left by Prachi at 11/23/2006 4:52 AM
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

# re: Reporting Services Report Parameters

Left by Ross B. at 12/18/2006 10:47 AM
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.

# re: Reporting Services Report Parameters

Left by UmaMohan at 1/3/2007 11:34 AM
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.

# re: Reporting Services Report Parameters

Left by YosiP at 1/24/2007 4:52 AM
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!

# re: Reporting Services Report Parameters

Left by Nirupa at 2/14/2007 9:09 PM
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

# re: Reporting Services Report Parameters

Left by krupali at 2/16/2007 12:57 AM
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

# re: Reporting Services Report Parameters

Left by webmoneymon at 2/19/2007 12:17 PM
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

# re: Reporting Services Report Parameters

Left by May at 2/26/2007 10:01 AM
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

# re: Reporting Services Report Parameters solved for me

Left by webmonkey at 3/1/2007 5:16 AM
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.


# ReportViewer WinForms Report Parameters

Left by Luka Gospodnetic at 3/16/2007 12:03 AM
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.

# re: Reporting Services Report Parameters

Left by Donovan at 3/27/2007 9:49 AM
Gravatar here's another tip: if your parameter is query-based, it will be ignored in the url.

# re: Reporting Services Report Parameters

Left by Jaya B.Rayasam at 3/28/2007 12:18 PM
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

# re: Reporting Services Report Parameters

Left by Binabik at 4/4/2007 4:41 AM
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.

# re: Reporting Services Report Parameters

Left by Jay Dixit at 4/6/2007 4:44 AM
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

# re: Reporting Services Report Parameters

Left by Jagathesh at 5/5/2007 5:47 AM
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.

# re: Reporting Services Report Parameters

Left by Alberto at 5/31/2007 3:53 PM
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

# re: Reporting Services Report Parameters

Left by Riyath at 6/1/2007 9:19 AM
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...

# re: Reporting Services Report Parameters

Left by jluc at 6/12/2007 7:35 AM
Gravatar append "&<Param>=xxxx" to your URL
Jluc

# re: Reporting Services Report Parameters

Left by UN4G1V3N at 6/13/2007 2:14 AM
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....

# re: Reporting Services Report Parameters

Left by David at 6/14/2007 2:29 PM
Gravatar How would I set a default value to TODAYS DATE in a report parameter ?

Thanks.

# re: Reporting Services Report Parameters

Left by praveen at 6/27/2007 12:27 AM
Gravatar How to display two sub-report in same report page where Sub report parameter depend upon the main report.

# re: Reporting Services Report Parameters

Left by HHoward at 7/6/2007 11:34 AM
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.

# re: Reporting Services Report Parameters

Left by Anonymous at 7/6/2007 11:50 AM
Gravatar David -- in order to default your parameter to today's date, use 'Now'. i.e.:

cDate(FormatDateTime(Now, DateFormat.ShortDate))

# re: Reporting Services Report Parameters

Left by MarkB at 7/11/2007 8:16 AM
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?

# Q: Reporting Services - blank Page suppres

Left by Anwaar at 7/12/2007 2:45 AM
Gravatar Hi All,
How to suppress blank page in SQL Reporting?
Can you help out from this issue.

Thanks
Anwaar

# re: Reporting Services Report Parameters

Left by MarkB at 7/12/2007 2:22 PM
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.

# Reporting Services Report Parameters

Left by Codi at 7/20/2007 9:11 AM
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”.

# re: Reporting Services Report Parameters

Left by Shelia at 8/23/2007 11:49 PM
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.

# re: Reporting Services Report Parameters

Left by Sriram at 9/19/2007 4:37 AM
Gravatar Is it possible to decrease the size of Textbox or dropdown in Report Parameter?
Thanks

# re: Reporting Services Report Parameters

Left by Shyamala Shankar at 9/19/2007 6:35 AM
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

# re: Reporting Services Report Parameters

Left by muz at 9/26/2007 8:37 PM
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...





# re: Reporting Services Report Parameters

Left by senthilnathan at 11/13/2007 5:42 AM
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

# re: Reporting Services Report Parameters

Left by Dan at 11/15/2007 5:37 AM
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

# re: Reporting Services Report Parameters

Left by mansor at 11/27/2007 1:04 AM
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

# re: Reporting Services Report Parameters

Left by David at 12/7/2007 12:43 PM
Gravatar Thanks for the <Prompt></Prompt> tip. That did the trick for me.

# re: Reporting Services Report Parameters

Left by Lokesh at 12/26/2007 4:09 AM
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

# re: Reporting Services Report Parameters

Left by Gideon at 2/16/2008 6:02 PM
Gravatar i am trying to set a default date parameters for my RS 2005 Report using report manager. any help?

# re: Reporting Services Report Parameters

Left by Dhaval Patel at 3/8/2008 4:02 PM
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

# re: Reporting Services Report Parameters

Left by Sudheer Kumar Kondragunta at 4/9/2008 11:32 AM
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

# re: Reporting Services Report Parameters

Left by Paresh at 4/11/2008 6:32 AM
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

# re: Reporting Services Report Parameters

Left by Leema at 4/16/2008 3:32 AM
Gravatar How to display a datetime picker or calendar with textbox in filtering in Report server project

# Reporting Services Report Parameters

Left by Srini at 5/9/2008 4:44 AM
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

#  Reporting Services Report Parameters

Left by srini at 6/3/2008 6:08 AM
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?


# re: Reporting Services Report Parameters

Left by cris at 6/18/2008 5:52 PM
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

# re: Reporting Services Report Parameters

Left by Alejandro at 7/1/2008 5:09 PM
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

# re: Reporting Services Report Parameters

Left by mzmishra at 7/10/2008 8:57 AM
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.

# re: Reporting Services Report Parameters

Left by woeleman at 7/17/2008 1:45 PM
Gravatar to cris...

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

In(@yourparameter)

# re: Reporting Services Report Parameters

Left by dan at 7/22/2008 11:21 PM
Gravatar to mzmishra:

try this ..

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

hope it helps.. :)

# re: Reporting Services Report Parameters

Left by indy at 7/28/2008 3:57 PM
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.

# re: Reporting Services Report Parameters

Left by Twisted.Mellow at 7/29/2008 6:04 PM
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.

# # re: Length of parameter to a report

Left by Avinash at 8/1/2008 1:47 PM
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..!!!!

# re: Reporting Services Report Parameters

Left by buddha at 8/28/2008 3:43 PM
Gravatar can any one tell the syntax to pass mutiple parameters to a mDX query

# Reporting Services change connection string

Left by Niurka at 9/12/2008 10:23 AM
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

# re: Reporting Services Report Parameters

Left by filipe at 10/20/2008 12:14 PM
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!

# re: Reporting Services Report Parameters

Left by Saurabh at 11/26/2008 7:35 AM
Gravatar Hi

I have a report parameter of string type for which I want to pass non queried values.
The situation is like for

Label Value
ABC 'DEF','GHI'
BCD 'UVW','XYZ'

I have a data set query in which I am passing this value inside in parameter. But when i execute it it doen not run and shows null records.

I have also tried removing the quotes and then running the report but the result was same.

Can anyone help me out , how can we pass multiple non queried values to a single label of report parameter in SSRS?

# re: Reporting Services Report Parameters

Left by Syed at 11/27/2008 2:42 AM
Gravatar How Can I Dynamically set the Report Parameters?.

# Multiple parameter in reporting services

Left by Vikash Mishra at 12/3/2008 4:52 AM
Gravatar How to use Multiple parameter in reporting services.

# re: Reporting Services Report Parameters

Left by Jackie at 1/28/2009 10:08 AM
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????

# re: Reporting Services Report Parameters

Left by DCoppock at 2/19/2009 8:29 AM
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?


# re: Reporting Services Report Parameters

Left by Besim Ismaili at 3/12/2009 5:57 AM
Gravatar how to change parameter filed from drop-down to a normal text field...
best regards,
Besim

# re: Reporting Services Report Parameters

Left by kapil dangey at 3/17/2009 9:37 AM
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

# re: Reporting Services Report Parameters

Left by Sheetal at 5/17/2009 11:43 PM
Gravatar The parameter setting through the reports manager helped. Thanks a ton!

# re: Reporting Services Report Parameters

Left by James at 6/16/2009 6:55 AM
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

# re: Reporting Services Report Parameters

Left by quang cao online at 6/19/2009 4:08 AM
Gravatar Reporting Services use Multiple parameter. That's right,

# re: Reporting Services Report Parameters

Left by quang cao online at 6/19/2009 4:12 AM
Gravatar Great article, thank you.

# re: Reporting Services Report Parameters

Left by Ladik at 7/1/2009 7:25 AM
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....

# re: Reporting Services Report Parameters

Left by Dan Timor at 7/2/2009 2:30 AM
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

Your comment:





 

Copyright © Gerry O'Brien

Design by Bartosz Brzezinski

Design by Phil Haack Based On A Design By Bartosz Brzezinski