Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jb019
Starting Member
1 Post |
 Posted - 2012-12-10 : 01:14:22
|
| hi,how can i display a field in crystal reports wherein it has many records in it? for exampleproject number : advcampcontract name : contractor 1 contractor 2 contractor 3--"headers and group section of the report"-------------------------------------------------------------Column 1 | column 2 | column 3 | column 4 |column 5 |column 6 --"body of report"im talking about the contractor name field wherein a project there could be one or many contractors and i only want to list the names of the contractors in every project and with the body of report.because in my case right now this is what the report displaysproject no : proj1contractor name : contractor 1-------------------------------------------------------------Column 1 | column 2 | column 3 | column 4 |column 5 |column 6 contractor name: contractor 2-------------------------------------------------------------Column 1 | column 2 | column 3 | column 4 |column 5 |column 6 my problem with this is that the report body is being displayed every contractor of the project.pls help me. thanks :) |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2012-12-24 : 07:57:13
|
| You need to group the report by project and then by contractor.MadhivananFailing to plan is Planning to fail |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-12-24 : 15:32:54
|
| what do columns represent? attribute for project? if yes group by projectid (or similar identifier) then join to contractor table to get associated contractor details.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
crystal report - sql