{"id":133,"date":"2008-04-27T08:13:00","date_gmt":"2008-04-27T08:13:00","guid":{"rendered":"\/lisa\/post\/2008\/04\/27\/Sometimes-the-magic-works.aspx"},"modified":"2008-04-27T08:13:00","modified_gmt":"2008-04-27T08:13:00","slug":"sometimes-the-magic-works","status":"publish","type":"post","link":"https:\/\/spacefold.com\/lisa\/2008\/04\/27\/sometimes-the-magic-works\/","title":{"rendered":"Sometimes the magic works"},"content":{"rendered":"

\nUma (whoever that is<\/a>) has posted a question in response to https:\/\/spacefold.com\/lisa\/2007\/09\/19\/Dynamically-loading-reports-in-ReportViewers<\/a><\/a> , which as far as I can tell is completely unrelated to that post <g>.\n<\/p>\n

\n

\n\tHi i want to display subtotal of first page in the top of next page in rdlc report and i am using page break of 10 in every page.\n\t<\/p>\n<\/blockquote>\n

\nUnrelated to dynamically loading reports or not, the question certainly covers a subject that I'm familiar with and will address here in case I haven't in the past.\n<\/p>\n

\nFirst, just in case I haven't already talked about conditional page breaks on <item number>, this is just a variant of other ROW_NUMBER() techniques we've used to resolve past problems.  Let's say my SQL query looks something like this, in Uma's case:\n<\/p>\n

\n SELECT
\n             Sales_No, Customer,Order_Quantity,
\n             CEILING(CAST( ROW_NUMBER() OVER (ORDER BY Customer)  \/ 10  AS
\n             Numeric(10,2))) AS Grouper
\n FROM OrderHeader
\nORDER BY Customer\n<\/p>\n

\n… where the "\/10<\/strong>" in the above query is determined by the "page break of 10" in Uma's scenario.  OK so far?\n<\/p>\n

\nSo now my group break is simply the expression =Fields!Grouper.Value<\/strong>, and I set this group to page break at end.  <\/strong>\n<\/p>\n

\nNB: I always think it's nice to let SQL do most of the work, if I can.\n<\/p>\n

\nIn your situation, you might be doing it differently, or in a more RS-oriented way.  That's okay, how you happen to be determining your page break is not really germane to Uma's question at all. The point is, however you're doing your grouping… the work is almost all done already.  It looks<\/em> as though we have a lot of work left, maybe, but really, it's almost done.\n<\/p>\n

\nSo now let's say we have a subtotal expression (for Uma) that, in my example, looks like this, in the footer of this group: =Sum(Fields!Order_Quantity.Value).<\/strong>\n<\/p>\n

\nAnd let's say we change that footer expression to do this: =Sum(Fields!Order_Quantity.Value) & Code.MyUdf(Sum(Fields!Order_Quantity.Value))<\/strong>.\n<\/p>\n

\nAnd let's say we write the following (really minimal) amount of code:\n<\/p>\n

\n   Public PrevPage As Double = 0<\/p>\n

   Function MyUdf( t As Double) AS String
\n       PrevPage = t
\n   Return ""
\n   End Function\n<\/p>\n

\n…   and now let's say we put a textbox in the group header<\/em> with the following expression: =IIF(Code.PrevPage = 0,"",Code.PrevPage)<\/strong> (the IIF() is just to take care of the first page, because I'm too lazy to worry about whether this is the most elegant way to do it or not).\n<\/p>\n

\nThat's all she wrote, folks.  Seems to work just as you'd want.  No big deal, really.\n<\/p>\n

Why the title of this post?<\/h4>\n

\nFirst, you should know it's a quote from "Little Big Man<\/a>".  I'm taking a "Serenity<\/a>" break, just for kicks.\n<\/p>\n

\nSecond, this is one of those times when multiple export types (Excel rendererer, PDF renderer, etc) don't get in the way. You notice I haven't put anything in the page header; I'm avoiding any issues of "what sequence does everything happen in" in the various rendering engines that way.  Sometimes the magic can… just work. <\/p>\n","protected":false},"excerpt":{"rendered":"

Uma (whoever that is) has posted a question in response to https:\/\/spacefold.com\/lisa\/2007\/09\/19\/Dynamically-loading-reports-in-ReportViewers , which as far as I can tell is completely unrelated to that post <g>. Hi i want to display subtotal of first page in the top of next page in rdlc report and i am using page break of 10 in every page.Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,6],"tags":[],"class_list":["post-133","post","type-post","status-publish","format-standard","hentry","category-reporting","category-sql-server"],"_links":{"self":[{"href":"https:\/\/spacefold.com\/lisa\/wp-json\/wp\/v2\/posts\/133","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/spacefold.com\/lisa\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/spacefold.com\/lisa\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/spacefold.com\/lisa\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/spacefold.com\/lisa\/wp-json\/wp\/v2\/comments?post=133"}],"version-history":[{"count":0,"href":"https:\/\/spacefold.com\/lisa\/wp-json\/wp\/v2\/posts\/133\/revisions"}],"wp:attachment":[{"href":"https:\/\/spacefold.com\/lisa\/wp-json\/wp\/v2\/media?parent=133"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/spacefold.com\/lisa\/wp-json\/wp\/v2\/categories?post=133"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/spacefold.com\/lisa\/wp-json\/wp\/v2\/tags?post=133"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}