SQL to split the data based on delimiter and display in rows.

split data delimiter

Data can be splitted based on delimiter using the following query

  SET @Val    = LEFT(@String,
ISNULL(NULLIF(CHARINDEX(@Delimeter, @String) - 1, -1),
LEN(@String)))
SET @String = SUBSTRING(@String,
ISNULL(NULLIF(CHARINDEX(@Delimeter, @String), 0),
LEN(@String)) + 1, LEN(@String))
IF @TrimSpace = 1 Set @Val = LTRIM(RTRIM(@Val))
SQL to split the data based on delimiter and display in rows. was last modified: October 1st, 2017 by Justin Antony

How to Split SSRS output in Excel if it exceeds the limit ?

Split SSRS Excel Output

SSRS Excel Export for more than 65536 rows in the output is as follows

Detail Section Righ Click – > Add Parent Group
-> Group by window write the formula as below
=Ceiling((RowNumber(Nothing))/60000)
Add Page break in the group properties
-> select page break between each group option
Once you export excel, you will find different worksheets created for data having rows more than 60000.

Regards
Author.

How to Split SSRS output in Excel if it exceeds the limit ? was last modified: October 1st, 2017 by Justin Antony