how can i display a field in crystal reports wherein it has many records in it? for example
project number : advcamp contract 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 displays
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 MVP http://visakhm.blogspot.com/
crystal report - sql
Posted - 12/10/2012 : 01:14:22
