Greetings fellow geeks,
I'm using Report Services report designer for the first time, and am trying to do a freeform list report. Here is my select statement:
SELECT cp.*, crev.RevisedDate, crev.RevisedUser, crev.RevisedHistory
FROM CPTProtocol cp LEFT OUTER JOIN
CPTRevisionHistory crev ON cp.CPTCode = crev.CPTCode
ORDER BY cp.RelatedCPTCode, cp.CPTCode

I am trying to show a list of all related CPTCodes on a page with the RelatedCPTCode on the heading, however when the page breaks it only has the first CPTCode in the series. Can anyone offer some insight into how I would get the complete list of CPTCodes by RelatedCPTCode???
Warmest Regards,
Lou