Click here to Skip to main content
13,048,584 members (79,093 online)
Rate this:
Please Sign up or sign in to vote.
See more:
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..[^]

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 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
Posted 31-May-13 20:41pm
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

For your crystal report first you need to pick the fields that want to show in reports using joins in query if need put some conditions that what you need(item1=25cm, item2=40cm)

Step1: you need to create the CrystalReport1.rpt
step2: create the data set in that select your fields that want to show in reports and
add where conditions for list of items
Step3: connect the data set to your CrystalReport1.rpt report and set the condition
Step4: Add text box and button to your Report in that text box you give the values in dynamic for
items1 like 25cm,40cm then click the button it will generate your CrystalReport
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

the solution you gave is for normall cyrstal reports and I know this as mentioned above but my problem is different plz ready question carefully.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170713.1 | Last Updated 3 Jun 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100