.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 Expression w/ Dashes

Posted By:      Posted Date: October 27, 2010    Points: 0   Category :Sql Server

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.

View Complete Post

More Related Resource Links

Expression for 24 hours time and date in SSRS

Hi Guys, What is the expression for  displaying 24 hours time and date in SSRS? Is this the format: =Format(now, "MM/dd/yyyy HH:mm:ss")?Thanks Shiven:)

SSRS BUG? When a FontStyle expression is used in a report, the Browser Text Size setting overrides t

I have created a report that has the same font size for all the sections in the report. Some sections' fields use a FontStyle expression that changes the FontStyle between Normal and Italics conditionally. I run the report through the reportserver interface and the report looks fine. I run the report through the ReportViewer control and the the fields which use the FontStyle formula are overridden by the Browser's Page Text Size. Also, when I look at the inline HTML Style that's generated, the fields with the formula don't have a style, they are blank, while the fields with without a FontStyle expression have an inline HTML Style generated. And this is probably why the browser text size setting can override. This seems like a ReportViewer HTML render bug... Or is there a way around it??

Convert crystal expression to ssrs

Hi, I am new to crystal to ssrs converstion. could any one please convert the below expression to ssrs. Local StringVar strPaidDate := ToText({CLM153_CLMS.Paid Date Key}, "0"); strPaidDate := Mid(strPaidDate, 5, 2) & "/" & Right(strPaidDate, 2) & "/" & Left(strPaidDate, 4); strPaidDate & chr(10) & {CLM153_CLMS.Primary Group Identifier} & chr(10) & {CLM153_CLMS.Class Plan Identifier} & chr(10) & {CLM153_CLMS.Product Identifier} Thanks, Naveen kumar.Y

Checking weather a chart is hidden or displayd by using an Expression (SSRS 2008)

Hello, I want to check weather a chart is hidden or displayd by using the Expression of a Text Box that toggles display of that chart. Therefore I need to call the chart in the Expression. Something like this: =IIF(ReportItems!Chart2.Hidden = False ... But obviously charts are not regarded as report items by ssrs!?!? Thanks Axel

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 2005 - Expression Results


The table being used for my report contains 2 months worth of data. When viewing the report, the report shows results for both months even though I have the following expression. What am I doing wrong?


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

Regular Expression for Canonical address format for phone numbers?

The canonical address format is a universal (international) phone number format and it's pattern is as following:

+ Country/RegionCode (AreaCode)SubscriberNumber

+1 (425) 555-0100

I need a regular expression that supports this?

how to use split in iif conditional expression in ssrs 2008 r2



how can i use conditional iif combined with split?

i'm trying to get values from check boxes(from sharepoint custom list), the condition is like this :

if the value is null/blank, the return value would be "-"

if the value is not blank, the return value would be the value of the check box field that already splitted from the ";#" character

as you might know, values from check box is written along with ";#" character before and after the value itself.

i tried to use this expression:

=IIF(Fields!Action__For_User_Access_.Value Is Nothing," - ",(Split(Fields!Action__For_User_Access_.Value, ";#")(1)))

the split worked just fine, but the conditional iif didn't work.

can anybody help me?

i used that expression in the calculated field.

btw, i'm using report builder content type from ssrs 2008 r2


thx in advance.



SSRS Format Codes

Where can I find a list of all the format codes, complete with their definitions?

Partially Bold Text in SSRS 2005 using Expression ?



I am using SSRS 2005.

I have one requirment. I need to Partially Bold some part of Text in column.

Below is the Example.

Name < - -- Column in SSRS 2005 Report.

This column contains combination of Last Name and First Name. All Database record contains Last name , while in some record our requirment is to append First Name with that.

That is i aleady handled using Nested IIF Expression.

Now, i want to display appended First Name in normal while all Last Name whihc is Database Field in BOLD Font.

How is it possible ?


SSRS 2008 R2 - Line chart labels - visibility based on expression?


I would like to control the visibility of a data label in a line chart using an expression. For example, I have a requirement to show the data label for two compariable data points in a line chart where the horizontal axis is time (Q1, Q2, Q3, etc...) and the data points are determined based on a selected parameter. The basic idea is that a user can select to view Q3 as the end point of reporting and the chart will graph a complete time line (e.g. FY 2001 thru FYXX Q3) but only show the label for Q3 and prior year Q3.

I have tried to build an expression in the visibility property of 'Chart Series Labels' but this does not appear to work.


Loop in SSRS Expression


Hi guys,

I got a multi value parameter which displays all my 'companies'.  On my report header, I wish to display all the companies selected by the user.

Parameters!Company.Label(0) only shows the first on selected

Please, any help will be greatly appreciated


W Wilmot




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. 


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