I need the same in SSRS 2008 and SSRS 2008 R2. Can anyone please let me know how to achieve this!!!!

Thanks!!

Hello,

If you want a report in the specified output then you need to look for two areas.

1. SQL Query

2. Report Design

SQL Query:

==========

In the report design in the data tab...

Hello,

Try this

create procedure MyProc

(

@First int = NULL,

@Second = NULL,

@Third = NULL

)

as begin

select * from employee where empid not in (IsNull(@First,0),IsNull(@Second,0),IsNull(@Third,0))

end

Hope helpful...

Hello,

If all values are in a single row then there should be a seperator between each details. Here you did not mentioned that. Space connot be a seperator in your...

Hello,

Try this

CREATE TABLE #TestData (

Id int IDENTITY(1, 1) PRIMARY KEY,

StartDate datetime NOT NULL,

EndDate datetime NOT NULL,

StartTime datetime NOT NULL,

EndTime datetime NOT NULL

)

INSERT INTO #TestData (StartDate, EndDate, StartTime, EndTime)

SELECT '20090415',...

Hello,

If you are using VS2005 version then follow below steps.

1. Go to the cell/textbox where you want to apply this format.

2. Right click and select Properties.

3. In the properties window...

Hello,

Try this

CREATE TABLE [dbo].[Test]

(

ID INT,

NAME NVARCHAR(50)

)

INSERT INTO [dbo].[Test] VALUES (1,'Sample1')

INSERT INTO [dbo].[Test] VALUES (2,'Sample2')

INSERT INTO [dbo].[Test] VALUES (3,'Sample3')

INSERT INTO [dbo].[Test] VALUES (4,'Sample4')

CREATE PROCEDURE [dbo].[Sample]

(

@ID NVARCHAR(50)

)

BEGIN

DECLARE @IDSTR NVARCHAR(100)

SET @ID = '1,2'

SET...