InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 06:08:46 GMT20http://www.sqlservercentral.com/Forums/Topic630200-150-1.aspxI came across this issue (I know this thread is old) when designing a report.I'm using SSRS 2008. I had 2 matrices in the body of my report and the report was inserting page breaks in between the 2 tables. To fix, I dropped a rectangle from my toolbox onto the body of my report,; copied and pasted the 2 matrices into the rectangle, and set the page break properties of the rectangle to false. Now everything is on 1 page.Mon, 28 Jan 2013 07:24:42 GMTBlue Rabbithttp://www.sqlservercentral.com/Forums/Topic630200-150-1.aspxAccidentally posted here. moved to new thread.Wed, 02 Jun 2010 06:56:10 GMTDuncan Bosslehttp://www.sqlservercentral.com/Forums/Topic630200-150-1.aspxSteve,Thanks for the post. Responses like yours are what makes people continue to post solutions.Tue, 25 Aug 2009 19:15:59 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic630200-150-1.aspxI know this post is pretty old, but I wanted to thank Jack for his response. It was helpful.Tue, 25 Aug 2009 19:05:14 GMTMr. Datahttp://www.sqlservercentral.com/Forums/Topic630200-150-1.aspxThanks for all the information in this thread guys.I am having a similar issue and was wondering what the best method was to fix my problem. This should do the trick thanks for posting here.Sun, 17 May 2009 19:27:50 GMTmloewhttp://www.sqlservercentral.com/Forums/Topic630200-150-1.aspxI don'[t understand what you mean about it not being an elegant solution. It does what you desire, it limits round trips, and it takes advantage of the abilities of the platform.I think your only other option may be to use a subreport for the matrix and put it in the table. Of course this would mean your dataset for the matrix would be called once for each row in the table.I really think the solution I have suggested will perform best. If there are reasons it will not work because of the added information you need returned, post the complete DDL and samples and we'll see if there is a way to do what you need. I can only provide solutions based on the information that is provided.Mon, 12 Jan 2009 12:07:57 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic630200-150-1.aspxI had thought about that option. But I decided not to go with it because it is not an elegant solution. I had simplified the example posted. But in the actual report the table one has like 13 columns and the table two is something similar.Do you think there is any other way of achieving this?Mon, 12 Jan 2009 11:26:47 GMTGurpreet Atwalhttp://www.sqlservercentral.com/Forums/Topic630200-150-1.aspxOkay, here's how I'd do it. I use one dataset, which I think you need to do in order to do it anyway. It also reduces the roundtrips and reduces load on the SQL Server.Mon, 12 Jan 2009 10:47:27 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic630200-150-1.aspxJack, I am attaching the DDL to this post. It will create two tables SegmentMetrics and TrendedSegmentMetrics, the first one has definitions and is for the first table on the report, the second table has trended data for the segments and metric combination. I have also added the insert statements to the DDL to create a sample dataset. I have also modified the rdl to read from these tables and attached that also. Mon, 12 Jan 2009 09:03:32 GMTGurpreet Atwalhttp://www.sqlservercentral.com/Forums/Topic630200-150-1.aspxCan you provide the DDL for your source tables?Mon, 12 Jan 2009 08:40:17 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic630200-150-1.aspxJack, thanks for all your help. I have attached a sample report to this post. There are two controls on the report, the first one is a table with the Seg and Metric, the second one is a matrix with the metric value trended for each segment over time. I want to do a page break in a way that if the first table shows seg 1 the second control the matrix only shows trended data for seg 1. So the attached report would give you 5 pages for seg 1, 2, 3, 4, 5 with two controls on each page.Please let me know if you need more inputs.Regards,GurpreetMon, 12 Jan 2009 07:20:42 GMTGurpreet Atwalhttp://www.sqlservercentral.com/Forums/Topic630200-150-1.aspxGupreet,Please continue to post on this thread, I am subscribed to it so I will be notified when you post on it. In order to give accurate help the SQL and the rdl would be helpful.Sun, 11 Jan 2009 18:08:28 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic630200-150-1.aspxAttached is a report with this query:[code][font="Courier New"][size="2"][color="blue"]SELECT            [/color][color="black"]S.schema_id[/color][color="gray"],            [/color][color="black"]S.name [/color][color="blue"]AS [/color][color="black"]schema_name[/color][color="gray"],            [/color][color="magenta"]COUNT[/color][color="gray"]([/color][color="black"]O.[/color][color="magenta"]OBJECT_ID[/color][color="gray"]) [/color][color="blue"]AS [/color][color="black"]objects_in_schema    [/color][color="blue"]FROM            [/color][color="black"]sys.schemas S [/color][color="blue"]JOIN            [/color][color="black"]sys.all_objects O [/color][color="blue"]ON            [/color][color="black"]S.schema_id [/color][color="blue"]= [/color][color="black"]O.schema_id    [/color][color="blue"]GROUP BY            [/color][color="black"]S.schema_id[/color][color="gray"],            [/color][color="black"]S.name            [/color][/size][/font][/code]The report has a list control with a group on schema_id and schema_name which has page break at end set. Then a table and a chart control within the list.Just remove the ".txt" from the file.Sat, 10 Jan 2009 19:04:44 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic630200-150-1.aspxIt may be awhile before I get to an example as I currently don't have SQL Server 2005 easily available. I will post an example on this thread later though.Fri, 09 Jan 2009 11:38:57 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic630200-150-1.aspxI think you can do this a couple of ways.1. Nest the trended table in the details table.2. Put both tables inside a list control.Mon, 05 Jan 2009 16:15:53 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic630200-150-1.aspxHi All, I have a unique kind of requirement explained as under. I have two table controls on report design. 1) The table one is say main details of metric 2) The table two is the trended values of the metric over time. I have added a group on metric type to each of the tables, and added a page break at beginning of the group. Now the requirement is that when table one shows details of metric "A" the table two should show trended data for metric "A" The way I have implemented it, shows all the main details first one metric per page then all the trended data one metric per page. I have 16 metrics so I have 32 pages in the output (first 16 with main details and then another 16 for trended data). Is there any way that we can use the same group on both tables and the output will have 16 pages with two tables on each page (one for main details and the second for trended data)ThanksGurpreetMon, 05 Jan 2009 16:03:52 GMTGurpreet Atwal