Crystal Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have got two tables 'complaintmaster' and 'phasemaster

ComplaintMAster field

1 ComplaintId numeric 9
0 Complaint nvarchar 500
0 RaisedBy nvarchar 10
0 RaisedDate datetime 8
0 Status nvarchar 10
0 SolutionGiven nvarchar 500
0 ClosedDate nvarchar 20
0 AttendedBy nvarchar 10
0 Enabled bit 1
0 ProjectPhase nvarchar 30
0 ProjectId numeric 9
0 ResponseDate datetime 8

PhaseMaster field

1 PhaseId numeric 9
0 Phase nvarchar 30

Now i want the report in the following way please tell me the way i should follow i am new to complex crysatl reporst

Month wise all the complaints and and in that month closed compalints all these complaints are in which phase (design,testing etc) then in summary i want the tota

Month-Year No. of Complaints Closed RS Design Coding Testing Acp
Oct-02 4 4 4
Mar-03 4 4 4
Nov-03 3 1 1
Dec-03 1 1










Total 12 10 0 0 9 0

Any suggestion
Thankyo
 
In crystal.net what you want to do is
1. Fill a dataset with both table
2. Establish a relationship between the table
3. use dataset.writexmlschema to generate a .xsd fil
4. use the .xsd file to base your report on

At runtime
1. fill your datase
2. create an instance of the crystal report objec
3. set the data source of the crystal report object to the datase
myReport.setdatasource(myDS
4. set report viewer reports source to the report objec

HTH

Cos Callis, MCAD
 
Back
Top