{"id":140,"date":"2008-03-03T10:14:00","date_gmt":"2008-03-03T10:14:00","guid":{"rendered":"\/lisa\/post\/2008\/03\/03\/Report-Preprocessing-SQL-Server-Reporting-Server-Group-PageTotals-Part-II-A-Walkthrough-on-the-Client-Side.aspx"},"modified":"2008-03-03T10:14:00","modified_gmt":"2008-03-03T10:14:00","slug":"report-preprocessing-sql-server-reporting-server-group-pagetotals-part-ii-a-walkthrough-on-the-client-side","status":"publish","type":"post","link":"https:\/\/spacefold.com\/lisa\/2008\/03\/03\/report-preprocessing-sql-server-reporting-server-group-pagetotals-part-ii-a-walkthrough-on-the-client-side\/","title":{"rendered":"Report Preprocessing: SQL Server Reporting Server Group PageTotals, Part II: A Walkthrough on the Client Side"},"content":{"rendered":"

\nLast time<\/a>, as you remember, we handled the server-side and coding details of a preprocessed report (and gory details they were).  You saw that we set up the appropriate information for values that we might need in a preprocess run, and then the right information is available to you on the followup run.\n<\/p>\n

\nWhile this technique is useful for the "Group Page Totals" problem under discussion, it is applicable to many more cases.  For example, you could apply it to a report that required a table of contents or an index.  So even if you don't need group page totals you might want to give this some thought — and it's really a pity that there isn't an obvious built-in way to tell the RS reporting engine "please do all the work according to the needs of a particular <\/em>renderer, but don't give me any output, then perform a second run". \n<\/p>\n

\nThe key thing here is according to the needs of a particular renderer.<\/em> You can provide for a "null output" rendering extension pretty easily; in fact I think there is one built-in to the Report Server configuration file, although it is excluded, by default, from the Export formats that will show up in the drop down.  Maybe this type of job is what it's for.<\/p>\n

But you have to render according to a particular export format<\/em>, even when you're not getting any physical output, to get the pagination that corresponds to that export format.  And that's an entirely different thing.\n<\/p>\n

\nSo let's get to it.\n<\/p>\n

\nIn this example, as I explained earlier, I've chosen to use an ASP.NET client, but the type of client should not matter. ASP.NET just has one more wrinkle, displaying a PDF appropriately in the browser, so I thought I would include that in my example code.\n<\/p>\n

\nI've also chosen to access the report using the RS web service, simply because in previous examples<\/a> I've used URL Access, and I thought it would make a nice change.\n<\/p>\n

\nSo let's say we have two buttons on a web page, looking something like this:\n<\/p>\n

\n<input type="submit" name="Button1" value="GetPreprocessedReport" id="Button1" \/> &nbsp;
\n<input type="submit" name="Button2" value="GetPDF" id="Button2" \/>\n<\/p>\n

\n… that's pretty much it.\n<\/p>\n

\nNow we have to write the code under those two buttons.  The key thing is pushing the parameters over appropriately for each run (preprocess and "real"), for each type.\n<\/p>\n

\nHere's the code for Button1:\n<\/p>\n

\nProtected Sub<\/span> Button1_Click(ByVal<\/span> sender As Object<\/span>, ByVal<\/span> e As<\/span> System.EventArgs) Handles<\/span> Button1.Click <\/p>\n

  ' most of the report-accessing code here <\/span>
\n  ' is pretty much straight out of  <\/span>
\n  ' http:\/\/msdn2.microsoft.com\/en-us\/library\/aa258532(SQL.80)<\/a><\/span>
\n <\/span> <\/p>\n

  Dim<\/span> rs As<\/span> New<\/span> ReportingService()
\n  rs.Credentials = System.Net.CredentialCache.DefaultCredentials <\/p>\n

  ' Let's add the correct Render arguments<\/span>
\n  Dim<\/span> result As<\/span> Byte<\/span>() = Nothing<\/span>
\n  Dim<\/span> reportPath As<\/span> String<\/span> = "\/ReportProject1\/SqlWorldGroupTotals"<\/span>
\n  Dim<\/span> format As<\/span> String<\/span> = "HTML4.0"<\/span> <\/p>\n

  ' For the real fileKey value<\/span>,
\n  ' you would want to put something in <\/span>
\n  ' here that uniquely identifies the session and the user,<\/span>
\n  ' not just the output type as I am doing here…<\/span> 
\n  Dim<\/span> fileKey As<\/span> String<\/span>
\n  fileKey = "TestHTML"<\/span> <\/p>\n

  ' Prepare report parameters.<\/span>
\n  Dim<\/span> parameters(2) As<\/span> ParameterValue
\n  parameters(0) = New<\/span> ParameterValue()
\n  parameters(0).Name = "FileKey"<\/span>
\n  parameters(0).Value = fileKey
\n  parameters(1) = New<\/span> ParameterValue()
\n  parameters(1).Name = "PreProcess"<\/span>
\n  parameters(1).Value = True<\/span>
\n  parameters(2) = New<\/span> ParameterValue()
\n  parameters(2).Name = "ExportType"<\/span>
\n  parameters(2).Value = "HTML"<\/span>
\n  Dim<\/span> sh As<\/span> New<\/span> SessionHeader()
\n  rs.SessionHeaderValue = sh <\/p>\n

  Try<\/span>
\n      result = rs.Render(reportPath, format, Nothing<\/span>, Nothing<\/span>, parameters, _
\n         Nothing<\/span>, Nothing<\/span>, Nothing<\/span>, Nothing<\/span>, Nothing<\/span>, Nothing<\/span>, Nothing<\/span>)
\n      ' We've just done the preprocess run. We're not going to do anything<\/span>
\n      ' with those results, though.<\/span> <\/p>\n

      sh.SessionId = rs.SessionHeaderValue.SessionId
\n      ' Now we'll render a second time before displaying the results,<\/span>
\n      ' letting the report know that we are not in "preprocess" mode this time:<\/span>
\n      parameters(1).Value = False<\/span>
\n      result = rs.Render(reportPath, format, Nothing<\/span>, Nothing<\/span>, parameters, _
\n         Nothing<\/span>, Nothing<\/span>, Nothing<\/span>, Nothing<\/span>, Nothing<\/span>, Nothing<\/span>, Nothing<\/span>)
\n      Response.OutputStream.Write(result, 0, result.Length)
\n      result = Nothing<\/span>
\n  Catch<\/span> ex As<\/span> Exception
\n      Response.Write(ex.Message())
\n  End<\/span> Try<\/span>
\n  sh = Nothing<\/span>
\n  rs.Dispose()
\n  rs = Nothing<\/span> <\/p>\n

End<\/span> Sub<\/span>\n<\/p>\n

\nNothing too fancy there.\n<\/p>\n

\nAnd, as you can probably figure out, the code for Button2 is almost exactly the same, except for our various parameter values and the Render format, but we'll also add an appropriate content type so that the browser will display it properly:\n<\/p>\n

\n[Excerpted] Protected<\/span> Sub<\/span> Button2_Click( ByVal<\/span> sender As<\/span> Object<\/span>, ByVal<\/span> e As<\/span> System.EventArgs) Handles<\/span> Button2.Click
\n  ' … <\/span>
\n  fileKey = "TestPDF"<\/span>
\n  ' … <\/span>
\n  Dim<\/span> format As<\/span> String<\/span> = "PDF"<\/span>
\n  ' … <\/span>
\n  parameters(2).Value = "PDF"<\/span>
\n  ' … we'll get our second result as before:<\/span>
\n  result = rs.Render(reportPath, format, Nothing<\/span>, Nothing<\/span>, parameters, _
\n               Nothing<\/span>, Nothing<\/span>, Nothing<\/span>, Nothing<\/span>, Nothing<\/span>, Nothing<\/span>, Nothing<\/span>)
\n  ' but then:<\/span>
\n  Response.ContentType = "Application\/pdf"<\/span>
\n  ' followed by the same:<\/span>
\n  Response.OutputStream.Write(result, 0, result.Length)
\n  ' … See?<\/span>\n<\/p>\n

\nWhen you examine your results in the browser you can clearly see the difference in overall page total for the two rendering targets.\n<\/p>\n

\n\"Preprocessing \n<\/p>\n

\nWe're all done, and it wasn't too tough, except that I somehow forgot to work in my requirement of at least one Serenity quote per post<\/em>, at least so far.  So here's our Serenity<\/a> thought for the day:\n<\/p>\n

We've done the impossible, and that makes us mighty.<\/h3>\n

\nDoesn't hardly seem like this was<\/em> the impossible.\n<\/p>\n

\nBut if you look back at the previous post<\/a> and put the whole effort together… you realize that these are words for RS folks to live (and code) by.\n<\/p>\n

\n' Til next time.<\/p>\n","protected":false},"excerpt":{"rendered":"

Last time, as you remember, we handled the server-side and coding details of a preprocessed report (and gory details they were).  You saw that we set up the appropriate information for values that we might need in a preprocess run, and then the right information is available to you on the followup run. While thisRead 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-140","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\/140","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=140"}],"version-history":[{"count":0,"href":"https:\/\/spacefold.com\/lisa\/wp-json\/wp\/v2\/posts\/140\/revisions"}],"wp:attachment":[{"href":"https:\/\/spacefold.com\/lisa\/wp-json\/wp\/v2\/media?parent=140"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/spacefold.com\/lisa\/wp-json\/wp\/v2\/categories?post=140"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/spacefold.com\/lisa\/wp-json\/wp\/v2\/tags?post=140"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}