January 31st, 2010, 05:20 AM
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
Tags for this Thread
Click Here to Expand Forum to Full Width