multi-page report only displaying the first page
Presently I am attempting to move our reporting services from Crystal Reports to SSRS. For some reason when I preview or run a multi-page report I have created, it only shows the first page in both the report viewer and also in the web page when generated
from our report server. Each page is to contain details on a person in our contact database. Here is the query used to populate the data:
SELECT * FROM ContactManagement.dbo.qryREPORTContactFullPageSummary
WHERE PrimaryID IN (SELECT ReportItemID FROM tblReportItem WHERE PersonnelID=@PersonnelID)
ORDER BY FirstLastName
The Crystal Reports version of the same report uses the same query but it properly displays the multiple page report. Also, other multiple-page reports that I have migrated over to SSRS are properly displaying all their pages. Does anyone have
any suggestsion? TIA.
Here is some of the RDL file:
<?xml version="1.0" encoding="utf-8"?>
<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition">
<DataSources>
<DataSource Name="ContactManagement">
<ConnectionProperties>
<DataProvider>SQL</DataProvider>
<ConnectString>Data Source=NTDSCAL02;Initial Catalog=ContactManagement</ConnectString>
<IntegratedSecurity>true</IntegratedSecurity>
</ConnectionProperties>
<rd:DataSourceID>5f8d4354-4a27-4e38-93a4-4d5ca70c7e5d</rd:DataSourceID>
<rd:SecurityType>Windows</rd:SecurityType>
</DataSource>
</DataSources>
<DataSets>
<DataSet Name="dsContactFullPageSummary">
<Fields>
<Field Name="PrimaryID">
<DataField>PrimaryID</DataField>
<rd:TypeName>System.Guid</rd:TypeName>
</Field>
<Field Name="FirstLastName">
<DataField>FirstLastName</DataField>
<rd:UserDefined>true</rd:UserDefined>
</Field>
<Field Name="FirstName">
<DataField>FirstName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="FullName">
<DataField>FullName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<!-- elided ... -->
<Query>
<DataSourceName>ContactManagement</DataSourceName>
<CommandText>SELECT * FROM ContactManagement.dbo.qryREPORTContactFullPageSummary
WHERE PrimaryID IN (SELECT ReportItemID FROM tblReportItem WHERE PersonnelID=@PersonnelID)
ORDER BY FirstLastName</CommandText>
<QueryParameters>
<QueryParameter Name="@PersonnelID">
<Value>=Parameters!PersonnelID.Value</Value>
</QueryParameter>
</QueryParameters>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
</DataSets>
<Body>
<ReportItems>
<Textbox Name="txtFirstName">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>First Name:</Value>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>11pt</FontSize>
<FontWeight>Bold</FontWeight>
<Color>White</Color>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Top>0.98736in</Top>
<Left>0.11541in</Left>
<Height>0.22in</Height>
<Width>1.8014in</Width>
<Style>
<Border>
<Color>DimGray</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>Black</BackgroundColor>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Line Name="Line1">
<Top>0.54292in</Top>
<Height>0in</Height>
<Width>8.51125in</Width>
<ZIndex>1</ZIndex>
<Style>
<Border>
<Style>Solid</Style>
</Border>
</Style>
</Line>
<Textbox Name="Textbox2">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!FirstLastName.Value</Value>
<Style>
<FontSize>14pt</FontSize>
<FontWeight>Bold</FontWeight>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>Textbox2</rd:DefaultName>
<Top>0.11236in</Top>
<Left>0.11541in</Left>
<Height>0.36111in</Height>
<Width>3.74917in</Width>
<ZIndex>2</ZIndex>
<Style>
<Border>
<Style>None</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<!-- elided ... -->
<ReportParameters>
<ReportParameter Name="PersonnelID">
<DataType>String</DataType>
<Prompt>PersonnelID</Prompt>
</ReportParameter>
</ReportParameters>
<Width>8.51125in</Width>
<Page>
<PageHeader>
<Height>0.51389in</Height>
<PrintOnFirstPage>true</PrintOnFirstPage>
<PrintOnLastPage>true</PrintOnLastPage>
<ReportItems>
<Textbox Name="txtPageInfo">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>ContactManagement_ContactFullPageSummary - Page </Value>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
<TextRun>
<Value>=Globals!PageNumber</Value>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
<TextRun>
<Value> of </Value>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
<TextRun>
<Value>=Globals!TotalPages</Value>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Right</TextAlign>
</Style>
</Paragraph>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=User!UserID</Value>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
<TextRun>
<Value> @ </Value>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
<TextRun>
<Value>=FORMAT(Globals!ExecutionTime,"yyyy-MM-dd HH:mm:ss")</Value>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Right</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<Top>0.08389in</Top>
<Left>4.85069in</Left>
<Height>0.33in</Height>
<Width>3.66056in</Width>
<Style>
<Border>
<Style>None</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<!-- elided ... -->
<InteractiveHeight>0in</InteractiveHeight>
<InteractiveWidth>0in</InteractiveWidth>
<LeftMargin>1in</LeftMargin>
<RightMargin>1in</RightMargin>
<TopMargin>1in</TopMargin>
<BottomMargin>1in</BottomMargin>
<Style />
</Page>
<!-- elided ... -->
<Language>en-US</Language>
<ConsumeContainerWhitespace>true</ConsumeContainerWhitespace>
<rd:ReportID>6ffe3be5-b355-4feb-a56e-9084782d71bd</rd:ReportID>
<rd:ReportUnitType>Inch</rd:ReportUnitType>
</Report>
May 11th, 2011 2:14pm
Alternatively, I would like to insert a tablix instead of using individual text boxes for full name, first name, last name, etc., and then group the tablix on full name, with the field headings being along the left vertical column instead of having the
default behaviour where the column headings are horizontal along the top row. Presently I am using SQL Server 2008. Does anyone have any suggestions on how to do this? TIA.
Free Windows Admin Tool Kit Click here and download it now
May 11th, 2011 6:57pm
Hi,
After checked the RDL in your post, I found many tags were not closed. So, you might run into the issue that the RDL file invalid.
Generally, a Reporting Services report is able to span on multiple pages. For example, if we insert a Tablix control to the report, we can add groups to the Tablix based on data
fields, and we can also enable page break for the group. When the report is rendering, each group instance will be displayed on separate page.
For the detailed steps, I would suggest refer to the
Tutorial: Adding Grouping, Sorting, and Formatting to a Basic Report at
http://msdn.microsoft.com/en-us/library/ms170623.aspx
Thanks,
Tony Chain
Tony Chain [MSFT CSG] | Microsoft Community Support
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
May 18th, 2011 1:29am
From the above link you gave I found this page that provides helpful details on building a basic report:
http://msdn.microsoft.com/en-us/library/ms167305(v=SQL.100).aspx
That said, it still shows creating a tablix with all the headers along the top row and the rows populating downwards. Could you please tell me, how would I create a tablix with all the headers along the left hand side vertical column and the details
for a single record to the right of that? Here is a sample of a single page I want for the report:
http://www.flickr.com/photos/63267385@N05/5755990213/in/photostream/lightbox/
It works fine for only a single-page report; however, in this case my report should have 5 or 10 pages, each with a separate contact. Could you please tell me, why is only one page showing up with SSRS? TIA.
Free Windows Admin Tool Kit Click here and download it now
May 24th, 2011 6:35pm
Hi Tony,
Please note that I figured out how to do it by putting all the textbox and label controls inside a single-celled list item, and using that to create a parent groups. Please see this website for details
http://geekswithblogs.net/tmurphy/archive/2011/02/14/creating-parent-child-relationships-in-ssrs.aspx
Thanks anyways!
All the best,
Roger
May 25th, 2011 1:15pm
Hi Tony,
Please note that I figured out how to do it by putting all the textbox and label controls inside a single-celled list item, and using that to create a parent groups. Please see this website for details
http://geekswithblogs.net/tmurphy/archive/2011/02/14/creating-parent-child-relationships-in-ssrs.aspx
Thanks anyways!
All the best,
Roger
Free Windows Admin Tool Kit Click here and download it now
May 25th, 2011 1:15pm
This topic is archived. No further replies will be accepted.
Other recent topics
