.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SSRS 2008 R2 - datetime parameter "visually" format?

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :

Hi, I have SSRS 2008 R2 in SharePoint 2010 integration mode.

My report has Date/Time data type parameter. When user open report, "visually" date format is MM/DD/YYYY, but I would like to have DD/MM/YYYY format (same if user pick date from Calender drop-down date selection). Any idea (like is it Report Server region settings or SSRS settings OR SharePoint date settings OR ... ).

Any idea how to "visually" shows date parameter as DD/MM/YYYY format? Thank You.

View Complete Post

More Related Resource Links

Data validation for datetime parameter in SSRS

Hi,   I wanted to know more about validation of SSRS parameters. I have a simple report which has a parameter called startdate of DateTime datatype. The datetime parameter in SSRS takes manual input as well. So, the user can enter any junk value. I want to ensure that the input parameter is in correct format and I want to display an error msg when the format is incorrect. My report has the following VB code for validation:   Public Function Validate( ByVal startdate As String) As BooleanIf IsDate(startdate) = True Then Return TrueElse Return FalseEnd IfEnd Function   And my report has a textbox which has the expression property set to; =Code.Validate(Parameters!startdate.Value) the textbox on the report has to display if the entered date is valid or not.   But, when i enter an erroneous date, SSRS doesn't render the report and throws a generic error. This happens even before the code written for validating the parameter executes.   Also couldn't find a way to disable the manual input for the datetime parameter. Even that would solve the problem.   Another alternative was to make the startdate parameter as string, but i want the calendar control button to be provided for the user.

ssrs 2008 R2 - report parameter with no default set throws java script error

We have recently upgraded from SQL Server 2008 to SQL Server 2008 R2....I am experiencing a problem with my report parameters on my SSRS reports. It seems that my report parameters that I do not have a specified 'default' value throws a java script error when I try and run/render the report under R2.  As soon as I put a 'default' value on the report param, everything is fine.  However, that is not the behavior we need for our reports...the user needs to pick their selection. Can anyone shed some light on this, it seems to be an AJAX problem...I need to be able to have report parameters with a list of values, but no 'default' value on the parameter.

SSRS 2008 Export to PDF fails for large data with System.Exception: Parameter is not valid

Hi, We are working on Range Bar Chart using SSRS 2008. The report has huge data. It is properly displaying the data, but when we tried to export to pdf it is failing with the following exception. Exporting to excel works fine. Also if the report has small/medium data it is property exporting to PDF. It is failing only in case of huge data (we have custom page size of 28" X 14"). Of course the report has lot of expressions we used to customize the colors/text as per our requirements.   Server Error in '/Reports_SQLDEV2008' Application. Parameter is not valid. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Exception: Parameter is not valid. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:   [Exception: Parameter is not valid.]   [Exception: An error occurred during rendering of the report.]   [Exception: An error occurred during rendering of the report.]    Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream ou

Format Datetime Parameter Label

I'm trying to format the label of a parameter which is populated by a dropdown in SQL2008 RS. Essentially, i want to put a title in the report which puts the date in the format dd MMM yyyy. I have tried the following options with no luck: =Format(Parameters!MyDate.Label, "dd MMM yyyy") =Format(CDate(Parameters!MyDate.Label), "dd MMM yyyy") Can this be achieved in this way? I "could" reformat the data in the dataset, but i'd rather explore this avenue first. TIAevery day is a school day

Is SSRS 2008 supports exporting to .xlsx format instead of .xls

I have MS Office 2007 installed in my machine. when i export SSRS 2008 report to Excel, i need to save in .xlsx format rather than .xls format. what settings we need to do. pls give me the solution for this. Thanks in advance.

Format Code D0 is not working in SSRS 2008


We are trying to migrate all our RDL from SSRS 2005 to SSRS 2008.

In the rdl’s we defined format code for a  text box as “D0”  which is working fine in SQL 2005.

While migrating the rdl’s to 2008 it is not working and data is showing for that text box as “#Error”.

How to resolve this . I am having around 1000+ rdl’s to update with proper format string.

If I open the Rdl in BIDS I am getting below error.


[rsInvalidFormatString] The Format value for the textrun ‘textbox1_0_13.Paragraphs[0].TextRuns[0]’ is not valid. Format specifier was invalid.

[rsRuntimeErrorInExpression] The Value expression for

SSRS 2008 Cascading Parameter Problems


We are having a problem with dependent parameters.  Has anyone see something like this with ssrs 2008?  It is a show stopper for us.  After everything tested out ok (or with only minor gui bugs), we set a date to roll this to production.  With this recent discovery, we are unable to move forward until it is resolved.  We didn't notice it since there are a small number of our 400 some reports that do this type of thing.  Unfortunately, they are the most important in our organization.  These worked without a problem in 2005.

Sample below:

 ReportMode (depends on what is selected in RunAsUser)

Avail: ID from ReportModeDataSet

Default: ID from ReportModeDataSet

 Location (depends on what is selected in ReportMode)

Avail: ID from LocationDataSet


SSRS 2008 - Report Parameter is read only


I have a main report that has two parameters (RptMonth, Reports).  RptMonth which the user selects from a calendar, and Reports which is a dropdown list. Produces main report correctly.

I want to goto a second report (Detail) based on clicking a textbox named KPI. I configured the textbox to Go To Report, added this parameter named ID value [ID] that is in the dataset of the query. Parameter settings - Name=ID, datatype=Integer, parameter visibility=hidden.

Get values from query=Dataset1, value field=ID, label field=KPI. Using always refresh. This is all configured in the main report. In the detail report I have one parameter named ID,  type Integer, visibility=hidden.

Security for both reports use embedded connection, type SQL server. When I run the main report and click on the KPI textbox it passes the ID and I get the correct detail report. When I deploy it to the server I get

SSRS 2008 R2 - Parent Child Hierarchy - Searchable Parameter List


Hi dear,

I'm, workin at the moment on a report for my company. I have a problem with searching in a parameter list which is based upon a parent child hierarchy. The users asked me for type in the first few characters to search the parameter faster (like in this post ) , because it's a large hierarchy with about 1700 values. In a "normal" list ("linear" without  a hierarchy) this feature is available.

So my question:

Isn't it possible to search in the parameter list in general if this is based upon a hierarchy?

Are there any possibilities or suggestions to get this feature?

Or is this the only way to do this:



Thanks in advance!


Any way to change the icon to toggle the parameter panel in SSRS 2008 R2?


Is there any way I can change the icon that the HTML viewer in SSRS 2008 R2 uses to toggle the parameter panel?

I have users telling me it is too small and they want it bigger.  When I look at the page with the IE developer toolbar, the icon looks like it is being pulled from a resource inside ReportViewerWebControl.axd,

SSRS 2008 datetime parameters



I am trying to design a report that has a parameter named Time Period which, essentially, has the following available values: Last 24 hours, Last 7 days, Last Month, etc.  I have two other datetime parameters named Start Date and End Date which are going to specify the date ranges for which the report will select the data.

The Time period parameter is needed so that if the user specifies "Last Month", for example, the Start Date and End Date parameters automatically refresh to show the date ranges for the last month.  More so, the user can still be able to specify a different date range that they can pick from the calendar picker.

I have encountered several issues in trying to make this work:

  1. If I only specify a default value to the start date and end date parameters, it will only refresh for the initial run, but will not refresh every time I change the Time Period parameter selection.
  2. If I specify "Available Values" to the datetime parameters, then the parameter will turn into a dropdown field and the user will not be able to choose any date from the calendar picker.

I found a work around for this issue by creating an intermediate parameter and every time I change the time period option it will refresh the parameter since it has a stored procedure assigned

Enable/Disable of Report parameter in SSRS 2008


Hi Friends,


I am stuck with one reporting issue and need your  help on that.

The source of the report is SSAS Cube.


I have 3 parameters





SSRS 2008 dynamic change to report parameter properties


I'm running SSRS 2008, and I'm wondering if it is possible to change a report parameter property based on user input in another report parameter.  What I need to do is to make report parameter #2 a required parameter if a specific value is selected in parameter #1.  Parameter #2 should be optional under all other scenario.

Thanks in advance.

SSRS 2008 w/CU6 - Parameter Default Value Refresh Issue.



We are experiencing trouble with a parameter default value (parameter 2) not refreshing when it's parents parameter value is updated (parameter 1).  The problem parameter (2) has specified values in the available values, and has a dataset that loads the default values depending a parameter above it.

The first time that parameter 1 is selected, parameter 2 is updated with the correct default value... BUT, when parameter 1 is changed, parameter 2 does not update.

If I change the problem parameter's (2) available values to the dataset where the default values come from, it works fine, but that doesn't fill the business requirement of this report.  I also tried setting parameter 2 properties to "always refresh" but that doesn't appear to refresh the default values.

What else can I try?








Sorting Parameter Value in Report From SSRS Report Model in 2008 R2


I have created a report model in 2008 R2. Now, when I am trying to create a report from the report model, I having trouble in sorting the parameter value in multiselect dropdown list.

I have tried setting Attribute Property Sort Direction as Descending , but it always comes up as Ascending.

Any suggestion would be highly appreciated.



Urgent!!!How can we sort the parameter list in report created using report model in ssrs 2008 r2?


How can we sort the parameter list in report created using report model in ssrs 2008 r2? Do I need to change some property in Model or elsewhere?


SSRS 2008 - Passing parameter into textbox - can't seem to apply formatting to it (date/currency)


I have a report that is displaying a parameter in a textbox inside the report.

Now I right clicked on the textbox, went to properties, and set number formatting to: Date - 01/31/2000

However, when I render the report it does not display the date in that format. It displays it in the way the sproc returns it which is: 5/13/2011 3:08:30 PM

I tried changing the parameter type to TEXT instead of datetime, made no difference.

I am having the same problem with currency. I will return 12345 and it will just display that way in the textbox instead of $12,345.00.

Any suggestions?

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend