please 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..
-
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..
You are putting UI processing in the database query, wrong tool for the job. The data is interpreted as a string literal. Move your UI code to RSS, there is a function area where you can put in the code to do that.
Never underestimate the power of human stupidity RAH