Post New Web Links

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

Posted By: Posted Date: September 28, 2010 Points: 0 Category :Sql Server

hi,

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.

-willy-

View Complete Post

More Related Resource Links

Using Conditional Split data Transfer in SSIS 2008

This article uses the Integration Services Conditional Split Data Transformation element to filter and transfer data from a set of flat text files to SQL Server database table. The concept can be easily extended to apply to any other source or destination such as Microsoft Excel. This scenario is useful in creating denormalized database tables in a reporting and analysis situation.

SSRS 2008 Conditional Column Visibility Whitespace Issue

Hi Everyone,I am using IIF statements to show/hide tablix columns based upon a parameter value. These statements are used as expressions in the visibility properties for the columns.If the parameter value is one that causes the column to be hidden, the coulmn does not appear on the report, but there is whitespace in its place.I have used this functionality very frequently in SSRS 2005 without the whitespace issue. The 2005 report automagically closed this whitespace up by moving the column to the right of the hidden one to now be adjacent to the column to the left of the hidden one at rendering. This is what i need to happen now in 2008.Has anyone else experienced this? If so, would you please share your solution? I am getting extremely frustrated by this...Thanks!!

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

SSRS 2008: Multiple Sub-Reports with conditional visibility in one List control

MainReport: a List containing two Sub-Reports. The data of the List only has two rows. Set the visibility of the sub-report based on the data.

SubReport1: a textbox showing "Sub Report 1"

SubReport2: a textbox showing "Sub Report 2"

I expect to see SubReport1 in Page 1 and SubReport2 in Page 2.

But I only see SubReport1 in Page 1 and Page 2 is a blank page.

These reports work in SSRS 2005, but not in SSRS 2008.

Thanks.

Report Definition:

MainReport.rdl:

<?xml version="1.0" encoding="utf-8"?>
<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner

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.

Conditional Split Expression

Hi Guys,

My input columns are

TotalSales Trans_Type

-0.10000000000000001 S

0.10000000000000001 S

-0.10000000000000001 V

-0.20000000000000001 S

I need to separate all the negative rows, according to trans_type. I am using below expression none of them are working.

Expression used:

Trans_Type = S

DataType = String

TotalAmount = Negative field

SUBSTRING(TotalSales,1,FINDSTRING(TotalSales,"-",1)) > 0 && Trans_Type == "S"

SUBSTRING(TotalSales,1,FINDSTRING(TotalSales,"-",1)) == "-" && Trans_Type == "S"

Output Required whenever Trans_Type is S and negative in amount I need to slit those row.

TotalSales Trans_Type

-0.1000000000

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

Sum(fields!qty.value),Sum(fields!reportnumber.value)

2.)

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 ?

IIF (ISNOTHING(Fields!INVENTORYSTATUS.Value),Fields!RACKNUMBER.Value,

Fields!RACKNUMBER.Value &

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

Is Conditional Subscription possible in SSRS 2005?

Hi Guys,

Is there a way to set up a subscription that will send e-mails based on the contents of a report? For example, I want to schedule a daily subscription that will only send an e-mail if the report contains data, otherwise it will do nothing for that day. i.e If the report has more than one row, it should send the mail otherwise it should not send the mail.....

Is it possible in SSRS 2005 or is there any other way to do it???

SSRS 2008 R2 and sharepoint 2007 report builder problems

I upgraded our enterprise sql server 2008 to sql server 2008 r2 last weekend. Along with this i installed the report builder 3.0 on the servers as well and the updated ssrs add in for sharepoint. The upgrade went fine, no errors that i could find. The problem is now when i go to a library that has the report builder content type enabled and click report builder report under new it does not load report builder 3.0.

I updated the custom report builder url in central administration from /_vti_bin/ReportBuilder/ReportBuilder_2_0_0_0.application to /_vti_bin/ReportBuilder/ReportBuilder_3_0_0_0.application

however when i do click the new report builder report it kicks me over to http://company.com/ReportServer_MossEnt which itemizes out each individual sharepoint site in the farm.

Is the integration of ssrs 2008 r2, sharepoint 2007 and report builder 3.0 work? did i install the wrong version of the report builder add in? The above is the only problem i am having now.

all servers are server 2008, 64 bit and moss 2007 enterprise with sp2 & april 2010 cu

SQL 2008 servers and MOSS 2007 with SSRS

I need help figuring out the limitations in a multi-database server environment and MOSS 2007 installation with SSRS. Here is the run down:

I currently have MOSS 2007 server with backend on SQL 2005, which also acts as the SSRS server. In addition I have another SQL 2005 server where business data resides and against which most of the SSRS reports run.
Future plan (over which I don't really have a say) is MOSS 2007 with backend on SQL 2008, which will remain to be the SSRS server. The second SQL server with business data will be migrated to SQL 2008 R2.

Questions: does this architecture requires SSRS 2008 add-in or SSRS 2008 R2 add-in (integrated mode)? Will there be an issue of building SSRS 2008 reports that go after SQL 2008 R2 and SQL 2008 data mix?


Categories:

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