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

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

SSRS Format Codes

Posted By:      Posted Date: September 29, 2010    Points: 0   Category :Sql Server
Where can I find a list of all the format codes, complete with their definitions?

View Complete Post

More Related Resource Links

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.

Blank page while exporting the SSRS report to PDF format

While exporting SSRS report to PDF, I am getting blank page in between and at the end also. The report page size is set to 8.75in x 15.00in with 0.02in margin from left, right, bottom and top. I tried in changing the tablix and rectangle box "KeepTogether" property also. In both the case (true/false), I am getting blank pages. Can anyone help me out?

SSRS 2005 Render Format Excel Issue with Time Field


I have a report that uses a datetime field but gets populated only with the time. So, in SQL db, it gets stored with a default date value of 1899-12-30 12:01:01 with the correct time filled in. Report in SSRS Preview mode displays the value just fine when I use the Time format in Layout mode. I build and deploy and able to view the report in a web browser with no problem displaying the time field. But when I subscribe to the report and choose Excel render format, when I open up the Excel file from the email that was sent, I get negative decimal values. I have tried every possible Time format in SSRS but I get the same result. I also tried just the default and still gives me negative decimal values that show up as ####### in Excel.

Any help will be greatly appreciated. Thanks

SSRS Dashboard in exe format


Hi All

I am new to SSRS - I have to create a Dashboard and import it into an exe file.

How to generate the SSRS report into an exe file - so when they run it - the report generates and autorefereshes itself every 60 sec.

Please advise me how to do so.

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 - Date Format & Parameters Refresh.



I am using SSRS 2005 with Enesys Add on Tool for reports.

I have used date format as "dd-MMM-yyyy" in the application and used the same in the report.

Issue : 1

I want to convert this format into a format where i can sort the date fields as and when exported to excel sheets.

Issue : 2

Some of the values are null and when exported to excel cant see the null values. I am using Format function in the conversion so that if the value is nothing, show nothing or show the value.

Need to resolve this as when the report is exported to excel i can see null values or squares in the columns when applying filters.

Issue : 3

The input paremeters are refreshed everytime i select a new value in other parameters. There is no dependency on the input parameters.

Please help me out in resolving these issues ASAP.

Need to submit these today EOD.

Thanks in Advance. 


SSRS Date Format in Parameters



Can we change the date format in the default parameters pane.(For eg : When we create a new parameter and select datatype as date time in report parameters.)

Default settings for this date picker control is mm/dd/yyyy.

I need to change the date to dd/mm/yyyy.

Is it possible to the change this date format to dd/mm/yyyy or any other custom format?

Thanks in Advance.

SSRS Format Expression w/ Dashes


I have a filename field that contains text such as:  data/0123456789ABCDEFG.txt

Does someone know of an expression that can format it as this: 

data/0123456789ABCDEFG/0123456789-AB-CDEFG.index.htm               ?

So, it would be adding the original field again and formatting it with dashes?

Hope that makes sense....




I hear and I forget. I see and I remember. I do and I understand.

Date format in SSRS



I am using expression for date field:

=Fields!START_DATE.Value +

"-" + Fields!EXPIRY_DATE.Value

and it is displaying format like 12/31/2009 - 12/31/2010

So, How can i make it change to look like "Dec 2009 - Dec 2010"

I tried doing it from format but it is not taking into effect for that expression above. still it displayed the same format. any idea?

SSRS 2008 R2 - datetime parameter "visually" format?


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.

How To Set a Date Format In GridView Using ASP.NET 2.0

A very common desire is to set a column of a gridview to display just the month, day and year of a DateTime type. The problem is the by default, the HtmlEncode property of the boundfield attribute (
The problem is that if this field is enabled, you can not pass format information to the boundfield control. That is, if you try the following code, you will not get the desired result.

How to format and update GridView and DataGrid rows using JQuery

The behavior described in this question is as expected. When you set text of a cell in grid, it directly affects HTML that is going to be rendered. When you set text value of a cell, it means that you are setting innerText of the cell. The column that GridView creates for command fields (Edit, Delete and Select) are a (anchor) or button elements. So you can see what will happen if you set text value in that cell. It will wipe out those link or button controls and replace them with simple text string.

How to format datetime & date with century?

Execute the following Microsoft SQL Server T-SQL datetime, date and time formatting scripts in Management Studio Query Editor to demonstrate the usage of the multitude of temporal data formats available and the application of date / datetime functions.


Program for Format Conversion of An Image

.NET provides extensive support for image conversion. Any image can be processed from one format to another. Most common formats to which .NET have support for are .BMP, .EMF, .GIF, .ICO, .JPG, .PNG, .TIF and .WMF.

Get pixel format, raw format, property id list and property items image in VB.net - C#.net.

n this simple article you will learn that how we can get pixel format, raw format, property id list and property items image in VB and C#.net.

Get Pixel Format:

Image consists of pixels to get the format of the pixel we have a property named pixel format. This property returns an enumeration of pixel format. This enumeration tells the pixel format.

To demonstrate make a window application. Drag one button and a picture box on form.

Now write the following code on Button click event:

Format Generic List Bound to Gridview


I have a generic list of a custom type. The custom type has a string and double.

I'm binding the list to a gridview and it outputs everything fine.

I'm trying to format the double column into a currency format. It is in a template field as I'm calculating a running total. I pass the value to a function that returns a double and adds the current value to a running total which I will show in the footer.

The format is not changing to currency as expected when using String.Format("{0:c}", GetTotal(Convert.ToDouble(Eval("Amount"))))

Any ideas on what might be going on and how to fix this?


Writing codes using three tier architecture.


Hello all.

I am a beginner in c#.I heard that writing program with three tier architecture are easy and maintainable.

I just wanted to know with a small example on how to write three tier architecture programs.

Thanks :-)

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