Hi,

In NoRowsMessage Property you can use IIF Statements

Just Like

=IIF(Parameters!A.Value = "Test", "Test Data Not Available", "Sample Data Not Available")

Hi,

Try this

=SUM(IIF(Fields!tickets.value = "P" or Fields!tickets.value = "C" and Fields!ticket_date.Value = today()-1, 1, 0))

Hi,

Try this

Step 1: Stored Procedure

CREATE PROCEDURE SampleProcedure

(

@daterange NVARCHAR(100) = NULL,

@lastname NVARCHAR(100)= NULL,

@department NVARCHAR(100)= NULL,

@location NVARCHAR(100) = NULL

)

AS

BEGIN

...

Hi,

This can be achieved in ssrs 2008

Hi,

You should set your page properties correctly

Go to Report Properties

Set left, right, top,bottom marigins to .25in

your page size should be greater than the report body size

For standard page sizes...

Hi,

You should set your page properties correctly

Go to Report Properties

Set left, right, top,bottom marigins to .25in

your page size should be greater than the report body size

For standard page sizes...

Hi,

Check these Links

http://msdn.microsoft.com/en-us/library/ms159847.aspx

http://blogs.msdn.com/seanboon/archive/2009/02/09/enabling-drilldown-on-ssrs-reporting-services-2008-charts.aspx

I hope these links might be Helpful

Hi,

Select table and Click F4

In Report Properties Window goto Filter

Enter Filter Condition in it

Hi,

Deadlock : Deadlock occurs when two or more tasks permanently block each other by each task having a lock on a resource which the other tasks are trying to...

You need to have some seperator after one person details so that we can process data or insert into table

Try this,

this can be used when the column contains one person...

Hi,

Try this,

DECLARE @Phone NVARCHAR(50)

SET @Phone = '(xxx) xxx-xxxx'

DECLARE

@LoopINT

,@In_LenINT

...

Hi,

Try this,

SELECT * FROM DatabaseName..SYSComments Where text = 'sp_FindDetails'

Hi,

Check this link

http://msdn.microsoft.com/en-us/library/ms143506.aspx

I hope it might be helpful for you

Check these links How to Upgrade to SQL Server 2008

http://msdn.microsoft.com/en-us/library/ms144267.aspx

http://msdn.microsoft.com/en-us/library/bb677622.aspx

I hope these links might be helpful

Hi,

Check these links might be helpful for you

http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx

http://msdn.microsoft.com/en-us/library/ms143761.aspx