ssrs and IN Operator issue

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 < LEN(@string) + 1 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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Avinash Vajpayee9y ago
is it possible from c sharp For IN Operatot
Manikandan Murugesan9y ago
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 < LEN(@string) + 1 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