I want to make a crystal report for JobOrder..
1. the first part will be details of job order - which I can do
2. in details section it should show the services for this job order - this too i can do
3. it should show items used for each service --this is where I need ur help

items for each service is dynamic and some service may not use any items . the no.of items, their qty , their unit all coming from database. below is db schema..
Name: Untitled.png Views: 200 Size: 14.9 KB



service_id contains sitem_id

the third part should be like :
Service1 : item1=25cm, item2=40cm
Service 2:
Service 3: item6= 90mm

If anyone needs any more clarification let me know.

Please if anyone can give atleast is this possible in crystal reports as Im developing windows app in vb.net 2008, mssql 2005.
It would be also helpful if some1 tells me from where to start then I will search on that..I dont know what this type of requirement is said

thanks in advance