.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

Convert crystal expression to ssrs

Posted By:      Posted Date: September 14, 2010    Points: 0   Category :Sql Server
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

View Complete Post

More Related Resource Links

Expression help Crystal to SSRS 2008


How would i convert this expression to SSRS/

1.) Sum(Qty),Reportnumber))


something like this is not working for me



 Crystal Sum(qty),@Rackstatus))

Tryin to use it for SSRS like this? @Rackstatus is an expression which i already converted to SSRS

sum(fields!qty.value), sum(


Can you help ?


Fields!RACKNUMBER.Value &

"-" & Fields!INVENTORYSTATUS.Value))??????

Crystal Report vs 2003 convert to vs 2008 parameter problem


Hi friend,

I have a project develop with Visual Studio 2003, when i convert the project to Visual Studio 2005 is work well. But when i convert to Visual Studio 2008, the crystal report when have pass parameter will prompt the parameter field to re-type then show the report.

But in this converted project i create a new report and pass the parameter is ok. That means i wan re-do all report @.@??

Does someone can help me solve this problem??

Thank you

Converting crystal reports to ssrs reports

Hi, I need a documentation which helps me to convert crystel reports to ssrs. if any one having the procedural documentation you can email to my below mentioned email address that will be helpful to me in my new starting project. naveenjustlikethat@hotmail.com

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:)

Migrating from Crystal Reports to SSRS

Hi, we are currently evaluating SSRS and its features for making a decision on migrating from Crystal. I have read up on SSRS a bit and just need some confirmation on some of my findings. My company develops Windows applications, distributable via MSI files. The backend is SQL Server 2008. We are currently using Crystal Reports to display reports to the end user using the Crystal .NET viewer control. Crystal Reports are saved as .rpt files and contained in the msi file, therefore deployed to the clients. As we are considering migrating away from Crystal, I had a look at SSRS. It is my understanding that there are two ways of using reports: First, in local mode, which is similar to the way Crystal works: Client-side deployed report files. However, unlike Crystal, the application has to retrieve the data for the report from the database and pass a dataset to the viewer control whereas in Crystal, you just point the report viewer to the database you want to use and it pulls the data itself. The other mode, remote or server mode, has the reports stored in the report server (i.e. SQL Server). The viewer control will be set to the URL of the report, and the report then pulls the data from the SQL database. I am unsure to how you could deploy reports onto the Report Server using a MSI package; it sounds like quite a bit of work as the only way I have found by now is to consume webs

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??

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

Convert Xml content from a Dataset to another Dataset for SSRS report?

Hi All Does anybody know how to convert xml field from SQL Query to Dataset? For example I have a table T with Fields A(VARCHAR), B(INT), & C(XML). Field C has <test><row>ROW 1</row><row>ROW 2</row></test> I make a query to get this data and call this Dataset1 Now I want the Column C content to be converted into a dataset  call it Dataset2 so that I can drag and drop tables from there to make my reports. Is it possible to do it without using webservice?Another limitation I have, I should not have to connect to DB again, so this boils down to use the already data contained in Dataset1. I was trying to somehow embed this XML content in the query at runtime dynamically? I am currently looking for a way to use the Dataset1 as the datasource and and parse the XML content of Dataset1 to Dataset2. Also, is it that XML content needs to hardcoded in the query, can't we do it dynamically and run the query?

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?


Schedule SSRS, convert to Excel, and email


We need to schedule an SSRS 2008 report to run every night at midnight, then have it converted to Excel and emailed to 4 predefined users.

DB Architect

How to convert string to expression


I am having an string "3<2", I would like to use it in a if statement as if(3<2).

How to convert this string into an boolean expression.

Can we convert a string like "a<b" into a boolean expression.


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.



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




differences between ssrs reports and crystal reports


as u all know about ssrs reports...
now i'm using the crystal reports 
and i want to go through ssrs reports
can anyone answer the following question. 
1)what is the need of ssrs...

differences between ssrs reports and crystal reports


as u all know about ssrs reports...

now i'm using the crystal reports 
and i want to go through ssrs reports

can anyone answer the following question. 
1)what is the need of ssrs...
2)and why we should use ssrs..,
3)what are the advantages
4)what are the disadvantages
5)how it will on work  webapplication..
6)how much loadtime it will take by server
7)whether it is a lightweight application or heavyweight..
8)what the problem that we face in future..

please help me  it'll be very helpfull for me

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