replace empty string with value if it is empty in ssrs

I want to insert an empty string in a nvarchar field and a default date like a base date in a datetime field inside a stored procedure without passing it the value thru a parameter

how is this done?

INSERT INTO deals_SoldItems (

deals_SoldItems.[TransactionID],

deals_SoldItems.[EmptyStringField],

deals_SoldItems.[BaseDateField]

)

VALUES (

@TransactionID,

"",

"01/01/1900

)

this dont work

cheers

Hi ,

We have developed a Webservice which returns data in the form of xml to client. When we access the webservice from our brower, we were able to see the message with empty string. But in SSRS dataset designing we dont see column at all.

For example:- Webservice developed  returns the XML data to client.When we bound this webservice has datasource for dataset, we dont see column in dataset which contains empty string or null.

How can i have column present in dataset in though XML element value is null or empty.

Like DOB in employee xml is sent to client. But this XML contain DOB with empty data like <DOB></DOB>. Since DOB xml element is empty we could not see this DOB column in dataset of Report. How can show tht DOB column in dataset

-mahender

Hi

I'm pretty new to MDX so please go gentle :)

I'm writing a SSRS report which will show employees (in a hierachy) and the number of different events which occured for them each day over a week.

The problem i'm having is that i want to show ALL employees in the hierachy regardless of whether they have any events but also ONLY show those event columns for events which have happened that day.

As i understand it so far SSRS does cross joins to flatten out the data, so i'm guessing i need to crossjoin the Employees set (including empties) against the events set ensuring NON Empty is used, however i'm struggling to get this to work

Heres what i've trued so far

SELECT 
NON EMPTY{[Measures].[Event Count] } ON COLUMNS, 
{DESCENDANTS([Employee].[Reports To].[Regional Director].ALLMEMBERS)} ON ROWS 
FROM [DataWarehouse]

Results:

Event                  Count
Employee1            28
Employee2            28
Employee3            (null)
Employee4            28
Employee5   

I have pass following SQL Query to the through ObjectDataSource

SELECT     RequesterID, CompanyID, Name, emailID, Department, JobTitle, MobileNo, LandLine, Ext, Remarks
FROM         Requester
Where Name Like @Name + '%'

And I am passing parameter through QueryString and My idea is like when empty string is pass it should show me all records but when I am passing empty string ObjectDataSource is making NULL and I am not getting desire result

Kindly can somebody help me on that. It is okay if you change query of help me on objectDataSource.

Technology used : VS2008, VB.NET, LinqToSQL, BindingSource

I used LinqToSQL to create a detailsform. So I have a Textbox bound to a Varchar column in the dababase. When I created a record with the form it stores some columns as NULL values which is perfect. When I change the value of the textbox to something and do a db.SubmitChanges() the value is stored. 

However, when I make the textbox empty and save, the value in the database is an empty string. I want it to be NULL. How can i achieve this?

Using PowerShell to illustrate:

$t = '<img src="r1.jpg" width="330" class="image">'
$pattern = 'src[\s]*?=[\s]*?[''|"](.+?jpg)[''|"][\s]*?width=[''|"]330[''|"]'


[RegEx]::Match($t, $pattern)

gives:

Groups   : {src="r1.jpg" width="330", r1.jpg}
Success  : True
Captures : {src="r1.jpg" width="330"}
Index    : 5
Length   : 24
Value    : src="r1.jpg" width="330"

Just to confirm,

$matches[1]

gives: r1.jpg

But,

[RegEx