"Continued" Header on Subsequent Pages

Question:How can I repeat a group header on each page, but have it say “MyGroup (continued)” on all but the first page? Answer:Since pagination is determined long after the report has been fully processed, there’s no way for the body of the report to reference any page information.  As a result, we’re going to have…

0

Custom Report Item Image Quality

Question:How can I get print-quality output from my custom report item? Answer:Custom report items have slightly different plumbing than native report items.  Of particular note are native charts.  These are generated during report rendering, which means it is possible for us to vary both the type (raster or vector) and the DPI of the image…

0

"All" Parameter Value Redux

Question:How can I enable users to select “All” as the value of a multivalue query parameter? Answer:Since multivalue parameters cannot be null, you cannot use the approach previously described here.  Fortunately, a simple modification of that approach to use a non-null “ALL” token is all that is required. Step 1:  Start with a report that…

0

Reset Page Number On Group

Question:How can I reset my page number back to 1 every time I get a group break? Answer:Resetting the page number on group breaks isn’t natively supported, but it can be achieved by tracking group breaks in a shared variable and subtracting off the page offset of the first page of the group from the…

0

GroupPageReset.rdl

<?xml version=”1.0″ encoding=”utf-8″?><Report xmlns=”http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition” xmlns:rd=”http://schemas.microsoft.com/SQLServer/reporting/reportdesigner“>  <PageHeader>    <ReportItems>      <Textbox Name=”PageNumber”>        <Style>          <PaddingLeft>2pt</PaddingLeft>          <BorderStyle>            <Default>Solid</Default>          </BorderStyle>          <PaddingBottom>2pt</PaddingBottom>          <PaddingTop>2pt</PaddingTop>          <PaddingRight>2pt</PaddingRight>        </Style>        <ZIndex>1</ZIndex>        <Height>0.375in</Height>        <Width>1.5in</Width>        <CanGrow>true</CanGrow>        <Value>=”Page: ” &amp; Globals!PageNumber</Value>      </Textbox>      <Textbox Name=”GroupPage”>        <Style>          <PaddingLeft>2pt</PaddingLeft>          <BorderStyle>            <Default>Solid</Default>          </BorderStyle>          <PaddingBottom>2pt</PaddingBottom>          <PaddingTop>2pt</PaddingTop>          <PaddingRight>2pt</PaddingRight>        </Style>        <Height>0.375in</Height>        <Width>3.625in</Width>        <CanGrow>true</CanGrow>        <Value>=”Grouped Page: ” &amp; Code.GetGroupPageNumber(ReportItems!Category.Value,Globals!PageNumber)</Value>        <Left>1.75in</Left>      </Textbox>    </ReportItems>    <PrintOnLastPage>true</PrintOnLastPage>    <PrintOnFirstPage>true</PrintOnFirstPage>    <Style />    <Height>0.5in</Height>  </PageHeader> …

0