A am not too sure if this is even the correct place to post this but sorry if its not. I am using crystal reports with vs 2008 express and i am having trouble with one part. I have a parts filed in my database and I need to insert each part into a different unbound field. I have been trying to use the split function but I can't get it to work. The parts list can unlimited so there is no way i will know how long to loop for.
This is how the string appears in the database.
Airfliter - 1 - 12 + Oil - 1 - 12 + FuelFilter-2-3
Each is separated by a + and PartName-QTY-Cost is the break down of each part its self .
please does any one have a idea what to do.
Even if each part would go on to the next line in the textbox that would do. any ideas are welcome