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

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" & Globals!PageNumber & " of " & 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: " & Year(now) & "-" & Month(Now) & "-" & Day(Now) & " : " & 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 " & 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
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