Jump to content
We've recently updated our Privacy Statement, available here ×

How to split the string and display in detail band


shekhar
Go to solution Solved by Dhiraj Pahlani,

Recommended Posts

I have a problem in splitting the string

Assume my below query return’s me 3 rows with the address details

Select add, from add_tbl

But the ‘add’ column having data like

 

Row 1. #15 South street, Bendfast Area, 500402

Row 2. Chennai

Row 3 India

 

In ireport side I need to split those add data and display it in following manner into detail band

 

Address #15 South street,

Bendfast Area,

500402

Chennai

India

 

pls help me with sample

Link to comment
Share on other sites

  • 13 years later...
  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...