-
Reporting Services
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|