Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (17.6k points)

=Splt(Fields!Address.Value,",",-1)

When i am executing above statement in SSRS, it is giving me the following error
#Error

Any Suggestions??

 

1 Answer

0 votes
by (47.2k points)

Firstly, there seems to be a typo; the right spelling is' Split' and not' Splt.'

Secondly, you can not directly use a Split to put it as a value.

Basically, it splits a string into pieces based on the character you defined (a comma in your case) So to use the Split string, you need to move the index to get the split string at that point.

Example: 

=Split(Fields!Address.Value,",")(0).ToString() 

will return the 1st value 

OR

=Split(Fields!Address.Value,",")(1).ToString()

 will return the second

Check out Msbi certification training that enables you to master MSBI tools like SSIS, SSRS, and SSAS using SQL Server. 

Related questions

0 votes
1 answer
0 votes
1 answer
asked Feb 27, 2020 in BI by Vaibhav Ameta (17.6k points)
0 votes
1 answer
asked Feb 10, 2020 in BI by Vaibhav Ameta (17.6k points)
0 votes
1 answer
asked Feb 5, 2020 in BI by Vaibhav Ameta (17.6k points)

Browse Categories

...