please modify the Store Procedureplease modify the Store Procedure
hi..
The following is my Sp
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[GettomoTaskSheet]
-- Add the parameters for the stored procedure here
@fname nvarchar(50)
AS
BEGIN
SET NOCOUNT ON;
SELECT date,To_Name ,Todays_Task,Status ,Tommorrows_Task,REPLACE(Comments, 'vinni','<font color="red">raki</font>') as comment
from TaskSheet where From_Name = @fname;
END
The above SP is used for displaying the data in SSRS reports ..
but when i run the SP in comment field where vinni occurs
i want raki in red color but it is displaying <font color="red">raki</font> this value.
i want to display the word raki in red color in ssrs2008 reports
please help me..