Master and Subreport in Same Format, How to Make that Happenhttp://forums.asp.net/t/1773496.aspx/1?Master+and+Subreport+in+Same+Format+How+to+Make+that+HappenSat, 25 Feb 2012 14:18:29 -050017734964849637http://forums.asp.net/p/1773496/4849637.aspx/1?Master+and+Subreport+in+Same+Format+How+to+Make+that+HappenMaster and Subreport in Same Format, How to Make that Happen <p>Hey,</p> <p>I have this table in my database:</p> <p>Agency&nbsp; Client&nbsp; &nbsp;Amount</p> <p>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;25&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &#36;560</p> <p>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;30&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&#36;720</p> <p>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;25&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &#36;1000</p> <p>I want to build a report, once the client open the report, it should include:</p> <p>First page is titled All Agencies, and with group each Client togeter then show the total, like this:</p> <p>Agency: All</p> <p>Client ID&nbsp;&nbsp; Number of Client&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Amount</p> <p>25&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&#36;1560</p> <p>30&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&#36;720</p> <p>-------------------------------------------------</p> <p>Total:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#36;2280</p> <p>I know how to do this, but I want the second page just exactly the same format, but only&nbsp;for Agency A, then third page only for Agency B.</p> <p>I am not very familiar with CR, don't know how to do this, please point a direction, thanks.</p> <p>&nbsp;</p> <p>Madison</p> 2012-02-24T15:29:40-05:004850669http://forums.asp.net/p/1773496/4850669.aspx/1?Re+Master+and+Subreport+in+Same+Format+How+to+Make+that+HappenRe: Master and Subreport in Same Format, How to Make that Happen <p>Refer <a href="http://csharpdotnetfreak.blogspot.com/2009/07/subreports-in-crystal-reports-in-aspnet.html"> SubReports in crystal reports</a></p> 2012-02-25T14:18:29-05:00