ssrs and IN Operator issue

Question

how to export ssrs rdl report to excel in csharp programically. how to send data comma seperated to sql porcedure for IN Operator. for ex-- if i have (a,n,s) then it replace in IN operaator with ('a','n','s')

Avinash Vajpayee · Answer

is it possible from c sharp For IN Operatot

Manikandan Murugesan · Answer

Report to Excel Refer the following Links : https://social.msdn.microsoft.com/Forums/en-US/31210ef2-17ca-431d-aa20-2cfeb3f03087/ssrs-reporting-exporting-to-excel?forum=sqlreportingservices https://www.codeproject.com/Questions/275082/Exporting-SSRS-Programatically For IN Operator : https://www.codeproject.com/Tips/584680/Using-comma-separated-value-parameter-strings-in-S you can use split function and use it as in following way here my split fnSplitString return splitdata select * from tb1 where id in ( select splitdata from dbo.fnSplitString(( select col1 from tb12 where id=3), ',' )) create FUNCTION [dbo].[fnSplitString] ( @string NVARCHAR( MAX ), @delimiter CHAR (1) ) RETURNS @ output TABLE (splitdata NVARCHAR( MAX ) ) BEGIN DECLARE @start INT , @ end INT SELECT @start = 1, @ end = CHARINDEX(@delimiter, @string) WHILE @start BEGIN IF @ end = 0 SET @ end = LEN(@string) + 1 INSERT INTO @ output (splitdata) VALUES ( SUBSTRING (@string, @start, @ end - @start)) SET @start = @ end + 1 SET @ end = CHARINDEX(@delimiter, @string, @start) END RETURN END

ssrs and IN Operator issue

Answers (2)