Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Label Expression Reporting Services in Sharepoint

  Asked By: Donavan    Date: Oct 21    Category: Sharepoint    Views: 1038

I use SQL Reporting Services to create a report, I have a long
data inside one label like data below.

FF Susu Steril Strawberry;#22;#FF Yes! Minuman susu rasa Strawberry;#23;#FF Yes!
Minuman susu rasa Anggur;#6;#FF Susu UHT Strawberry;#9;#FF Yes! Susu UHT rasa
Strawberry;#4;#FF Yes! Minuman Susu rasa Strawberry (Pillo Flex);#11;#FF Yes!
Minuman Susu rasa Grape (Pillo Flex)

What I wanna do is make it become appear one by one like example below.

* FF Susu Steril Strawberry
* FF Yes! Minuman susu rasa Strawberry
* FF Yes! Minuman susu rasa Anggur
* FF Susu UHT Strawberry
* FF Yes! Susu UHT rasa Strawberry
* FF Yes! Minuman Susu rasa Strawberry (Pillo Flex)
* FF Yes! Minuman Susu rasa Grape (Pillo Flex)

i want to remove this tag ;#XX;# and I use script below

=LTrim(Replace(Switch(Len(Split(Fields!Used_x0020_in.Value, ";#")(0)) > 0,
Split(Fields!Used_x0020_in.Value, ";#")(0) & vbCrLf), ",", " "))

& vbCrLf & LTrim(Replace(Split(Fields!Used_x0020_in.Value, ";#")(1), ",", " "))

But after I try to display it show like below

FF Susu Steril Strawberry

22

FF Yes! Minuman Susu rasa Strawberry

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on Label Expression Reporting Services in Sharepoint Or get search suggestion and latest updates.

Related Topics:




 

Related Post