Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: CrystalReports
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..
 
http://www.vbforums.com/showthread.php?723479-Crystal-reports-help&p=4426593#post4426593[^]
 

 
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
Posted 31-May-13 21:41pm
Rate this: bad
good
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
  Permalink  
Rate this: bad
good
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.
  Permalink  

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

  Print Answers RSS
0 OriginalGriff 330
1 Sergey Alexandrovich Kryukov 279
2 BillWoodruff 245
3 Afzaal Ahmad Zeeshan 215
4 CPallini 205
0 OriginalGriff 5,635
1 DamithSL 4,496
2 Maciej Los 3,942
3 Kornfeld Eliyahu Peter 3,480
4 Sergey Alexandrovich Kryukov 3,180


Advertise | Privacy | Mobile
Web01 | 2.8.141216.1 | Last Updated 3 Jun 2013
Copyright © CodeProject, 1999-2014
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