Sorry, another:The report definition for report has not been specified

I've gone through all of the posts on this subject and cannot find a resolution.

I do the report creation using a Report Server project. Create the .rdl report with the subreport. Beautiful, works as advertised!

When I copy them over into my project, rename them to .rdlc and run the project I get the infamous message in the immedite window and the subreport doesn't load. The .rdlc files are loaded as an embedded resource. I found the post that says 'if it knows where to load the main report it also knows where the subreport is'.

I use:

Dim hdl As New SubreportProcessingEventHandler(AddressOf MySub)

AddHandler reportViewer.LocalReport.SubreportProcessing, hdl

Which never fires because the subreport isn't found. I found the post that explained what the msg in the immedite window means. But why can't it find the subreport report I've checked datasource names etc and cannot find an error. I have no parameters as I load the data required and pass it to both the main report and the subreport so that should not be an issue.

Rick



Answer this question

Sorry, another:The report definition for report has not been specified

  • sonal_new2xml

    A long paste. If this is not what you ment or would like a shorter version I could dump data and redo.

    Thanks,

    Rick

    Main Report:

    ------------------------------------------------------------------------------------------------

    < xml version="1.0" encoding="utf-8" >

    <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">

    <DataSources>

    <DataSource Name="SWSchedule">

    <DataSourceReference>SWSchedule</DataSourceReference>

    <rd:DataSourceID>acd5f6c2-058a-4bff-9ca2-05948f9a51bb</rd:DataSourceID>

    </DataSource>

    </DataSources>

    <BottomMargin>2.5cm</BottomMargin>

    <RightMargin>2.5cm</RightMargin>

    <PageWidth>21cm</PageWidth>

    <rd:DrawGrid>true</rd:DrawGrid>

    <InteractiveWidth>21cm</InteractiveWidth>

    <rd:GridSpacing>0.25cm</rd:GridSpacing>

    <rd:SnapToGrid>true</rd:SnapToGrid>

    <Body>

    <ColumnSpacing>1cm</ColumnSpacing>

    <ReportItems>

    <List Name="ListShiftCycle">

    <ReportItems>

    <Table Name="table1">

    <DataSetName>SWSchedule</DataSetName>

    <Top>4.75cm</Top>

    <ZIndex>16</ZIndex>

    <Details>

    <TableRows>

    <TableRow>

    <TableCells>

    <TableCell>

    <ReportItems>

    <Textbox Name="Label">

    <rd:DefaultName>Label</rd:DefaultName>

    <ZIndex>5</ZIndex>

    <Style>

    <PaddingLeft>2pt</PaddingLeft>

    <PaddingBottom>2pt</PaddingBottom>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    <CanGrow>true</CanGrow>

    <Value>=Fields!Label.Value</Value>

    </Textbox>

    </ReportItems>

    </TableCell>

    <TableCell>

    <ReportItems>

    <Textbox Name="Shift">

    <rd:DefaultName>Shift</rd:DefaultName>

    <ZIndex>4</ZIndex>

    <Style>

    <PaddingLeft>2pt</PaddingLeft>

    <PaddingBottom>2pt</PaddingBottom>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    <CanGrow>true</CanGrow>

    <Value>=Fields!Shift.Value</Value>

    </Textbox>

    </ReportItems>

    </TableCell>

    <TableCell>

    <ReportItems>

    <Textbox Name="LabelDesc">

    <rd:DefaultName>LabelDesc</rd:DefaultName>

    <ZIndex>3</ZIndex>

    <Style>

    <PaddingLeft>2pt</PaddingLeft>

    <PaddingBottom>2pt</PaddingBottom>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    <CanGrow>true</CanGrow>

    <Value>=Fields!LabelDesc.Value</Value>

    </Textbox>

    </ReportItems>

    </TableCell>

    <TableCell>

    <ReportItems>

    <Textbox Name="StartTime">

    <rd:DefaultName>StartTime</rd:DefaultName>

    <ZIndex>2</ZIndex>

    <Style>

    <TextAlign>Right</TextAlign>

    <PaddingLeft>2pt</PaddingLeft>

    <PaddingBottom>2pt</PaddingBottom>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    <CanGrow>true</CanGrow>

    <Value>=format(cdate(Fields!StartTime.Value),"t")</Value>

    </Textbox>

    </ReportItems>

    </TableCell>

    <TableCell>

    <ReportItems>

    <Textbox Name="HoursThisLabel">

    <rd:DefaultName>HoursThisLabel</rd:DefaultName>

    <ZIndex>1</ZIndex>

    <Style>

    <TextAlign>Center</TextAlign>

    <PaddingLeft>2pt</PaddingLeft>

    <PaddingBottom>2pt</PaddingBottom>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    <CanGrow>true</CanGrow>

    <Value>=Fields!HoursThisLabel.Value</Value>

    </Textbox>

    </ReportItems>

    </TableCell>

    <TableCell>

    <ReportItems>

    <Textbox Name="OnShift">

    <rd:DefaultName>OnShift</rd:DefaultName>

    <Style>

    <PaddingLeft>2pt</PaddingLeft>

    <PaddingBottom>2pt</PaddingBottom>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    <CanGrow>true</CanGrow>

    <Value>=IIF(Fields!OnShift.Value,"On Shift", "Off Shift")</Value>

    </Textbox>

    </ReportItems>

    </TableCell>

    </TableCells>

    <Height>0.63492cm</Height>

    </TableRow>

    </TableRows>

    <Sorting>

    <SortBy>

    <SortExpression>=Fields!Label.Value</SortExpression>

    <Direction>Ascending</Direction>

    </SortBy>

    </Sorting>

    </Details>

    <Style>

    <FontSize>9pt</FontSize>

    </Style>

    <Header>

    <TableRows>

    <TableRow>

    <TableCells>

    <TableCell>

    <ReportItems>

    <Textbox Name="textbox9">

    <rd:DefaultName>textbox9</rd:DefaultName>

    <ZIndex>11</ZIndex>

    <Style>

    <BorderStyle>

    <Bottom>Solid</Bottom>

    </BorderStyle>

    <PaddingLeft>2pt</PaddingLeft>

    <BorderWidth>

    <Bottom>1pt</Bottom>

    </BorderWidth>

    <PaddingBottom>2pt</PaddingBottom>

    <BorderColor>

    <Bottom>Black</Bottom>

    </BorderColor>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    <CanGrow>true</CanGrow>

    <Value>Label</Value>

    </Textbox>

    </ReportItems>

    </TableCell>

    <TableCell>

    <ReportItems>

    <Textbox Name="textbox11">

    <rd:DefaultName>textbox11</rd:DefaultName>

    <ZIndex>10</ZIndex>

    <Style>

    <BorderStyle>

    <Bottom>Solid</Bottom>

    </BorderStyle>

    <PaddingLeft>2pt</PaddingLeft>

    <BorderWidth>

    <Bottom>1pt</Bottom>

    </BorderWidth>

    <PaddingBottom>2pt</PaddingBottom>

    <BorderColor>

    <Bottom>Black</Bottom>

    </BorderColor>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    <CanGrow>true</CanGrow>

    <Value>Shift</Value>

    </Textbox>

    </ReportItems>

    </TableCell>

    <TableCell>

    <ReportItems>

    <Textbox Name="textbox12">

    <rd:DefaultName>textbox12</rd:DefaultName>

    <ZIndex>9</ZIndex>

    <Style>

    <BorderStyle>

    <Bottom>Solid</Bottom>

    </BorderStyle>

    <PaddingLeft>2pt</PaddingLeft>

    <BorderWidth>

    <Bottom>1pt</Bottom>

    </BorderWidth>

    <PaddingBottom>2pt</PaddingBottom>

    <BorderColor>

    <Bottom>Black</Bottom>

    </BorderColor>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    <CanGrow>true</CanGrow>

    <Value>Label Desc</Value>

    </Textbox>

    </ReportItems>

    </TableCell>

    <TableCell>

    <ReportItems>

    <Textbox Name="textbox13">

    <rd:DefaultName>textbox13</rd:DefaultName>

    <ZIndex>8</ZIndex>

    <Style>

    <BorderStyle>

    <Bottom>Solid</Bottom>

    </BorderStyle>

    <TextAlign>Center</TextAlign>

    <PaddingLeft>2pt</PaddingLeft>

    <BorderWidth>

    <Bottom>1pt</Bottom>

    </BorderWidth>

    <PaddingBottom>2pt</PaddingBottom>

    <BorderColor>

    <Bottom>Black</Bottom>

    </BorderColor>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    <CanGrow>true</CanGrow>

    <Value>Start Time</Value>

    </Textbox>

    </ReportItems>

    </TableCell>

    <TableCell>

    <ReportItems>

    <Textbox Name="textbox14">

    <rd:DefaultName>textbox14</rd:DefaultName>

    <ZIndex>7</ZIndex>

    <Style>

    <BorderStyle>

    <Bottom>Solid</Bottom>

    </BorderStyle>

    <TextAlign>Center</TextAlign>

    <PaddingLeft>2pt</PaddingLeft>

    <BorderWidth>

    <Bottom>1pt</Bottom>

    </BorderWidth>

    <PaddingBottom>2pt</PaddingBottom>

    <BorderColor>

    <Bottom>Black</Bottom>

    </BorderColor>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    <CanGrow>true</CanGrow>

    <Value>Hours</Value>

    </Textbox>

    </ReportItems>

    </TableCell>

    <TableCell>

    <ReportItems>

    <Textbox Name="textbox19">

    <rd:DefaultName>textbox19</rd:DefaultName>

    <ZIndex>6</ZIndex>

    <Style>

    <BorderStyle>

    <Bottom>Solid</Bottom>

    </BorderStyle>

    <PaddingLeft>2pt</PaddingLeft>

    <BorderWidth>

    <Bottom>1pt</Bottom>

    </BorderWidth>

    <PaddingBottom>2pt</PaddingBottom>

    <BorderColor>

    <Bottom>Black</Bottom>

    </BorderColor>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    <CanGrow>true</CanGrow>

    <Value>On Shift</Value>

    </Textbox>

    </ReportItems>

    </TableCell>

    </TableCells>

    <Height>0.63492cm</Height>

    </TableRow>

    </TableRows>

    </Header>

    <TableColumns>

    <TableColumn>

    <Width>2cm</Width>

    </TableColumn>

    <TableColumn>

    <Width>2cm</Width>

    </TableColumn>

    <TableColumn>

    <Width>5.08333cm</Width>

    </TableColumn>

    <TableColumn>

    <Width>2.25cm</Width>

    </TableColumn>

    <TableColumn>

    <Width>2.25cm</Width>

    </TableColumn>

    <TableColumn>

    <Width>2.25cm</Width>

    </TableColumn>

    </TableColumns>

    <Height>1.26984cm</Height>

    </Table>

    <Textbox Name="Released">

    <Left>9cm</Left>

    <Top>2.75cm</Top>

    <rd:DefaultName>Released</rd:DefaultName>

    <ZIndex>15</ZIndex>

    <Width>3.25cm</Width>

    <Style>

    <PaddingLeft>2pt</PaddingLeft>

    <PaddingBottom>2pt</PaddingBottom>

    <FontSize>9pt</FontSize>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    <CanGrow>true</CanGrow>

    <Height>0.63492cm</Height>

    <Value>=IIF(Fields!Released.Value,"Released","Unreleased")</Value>

    </Textbox>

    <Textbox Name="NoOfDaysInCycle">

    <Left>4.25cm</Left>

    <Top>2.75cm</Top>

    <rd:DefaultName>NoOfDaysInCycle</rd:DefaultName>

    <ZIndex>14</ZIndex>

    <Width>2cm</Width>

    <Style>

    <PaddingLeft>2pt</PaddingLeft>

    <PaddingBottom>2pt</PaddingBottom>

    <FontSize>9pt</FontSize>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    <CanGrow>true</CanGrow>

    <Height>0.63492cm</Height>

    <Value>=First(Fields!NoOfDaysInCycle.Value)</Value>

    </Textbox>

    <Textbox Name="ShiftStartOnDate">

    <Left>10cm</Left>

    <Top>1.25cm</Top>

    <rd:DefaultName>ShiftStartOnDate</rd:DefaultName>

    <ZIndex>13</ZIndex>

    <Width>5.5cm</Width>

    <Style>

    <PaddingLeft>2pt</PaddingLeft>

    <PaddingBottom>2pt</PaddingBottom>

    <FontSize>9pt</FontSize>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    <CanGrow>true</CanGrow>

    <Height>0.63492cm</Height>

    <Value>=Format(Fields!ShiftStartOnDate.Value,"D")</Value>

    </Textbox>

    <Textbox Name="NumberOfTeams">

    <Left>11cm</Left>

    <Top>2cm</Top>

    <rd:DefaultName>NumberOfTeams</rd:DefaultName>

    <ZIndex>12</ZIndex>

    <Width>2.53968cm</Width>

    <Style>

    <TextAlign>Right</TextAlign>

    <PaddingLeft>2pt</PaddingLeft>

    <PaddingBottom>2pt</PaddingBottom>

    <FontSize>9pt</FontSize>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    <CanGrow>true</CanGrow>

    <Height>0.63492cm</Height>

    <Value>=first(Fields!NumberOfTeams.Value)</Value>

    </Textbox>

    <Textbox Name="ShiftType">

    <Left>2.25cm</Left>

    <Top>2cm</Top>

    <rd:DefaultName>ShiftType</rd:DefaultName>

    <ZIndex>11</ZIndex>

    <Width>2.53968cm</Width>

    <Style>

    <PaddingLeft>2pt</PaddingLeft>

    <PaddingBottom>2pt</PaddingBottom>

    <FontSize>9pt</FontSize>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    <CanGrow>true</CanGrow>

    <Height>0.63492cm</Height>

    <Value>=First(Fields!ShiftType.Value)</Value>

    </Textbox>

    <Textbox Name="textbox8">

    <Top>2.75cm</Top>

    <rd:DefaultName>textbox8</rd:DefaultName>

    <ZIndex>10</ZIndex>

    <Width>4cm</Width>

    <Style>

    <PaddingLeft>2pt</PaddingLeft>

    <PaddingBottom>2pt</PaddingBottom>

    <FontSize>9pt</FontSize>

    <Color>Maroon</Color>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    <CanGrow>true</CanGrow>

    <Height>0.63492cm</Height>

    <Value>Number of days in cycle:</Value>

    </Textbox>

    <Textbox Name="textbox7">

    <Left>7cm</Left>

    <Top>2cm</Top>

    <rd:DefaultName>textbox7</rd:DefaultName>

    <ZIndex>9</ZIndex>

    <Width>3.75cm</Width>

    <Style>

    <PaddingLeft>2pt</PaddingLeft>

    <PaddingBottom>2pt</PaddingBottom>

    <FontSize>9pt</FontSize>

    <Color>Maroon</Color>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    <CanGrow>true</CanGrow>

    <Height>0.63492cm</Height>

    <Value>Number of teams:</Value>

    </Textbox>

    <Textbox Name="textbox6">

    <Top>2cm</Top>

    <rd:DefaultName>textbox6</rd:DefaultName>

    <ZIndex>8</ZIndex>

    <Width>2.03968cm</Width>

    <Style>

    <PaddingLeft>2pt</PaddingLeft>

    <PaddingBottom>2pt</PaddingBottom>

    <FontSize>9pt</FontSize>

    <Color>Maroon</Color>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    <CanGrow>true</CanGrow>

    <Height>0.63492cm</Height>

    <Value>Shift Type:</Value>

    </Textbox>

    <Textbox Name="textbox5">

    <Left>7cm</Left>

    <Top>2.75cm</Top>

    <rd:DefaultName>textbox5</rd:DefaultName>

    <ZIndex>7</ZIndex>

    <Width>1.75cm</Width>

    <Style>

    <PaddingLeft>2pt</PaddingLeft>

    <PaddingBottom>2pt</PaddingBottom>

    <FontSize>9pt</FontSize>

    <Color>Maroon</Color>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    <CanGrow>true</CanGrow>

    <Height>0.63492cm</Height>

    <Value>Status:</Value>

    </Textbox>

    <Textbox Name="textbox4">

    <Left>7cm</Left>

    <Top>1.25cm</Top>

    <rd:DefaultName>textbox4</rd:DefaultName>

    <ZIndex>6</ZIndex>

    <Width>3cm</Width>

    <Style>

    <PaddingLeft>2pt</PaddingLeft>

    <PaddingBottom>2pt</PaddingBottom>

    <FontSize>9pt</FontSize>

    <Color>Maroon</Color>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    <CanGrow>true</CanGrow>

    <Height>0.63492cm</Height>

    <Value>Shift start date:</Value>

    </Textbox>

    <Textbox Name="textbox3">

    <Top>3.5cm</Top>

    <rd:DefaultName>textbox3</rd:DefaultName>

    <ZIndex>5</ZIndex>

    <Width>2.25cm</Width>

    <Style>

    <PaddingLeft>2pt</PaddingLeft>

    <PaddingBottom>2pt</PaddingBottom>

    <FontSize>9pt</FontSize>

    <Color>Maroon</Color>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    <CanGrow>true</CanGrow>

    <Height>0.63492cm</Height>

    <Value>Description:</Value>

    </Textbox>

    <Textbox Name="textbox2">

    <Top>1.25cm</Top>

    <rd:DefaultName>textbox2</rd:DefaultName>

    <ZIndex>4</ZIndex>

    <Width>1.75cm</Width>

    <Style>

    <PaddingLeft>2pt</PaddingLeft>

    <PaddingBottom>2pt</PaddingBottom>

    <FontSize>9pt</FontSize>

    <Color>Maroon</Color>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    <CanGrow>true</CanGrow>

    <Height>0.63492cm</Height>

    <Value>Shift Title:</Value>

    </Textbox>

    <Textbox Name="ShiftDesc">

    <Left>2.5cm</Left>

    <Top>3.5cm</Top>

    <rd:DefaultName>ShiftDesc</rd:DefaultName>

    <ZIndex>3</ZIndex>

    <Width>13cm</Width>

    <Style>

    <PaddingLeft>2pt</PaddingLeft>

    <PaddingBottom>2pt</PaddingBottom>

    <FontSize>9pt</FontSize>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    <CanGrow>true</CanGrow>

    <Height>0.63492cm</Height>

    <Value>=First(Fields!ShiftDesc.Value)</Value>

    </Textbox>

    <Textbox Name="ShiftTitle">

    <Left>2cm</Left>

    <Top>1.25cm</Top>

    <rd:DefaultName>ShiftTitle</rd:DefaultName>

    <ZIndex>2</ZIndex>

    <Width>4.5cm</Width>

    <Style>

    <PaddingLeft>2pt</PaddingLeft>

    <PaddingBottom>2pt</PaddingBottom>

    <FontSize>9pt</FontSize>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    <CanGrow>true</CanGrow>

    <Height>0.63492cm</Height>

    <Value>=First(Fields!ShiftTitle.Value)</Value>

    </Textbox>

    <Textbox Name="kkNGzj3EN8">

    <rd:DefaultName>kkNGzj3EN8</rd:DefaultName>

    <ZIndex>1</ZIndex>

    <Width>12.25cm</Width>

    <Style>

    <TextAlign>Left</TextAlign>

    <PaddingLeft>2pt</PaddingLeft>

    <PaddingBottom>2pt</PaddingBottom>

    <FontSize>14pt</FontSize>

    <Color>Navy</Color>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    <CanGrow>true</CanGrow>

    <Height>1cm</Height>

    <Value>=First(Fields!kkNGzj3EN8.Value)</Value>

    </Textbox>

    <Subreport Name="subCycle">

    <Left>0.25cm</Left>

    <Top>6.5cm</Top>

    <Width>15.25cm</Width>

    <ReportName>Cycle</ReportName>

    <Style>

    <TextAlign>Left</TextAlign>

    </Style>

    </Subreport>

    </ReportItems>

    <DataSetName>SWSchedule</DataSetName>

    <Top>1cm</Top>

    <ZIndex>1</ZIndex>

    <Grouping Name="ListShiftCycle_Details_Group">

    <PageBreakAtEnd>true</PageBreakAtEnd>

    <GroupExpressions>

    <GroupExpression>=Fields!ShiftCycleNo.Value</GroupExpression>

    </GroupExpressions>

    </Grouping>

    </List>

    <Textbox Name="textbox1">

    <rd:DefaultName>textbox1</rd:DefaultName>

    <Width>15.25cm</Width>

    <Style>

    <BorderStyle>

    <Bottom>Solid</Bottom>

    <Top>Solid</Top>

    </BorderStyle>

    <TextAlign>Center</TextAlign>

    <PaddingLeft>2pt</PaddingLeft>

    <BorderWidth>

    <Bottom>1pt</Bottom>

    <Top>1pt</Top>

    </BorderWidth>

    <PaddingBottom>2pt</PaddingBottom>

    <FontWeight>700</FontWeight>

    <FontSize>12pt</FontSize>

    <BorderColor>

    <Bottom>Black</Bottom>

    <Top>Black</Top>

    </BorderColor>

    <BackgroundColor>WhiteSmoke</BackgroundColor>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    <CanGrow>true</CanGrow>

    <Height>0.75cm</Height>

    <Value>Schedule - Shift Cycle</Value>

    </Textbox>

    </ReportItems>

    <Height>8.25cm</Height>

    </Body>

    <PageHeader>

    <ReportItems>

    <Textbox Name="SWHeader">

    <Width>1.75cm</Width>

    <Style>

    <PaddingLeft>2pt</PaddingLeft>

    <PaddingBottom>2pt</PaddingBottom>

    <FontFamily>Tahoma</FontFamily>

    <Color>RoyalBlue</Color>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    <CanGrow>true</CanGrow>

    <Value>ShiftWise</Value>

    </Textbox>

    </ReportItems>

    <Height>0.5cm</Height>

    <PrintOnLastPage>true</PrintOnLastPage>

    <PrintOnFirstPage>true</PrintOnFirstPage>

    </PageHeader>

    <rd:ReportID>4abefd1b-d62e-4bc9-aa96-cfae970dfb57</rd:ReportID>

    <LeftMargin>2.5cm</LeftMargin>

    <DataSets>

    <DataSet Name="SWSchedule">

    <Query>

    <rd:UseGenericDesigner>true</rd:UseGenericDesigner>

    <CommandText>Select * from vrptShiftCycle</CommandText>

    <DataSourceName>SWSchedule</DataSourceName>

    </Query>

    <Fields>

    <Field Name="ShiftCycleNo">

    <rd:TypeName>System.Int32</rd:TypeName>

    <DataField>ShiftCycleNo</DataField>

    </Field>

    <Field Name="ShiftTitle">

    <rd:TypeName>System.String</rd:TypeName>

    <DataField>ShiftTitle</DataField>

    </Field>

    <Field Name="ShiftDesc">

    <rd:TypeName>System.String</rd:TypeName>

    <DataField>ShiftDesc</DataField>

    </Field>

    <Field Name="NoOfDaysInCycle">

    <rd:TypeName>System.Int32</rd:TypeName>

    <DataField>NoOfDaysInCycle</DataField>

    </Field>

    <Field Name="ShiftStartOnDate">

    <rd:TypeName>System.DateTime</rd:TypeName>

    <DataField>ShiftStartOnDate</DataField>

    </Field>

    <Field Name="ShiftType">

    <rd:TypeName>System.String</rd:TypeName>

    <DataField>ShiftType</DataField>

    </Field>

    <Field Name="NumberOfTeams">

    <rd:TypeName>System.Int32</rd:TypeName>

    <DataField>NumberOfTeams</DataField>

    </Field>

    <Field Name="Released">

    <rd:TypeName>System.Boolean</rd:TypeName>

    <DataField>Released</DataField>

    </Field>

    <Field Name="Label">

    <rd:TypeName>System.String</rd:TypeName>

    <DataField>Label</DataField>

    </Field>

    <Field Name="Shift">

    <rd:TypeName>System.String</rd:TypeName>

    <DataField>Shift</DataField>

    </Field>

    <Field Name="StartTime">

    <rd:TypeName>System.DateTime</rd:TypeName>

    <DataField>StartTime</DataField>

    </Field>

    <Field Name="HoursThisLabel">

    <rd:TypeName>System.Double</rd:TypeName>

    <DataField>HoursThisLabel</DataField>

    </Field>

    <Field Name="LabelDesc">

    <rd:TypeName>System.String</rd:TypeName>

    <DataField>LabelDesc</DataField>

    </Field>

    <Field Name="OnShift">

    <rd:TypeName>System.Boolean</rd:TypeName>

    <DataField>OnShift</DataField>

    </Field>

    <Field Name="kkNGzj3EN8">

    <DataField>kkNGzj3EN8</DataField>

    </Field>

    </Fields>

    </DataSet>

    </DataSets>

    <Width>15.83333cm</Width>

    <InteractiveHeight>29.7cm</InteractiveHeight>

    <Language>en-US</Language>

    <PageFooter>

    <ReportItems>

    <Textbox Name="textbox10">

    <Top>0.75cm</Top>

    <rd:DefaultName>textbox10</rd:DefaultName>

    <ZIndex>1</ZIndex>

    <Width>2.53968cm</Width>

    <Style>

    <PaddingLeft>2pt</PaddingLeft>

    <PaddingBottom>2pt</PaddingBottom>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    <CanGrow>true</CanGrow>

    <Value>="Page" &amp; Globals!PageNumber &amp; " of " &amp; Globals!TotalPages</Value>

    </Textbox>

    <Textbox Name="FTDate">

    <Left>10cm</Left>

    <Top>0.75cm</Top>

    <Width>5.25cm</Width>

    <Style>

    <TextAlign>Left</TextAlign>

    <PaddingLeft>2pt</PaddingLeft>

    <PaddingBottom>2pt</PaddingBottom>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    <CanGrow>true</CanGrow>

    <Value>="Printed: " &amp; Year(now) &amp; "-" &amp; Month(Now) &amp; "-" &amp; Day(Now) &amp; " : " &amp; TimeString</Value>

    </Textbox>

    </ReportItems>

    <Height>1.38492cm</Height>

    <PrintOnLastPage>true</PrintOnLastPage>

    <PrintOnFirstPage>true</PrintOnFirstPage>

    </PageFooter>

    <TopMargin>2.5cm</TopMargin>

    <PageHeight>29.7cm</PageHeight>

    </Report>

    --------------------------------------------------------------------------------------------------------

    Sub Report:

    -------------------------------------------------------------------------------------------------------

    < xml version="1.0" encoding="utf-8" >

    <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">

    <DataSources>

    <DataSource Name="SWSchedule">

    <DataSourceReference>SWSchedule</DataSourceReference>

    <rd:DataSourceID>4c90c6ba-6c9f-4009-9381-a202b84ed311</rd:DataSourceID>

    </DataSource>

    </DataSources>

    <BottomMargin>2.5cm</BottomMargin>

    <RightMargin>2.5cm</RightMargin>

    <PageWidth>21cm</PageWidth>

    <rd:DrawGrid>true</rd:DrawGrid>

    <InteractiveWidth>21cm</InteractiveWidth>

    <rd:GridSpacing>0.25cm</rd:GridSpacing>

    <rd:SnapToGrid>true</rd:SnapToGrid>

    <Body>

    <ColumnSpacing>1cm</ColumnSpacing>

    <ReportItems>

    <Matrix Name="matrix1">

    <MatrixColumns>

    <MatrixColumn>

    <Width>0.75cm</Width>

    </MatrixColumn>

    </MatrixColumns>

    <Left>0.25cm</Left>

    <RowGroupings>

    <RowGrouping>

    <Width>2cm</Width>

    <DynamicRows>

    <ReportItems>

    <Textbox Name="textbox2">

    <rd:DefaultName>textbox2</rd:DefaultName>

    <ZIndex>2</ZIndex>

    <Visibility>

    <Hidden>true</Hidden>

    </Visibility>

    <Style>

    <BorderStyle>

    <Right>Solid</Right>

    </BorderStyle>

    <TextAlign>Right</TextAlign>

    <PaddingLeft>2pt</PaddingLeft>

    <BorderWidth>

    <Right>1pt</Right>

    </BorderWidth>

    <PaddingBottom>2pt</PaddingBottom>

    <BorderColor>

    <Right>Black</Right>

    </BorderColor>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    <CanGrow>true</CanGrow>

    <Value>=Fields!ShiftCycleNo.Value</Value>

    </Textbox>

    </ReportItems>

    <Sorting>

    <SortBy>

    <SortExpression>=Fields!ShiftCycleNo.Value</SortExpression>

    <Direction>Ascending</Direction>

    </SortBy>

    </Sorting>

    <Grouping Name="RowGrp_ShiftCycleNo">

    <GroupExpressions>

    <GroupExpression>=Fields!ShiftCycleNo.Value</GroupExpression>

    </GroupExpressions>

    </Grouping>

    </DynamicRows>

    </RowGrouping>

    <RowGrouping>

    <Width>2cm</Width>

    <DynamicRows>

    <ReportItems>

    <Textbox Name="CycleNo">

    <rd:DefaultName>CycleNo</rd:DefaultName>

    <ZIndex>1</ZIndex>

    <Style>

    <BorderStyle>

    <Right>Solid</Right>

    </BorderStyle>

    <TextAlign>Right</TextAlign>

    <PaddingLeft>2pt</PaddingLeft>

    <BorderWidth>

    <Right>1pt</Right>

    </BorderWidth>

    <PaddingBottom>2pt</PaddingBottom>

    <BorderColor>

    <Right>Black</Right>

    </BorderColor>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    <CanGrow>true</CanGrow>

    <Value>="Cycle " &amp; Fields!CycleNo.Value</Value>

    </Textbox>

    </ReportItems>

    <Sorting>

    <SortBy>

    <SortExpression>=Fields!ShiftCycleNo.Value</SortExpression>

    <Direction>Ascending</Direction>

    </SortBy>

    <SortBy>

    <SortExpression>=Fields!CycleNo.Value</SortExpression>

    <Direction>Ascending</Direction>

    </SortBy>

    </Sorting>

    <Grouping Name="RowGrp_CycleNo">

    <GroupExpressions>

    <GroupExpression>=Fields!CycleNo.Value</GroupExpression>

    </GroupExpressions>

    </Grouping>

    </DynamicRows>

    </RowGrouping>

    </RowGroupings>

    <ColumnGroupings>

    <ColumnGrouping>

    <DynamicColumns>

    <ReportItems>

    <Textbox Name="CycleOrder">

    <rd:DefaultName>CycleOrder</rd:DefaultName>

    <ZIndex>3</ZIndex>

    <Style>

    <BorderStyle>

    <Bottom>Solid</Bottom>

    </BorderStyle>

    <TextAlign>Center</TextAlign>

    <PaddingLeft>2pt</PaddingLeft>

    <BorderWidth>

    <Bottom>1pt</Bottom>

    </BorderWidth>

    <PaddingBottom>2pt</PaddingBottom>

    <BorderColor>

    <Bottom>Black</Bottom>

    </BorderColor>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    <CanGrow>true</CanGrow>

    <Value>=Fields!CycleOrder.Value</Value>

    </Textbox>

    </ReportItems>

    <Sorting>

    <SortBy>

    <SortExpression>=Fields!CycleOrder.Value</SortExpression>

    <Direction>Ascending</Direction>

    </SortBy>

    </Sorting>

    <Grouping Name="matrix1_CycleOrder">

    <GroupExpressions>

    <GroupExpression>=Fields!CycleOrder.Value</GroupExpression>

    </GroupExpressions>

    </Grouping>

    </DynamicColumns>

    <Height>0.63492cm</Height>

    </ColumnGrouping>

    </ColumnGroupings>

    <DataSetName>SWSchedule</DataSetName>

    <Top>0.25cm</Top>

    <Width>4.75cm</Width>

    <Corner>

    <ReportItems>

    <Textbox Name="textbox1">

    <rd:DefaultName>textbox1</rd:DefaultName>

    <ZIndex>4</ZIndex>

    <Style>

    <TextAlign>Center</TextAlign>

    <PaddingLeft>2pt</PaddingLeft>

    <PaddingBottom>2pt</PaddingBottom>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    <CanGrow>true</CanGrow>

    <Value />

    </Textbox>

    </ReportItems>

    </Corner>

    <Height>1.26984cm</Height>

    <MatrixRows>

    <MatrixRow>

    <Height>0.63492cm</Height>

    <MatrixCells>

    <MatrixCell>

    <ReportItems>

    <Textbox Name="Label">

    <rd:DefaultName>Label</rd:DefaultName>

    <Style>

    <BorderStyle>

    <Default>Solid</Default>

    </BorderStyle>

    <TextAlign>Center</TextAlign>

    <PaddingLeft>2pt</PaddingLeft>

    <PaddingBottom>2pt</PaddingBottom>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    <CanGrow>true</CanGrow>

    <Value>=First(Fields!Label.Value)</Value>

    </Textbox>

    </ReportItems>

    </MatrixCell>

    </MatrixCells>

    </MatrixRow>

    </MatrixRows>

    </Matrix>

    </ReportItems>

    <Height>1.75cm</Height>

    </Body>

    <rd:ReportID>540088db-d423-4196-921b-1365bb25f759</rd:ReportID>

    <LeftMargin>2.5cm</LeftMargin>

    <DataSets>

    <DataSet Name="SWSchedule">

    <Query>

    <rd:UseGenericDesigner>true</rd:UseGenericDesigner>

    <CommandText>Select * from vrptCycle</CommandText>

    <DataSourceName>SWSchedule</DataSourceName>

    </Query>

    <Fields>

    <Field Name="ShiftCycleNo">

    <rd:TypeName>System.Int32</rd:TypeName>

    <DataField>ShiftCycleNo</DataField>

    </Field>

    <Field Name="CycleNo">

    <rd:TypeName>System.Int32</rd:TypeName>

    <DataField>CycleNo</DataField>

    </Field>

    <Field Name="CycleOrder">

    <rd:TypeName>System.Int32</rd:TypeName>

    <DataField>CycleOrder</DataField>

    </Field>

    <Field Name="Label">

    <rd:TypeName>System.String</rd:TypeName>

    <DataField>Label</DataField>

    </Field>

    <Field Name="HoursThisLabel">

    <rd:TypeName>System.Double</rd:TypeName>

    <DataField>HoursThisLabel</DataField>

    </Field>

    </Fields>

    </DataSet>

    </DataSets>

    <Width>5.25cm</Width>

    <InteractiveHeight>29.7cm</InteractiveHeight>

    <Language>en-US</Language>

    <TopMargin>2.5cm</TopMargin>

    <PageHeight>29.7cm</PageHeight>

    </Report>


  • HemantSav

    Can you post the report definition so we can look at it

  • Rashmin_s_saraf

    Yes it is, build action: embedded resource for both main and sub report.

    I have more main/subreports to do, which I'll start tomorrow after lunch. I'm hoping this is a flaw, something specific to the report I created. I had an issue with an attribute I dropped on a table. Somehow the field name in the report definition had a extra 't' in the field name. Things happen.

    I'll post back the results, which ever way it goes.

    Rick


  • Fred h

    Are you sure that Cycle.rdlc is being included as an embedded resource with the same namespace prefix as the parent report Check that the build action for Cycle.rdlc is set to "embedded resource".
  • Sorry, another:The report definition for report has not been specified