Hello,
Can someone please tell me why there's ALWAYS a hidden cell in Excel when a report has a more than one page?
for example, a report has 10 page breaks and after exported to Excel it has the first row hidden in each sheet except the first sheet.
Why this happens always? is there any workaround to avoid this?
thanks
I also have the same questions as the original poster.
How does one get rid of the hidden row in an exported Excel spreadsheet when there are page breaks in the report?
Thanks in advance.
|||Hey Guys.
Can you clarify this a little more? I have exported my reports to excel but I get one long continuous sheet even when my report has multiple pages.
I have notice however that excel does include your report page margins, So I'm taking a guess that this could be what you're seeing in your export.
Ham
|||Hey Ham,
Yes, one long continuous sheet in Excel, but the page breaks are there in the report definition for viewing via the Report Manager web site. We (independently, the OP and I) think that somehow the page breaks are influencing the "hidden row" phenomenon.
The hidden row presents itself in the exported Excel spreadsheet on "Sheet 2", where "Sheet 1" was the parameter detail information. If one inspects Sheet 2 (which is the actual data produced by the report), one would see that row 1 is hidden (perhaps a better word is collapsed; one can expand it by double clicking on the row separator in the left margin-ish area), row 2 contains the header row/column headings, then row 3 and beyond contain the actual data.
Our report users don't like that hidden row 1. I know that it would be easy to expand and then remove it in Excel but....you know users, they don't want it there from the get-go.
Thanks for any advice.
John
|||Hi,
Can it be that you are using Document Maps in your report? It might be that it are document maps that you see.
Greetz,
Geert
Geert Verhoeven
Consultant @. Ausy Belgium
My Personal Blog
|||Hi Geert,
Although I didn't build the reports myself, I spoke with the author, and inspected the layout view (and RDL), and we are NOT using Document Maps.
Might there be another reason for the "hidden row" issue with exported Excel reports?
John
|||Hi John,
It is hard to say like that. Can you please mail or post the contents of the RDL file so I can take a look at it.
Greetz,
Geert
Geert Verhoeven
Consultant @. Ausy Belgium
My Personal Blog
|||Here is the RDL. I took the majority of lines associated with a BMP image. Thanks for taking a look.
<?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="dsKnetch">
<DataSourceReference>dsKnetch</DataSourceReference>
<rd:DataSourceID>42d0feab-c2ad-4306-b39a-0993cc80c5f8</rd:DataSourceID>
</DataSource>
</DataSources>
<BottomMargin>0.5in</BottomMargin>
<RightMargin>0.5in</RightMargin>
<PageWidth>11in</PageWidth>
<ReportParameters>
<ReportParameter Name="StartDtRange">
<DataType>DateTime</DataType>
<Prompt>Start of Date Range</Prompt>
</ReportParameter>
<ReportParameter Name="EndDtRange">
<DataType>DateTime</DataType>
<Prompt>End of Date Range</Prompt>
</ReportParameter>
<ReportParameter Name="Title">
<DataType>String</DataType>
<Prompt>Title Starts With</Prompt>
</ReportParameter>
</ReportParameters>
<rd:DrawGrid>true</rd:DrawGrid>
<InteractiveWidth>8.5in</InteractiveWidth>
<rd:SnapToGrid>true</rd:SnapToGrid>
<Body>
<ReportItems>
<Image Name="image1">
<Sizing>FitProportional</Sizing>
<ZIndex>5</ZIndex>
<Source>Embedded</Source>
<Style />
<Height>0.375in</Height>
<Value>knetch</Value>
</Image>
<Textbox Name="textbox38">
<Top>0.75in</Top>
<rd:DefaultName>textbox38</rd:DefaultName>
<ZIndex>4</ZIndex>
<Style>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>12pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>Knetch - Crosscheck Report (by Title & Date)</Value>
</Textbox>
<Textbox Name="textbox37">
<Top>0.375in</Top>
<rd:DefaultName>textbox37</rd:DefaultName>
<ZIndex>3</ZIndex>
<Style>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>12pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>Company</Value>
</Textbox>
<Rectangle Name="rectangle1">
<ReportItems>
<Textbox Name="textbox55">
<Left>1.5in</Left>
<Top>0.125in</Top>
<rd:DefaultName>textbox55</rd:DefaultName>
<ZIndex>3</ZIndex>
<Width>8.375in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontSize>9pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>=Parameters!Title.Value</Value>
</Textbox>
<Textbox Name="textbox28">
<Left>0.125in</Left>
<Top>0.125in</Top>
<ZIndex>2</ZIndex>
<Width>1.25in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontSize>9pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>Title Starts With:</Value>
</Textbox>
<Textbox Name="textbox2">
<Left>0.125in</Left>
<Top>0.375in</Top>
<ZIndex>1</ZIndex>
<Width>1.25in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontSize>9pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>Class(es) Date Range:</Value>
</Textbox>
<Textbox Name="textbox3">
<Left>1.5in</Left>
<Top>0.375in</Top>
<Width>8.375in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontSize>9pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>=Parameters!StartDtRange.Value & " to " & Parameters!EndDtRange.Value</Value>
</Textbox>
</ReportItems>
<Top>1.375in</Top>
<ZIndex>2</ZIndex>
<PageBreakAtEnd>true</PageBreakAtEnd>
<Height>0.625in</Height>
</Rectangle>
<Textbox Name="textbox54">
<Top>1.125in</Top>
<ZIndex>1</ZIndex>
<Width>2.75in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>Self Service Filter Options:</Value>
</Textbox>
<Table Name="table1">
<DataSetName>dsDisvantageCrosscheck</DataSetName>
<Top>2.125in</Top>
<Width>9.925in</Width>
<Details>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox4">
<rd:DefaultName>textbox4</rd:DefaultName>
<ZIndex>5</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontSize>9pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!username.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox5">
<rd:DefaultName>textbox5</rd:DefaultName>
<ZIndex>4</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontSize>9pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!employee_name.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox6">
<rd:DefaultName>textbox6</rd:DefaultName>
<ZIndex>3</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontSize>9pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!office_name.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox8">
<rd:DefaultName>textbox8</rd:DefaultName>
<ZIndex>2</ZIndex>
<Style>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontSize>9pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!class_no.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox12">
<rd:DefaultName>textbox12</rd:DefaultName>
<ZIndex>1</ZIndex>
<Style>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontSize>9pt</FontSize>
<Format>MM/dd/yy</Format>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!start_date.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox10">
<rd:DefaultName>textbox10</rd:DefaultName>
<Style>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontSize>9pt</FontSize>
<Format>MM/dd/yy</Format>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!end_date.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.2in</Height>
</TableRow>
</TableRows>
<Grouping Name="table1_Details_Group">
<GroupExpressions>
<GroupExpression>=Fields!username.Value</GroupExpression>
</GroupExpressions>
</Grouping>
<Sorting>
<SortBy>
<SortExpression>=Fields!employee_name.Value</SortExpression>
<Direction>Ascending</Direction>
</SortBy>
<SortBy>
<SortExpression>=Fields!start_date.Value</SortExpression>
<Direction>Ascending</Direction>
</SortBy>
<SortBy>
<SortExpression>=Fields!end_date.Value</SortExpression>
<Direction>Ascending</Direction>
</SortBy>
</Sorting>
</Details>
<Header>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox29">
<ZIndex>11</ZIndex>
<Style>
<BorderStyle>
<Bottom>Solid</Bottom>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<BorderWidth>
<Bottom>1pt</Bottom>
</BorderWidth>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<BorderColor>
<Bottom>Black</Bottom>
</BorderColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Username</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox30">
<ZIndex>10</ZIndex>
<Style>
<BorderStyle>
<Bottom>Solid</Bottom>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<BorderWidth>
<Bottom>1pt</Bottom>
</BorderWidth>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<BorderColor>
<Bottom>Black</Bottom>
</BorderColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Participant Name</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox31">
<ZIndex>9</ZIndex>
<Style>
<BorderStyle>
<Bottom>Solid</Bottom>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<BorderWidth>
<Bottom>1pt</Bottom>
</BorderWidth>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<BorderColor>
<Bottom>Black</Bottom>
</BorderColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Office</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox32">
<ZIndex>8</ZIndex>
<Style>
<BorderStyle>
<Bottom>Solid</Bottom>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<BorderWidth>
<Bottom>1pt</Bottom>
</BorderWidth>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<BorderColor>
<Bottom>Black</Bottom>
</BorderColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Class Number</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox33">
<ZIndex>7</ZIndex>
<Style>
<BorderStyle>
<Bottom>Solid</Bottom>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<BorderWidth>
<Bottom>1pt</Bottom>
</BorderWidth>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<BorderColor>
<Bottom>Black</Bottom>
</BorderColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Start Date</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox34">
<ZIndex>6</ZIndex>
<Style>
<BorderStyle>
<Bottom>Solid</Bottom>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<BorderWidth>
<Bottom>1pt</Bottom>
</BorderWidth>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<BorderColor>
<Bottom>Black</Bottom>
</BorderColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>End Date</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.25in</Height>
</TableRow>
</TableRows>
<RepeatOnNewPage>true</RepeatOnNewPage>
</Header>
<TableColumns>
<TableColumn>
<Width>1.5in</Width>
</TableColumn>
<TableColumn>
<Width>2.5in</Width>
</TableColumn>
<TableColumn>
<Width>3.125in</Width>
</TableColumn>
<TableColumn>
<Width>1in</Width>
</TableColumn>
<TableColumn>
<Width>0.9in</Width>
</TableColumn>
<TableColumn>
<Width>0.9in</Width>
</TableColumn>
</TableColumns>
<Height>0.45in</Height>
</Table>
</ReportItems>
<Height>2.75in</Height>
</Body>
<rd:ReportID>a8221bfa-83bd-4bbb-9054-09ad45a8dcad</rd:ReportID>
<LeftMargin>0.5in</LeftMargin>
<EmbeddedImages>
<EmbeddedImage Name="knetch">
<ImageData>Qk1atAA////</ImageData>
<MIMEType>image/bmp</MIMEType>
</EmbeddedImage>
</EmbeddedImages>
<DataSets>
<DataSet Name="dsDisCrosscheck">
<Query>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
<CommandType>StoredProcedure</CommandType>
<CommandText>rpt.up_get_class_attend_crosscheck_title_date</CommandText>
<QueryParameters>
<QueryParameter Name="@.Title">
<Value>=Parameters!Title.Value</Value>
</QueryParameter>
<QueryParameter Name="@.StartDtRange">
<Value>=Parameters!StartDtRange.Value</Value>
</QueryParameter>
<QueryParameter Name="@.EndDtRange">
<Value>=Parameters!EndDtRange.Value</Value>
</QueryParameter>
</QueryParameters>
<DataSourceName>dsKnetch</DataSourceName>
</Query>
<Fields>
<Field Name="reg_id">
<rd:TypeName>System.String</rd:TypeName>
<DataField>reg_id</DataField>
</Field>
<Field Name="class_no">
<rd:TypeName>System.String</rd:TypeName>
<DataField>class_no</DataField>
</Field>
<Field Name="course_no">
<rd:TypeName>System.String</rd:TypeName>
<DataField>course_no</DataField>
</Field>
<Field Name="course_title">
<rd:TypeName>System.String</rd:TypeName>
<DataField>course_title</DataField>
</Field>
<Field Name="course_type">
<rd:TypeName>System.String</rd:TypeName>
<DataField>course_type</DataField>
</Field>
<Field Name="function">
<rd:TypeName>System.String</rd:TypeName>
<DataField>function</DataField>
</Field>
<Field Name="start_date">
<rd:TypeName>System.DateTime</rd:TypeName>
<DataField>start_date</DataField>
</Field>
<Field Name="end_date">
<rd:TypeName>System.DateTime</rd:TypeName>
<DataField>end_date</DataField>
</Field>
<Field Name="credit_point">
<rd:TypeName>System.Decimal</rd:TypeName>
<DataField>credit_point</DataField>
</Field>
<Field Name="student_count">
<rd:TypeName>System.Decimal</rd:TypeName>
<DataField>student_count</DataField>
</Field>
<Field Name="peoplesoft_id">
<rd:TypeName>System.String</rd:TypeName>
<DataField>peoplesoft_id</DataField>
</Field>
<Field Name="username">
<rd:TypeName>System.String</rd:TypeName>
<DataField>username</DataField>
</Field>
<Field Name="employee_name">
<rd:TypeName>System.String</rd:TypeName>
<DataField>employee_name</DataField>
</Field>
<Field Name="reg_status">
<rd:TypeName>System.String</rd:TypeName>
<DataField>reg_status</DataField>
</Field>
<Field Name="text_status">
<rd:TypeName>System.String</rd:TypeName>
<DataField>text_status</DataField>
</Field>
<Field Name="loc_name">
<rd:TypeName>System.String</rd:TypeName>
<DataField>loc_name</DataField>
</Field>
<Field Name="office_name">
<rd:TypeName>System.String</rd:TypeName>
<DataField>office_name</DataField>
</Field>
<Field Name="office_id">
<rd:TypeName>System.String</rd:TypeName>
<DataField>office_id</DataField>
</Field>
<Field Name="area_name">
<rd:TypeName>System.String</rd:TypeName>
<DataField>area_name</DataField>
</Field>
<Field Name="area_id">
<rd:TypeName>System.String</rd:TypeName>
<DataField>area_id</DataField>
</Field>
<Field Name="product_id_name">
<rd:TypeName>System.String</rd:TypeName>
<DataField>product_id_name</DataField>
</Field>
<Field Name="product_id">
<rd:TypeName>System.String</rd:TypeName>
<DataField>product_id</DataField>
</Field>
<Field Name="segment_name">
<rd:TypeName>System.String</rd:TypeName>
<DataField>segment_name</DataField>
</Field>
<Field Name="segment_id">
<rd:TypeName>System.String</rd:TypeName>
<DataField>segment_id</DataField>
</Field>
<Field Name="service_name">
<rd:TypeName>System.String</rd:TypeName>
<DataField>service_name</DataField>
</Field>
<Field Name="service_id">
<rd:TypeName>System.String</rd:TypeName>
<DataField>service_id</DataField>
</Field>
<Field Name="bu_name">
<rd:TypeName>System.String</rd:TypeName>
<DataField>bu_name</DataField>
</Field>
<Field Name="bu_id">
<rd:TypeName>System.String</rd:TypeName>
<DataField>bu_id</DataField>
</Field>
<Field Name="process_name">
<rd:TypeName>System.String</rd:TypeName>
<DataField>process_name</DataField>
</Field>
<Field Name="process_id">
<rd:TypeName>System.String</rd:TypeName>
<DataField>process_id</DataField>
</Field>
<Field Name="job_type">
<rd:TypeName>System.String</rd:TypeName>
<DataField>job_type</DataField>
</Field>
</Fields>
</DataSet>
</DataSets>
<Author>Cll (Consultant)</Author>
<Code>public function IsDup(byval currentUsername as string, byref previousUsername as object) as string
dim result as string = "False"
if (currentUsername = previousUsername.Value)
result = "True"
else
previousUsername.Value = currentUsername
end if
IsDup = result
end function</Code>
<Width>10in</Width>
<InteractiveHeight>11in</InteractiveHeight>
<Description>This report returns a list of learners who have registration statuses of Open-Normal or Open-Confirmed for the title(s) and date range(s) specified. It provides the learner’s username, name and office. This report is used to crosscheck learners enrolled in Knetch and learners with a hotel reservation for the particular class or classes.</Description>
<Language>en-US</Language>
<PageFooter>
<ReportItems>
<Textbox Name="textbox16">
<Top>0.03125in</Top>
<rd:DefaultName>textbox16</rd:DefaultName>
<ZIndex>2</ZIndex>
<Width>1.25in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontSize>6pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.1875in</Height>
<Value>="Page " & Globals!PageNumber & " of " & Globals!TotalPages</Value>
</Textbox>
<Textbox Name="textbox18">
<Left>1.375in</Left>
<Top>0.03125in</Top>
<ZIndex>1</ZIndex>
<Width>6.9375in</Width>
<Style>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontSize>6pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.1875in</Height>
<Value>="? " & DateTime.Now.Year &</Value>
</Textbox>
<Textbox Name="textbox19">
<Left>8.375in</Left>
<Top>0.03125in</Top>
<Width>1.5625in</Width>
<Style>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontSize>6pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.1875in</Height>
<Value>="Run Date/Time: " & DateTime.Now</Value>
</Textbox>
</ReportItems>
<Height>0.25in</Height>
<PrintOnLastPage>true</PrintOnLastPage>
<PrintOnFirstPage>true</PrintOnFirstPage>
</PageFooter>
<TopMargin>0.5in</TopMargin>
<PageHeight>8.5in</PageHeight>
</Report>
No comments:
Post a Comment