I have a list control in my report body.I want to set my visibility based on expression.I am doing this fine now but my problem is that my grouping is ignored.Before i am grouping my list based on my emp. name with page breaks after the list.But now it seems to ignore the page break and only come out in out page.What could be the work around for this?THanks guys!!
View 3 RepliesHello,
I have a group I'll call G4.
The header table row for G4 contains 3 textboxes containing the sums of the contents within G4. The header table row for G4 is visible while it's contents, including the G4 footer table row, is kept invisible until the report user drills down into the group.
When the report user drills down into G4 the footer table row becomes visible and the sums of the contents of the group are displayed for a second time.
At this point I want the sums in the header to be set to invisible when the sums in the footer are made visible by the drilldown.
When I try to reference the hidden property of textbox66 in the G4 footer in order to set the hidden property of header textbox57 in the G4 header I get to this point...
=IIF(reportitems!textbox66.
When it fails to give me an option of choosing the .Hidden property and instead only gives me a .Value.
If I complete the IIF statement manually so that it spells out .....
=IIF(ReportItems!Textbox66.Hidden = False, True, False)
...the report chokes on it.
So my question is, how do I reference the hidden property of one or more textboxes in a group to use as condition checks to set the hidden property of another textbox in that same group?
Thank you for any help you can provide. We are only now beginning to implement reporting services and I have not yet had the chance to research this in greater detail for lack of time.
I have a requirement to create a Report Builder Model programmatically and include only a subset of the Entities (Tables) in the Database referenced by the Data Source. What I have to do is create pre-filtered 'datasets' with application security (Role, User) already applied.
When I build a Model via GenerateModel() I get every table. This is because, unlike using Model Designer, I do not get to pick and choose which tables are to be included in the Data Source View.
Note: I cannot apply any security to the Model itself. This is as painful as applying security (table, column, row) directly to the database.
The answer is to set the Hidden 'property' at the Entity Level. I was hoping to use GetProperties() and SetProperties() but this is limited to Catalog Items? I know I can do this by 'editing' the SMDL(XML) and inserting
<Hidden>true</Hidden>
for the Entities I don't want to see but there *has* to be a better way.
I have a matrix table with a rectangle in the data cell. The rectangle has an image and textbox. The textbox has an expression in it's Hidden property based on the column name. The report renders fine on screen. When the report is exported to Excel, CSV, XML the textbox contents are not output (the images display as expected). I've tried setting the DataElementOutput to Output/Yes with no success. Exporting to TIFF, PDF, Web Archive/MTHML is fine.
Here is a sample RDL which exhibits the issue:
<?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="Gemini50DataSource">
<DataSourceReference>Gemini50DataSource</DataSourceReference>
<rdataSourceID>bb03313c-48a4-4e40-af99-ed584847ca20</rdataSourceID>
</DataSource>
</DataSources>
<BottomMargin>1in</BottomMargin>
<RightMargin>1in</RightMargin>
<ReportParameters>
<ReportParameter Name="ImagePath">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>c:</Value>
</Values>
</DefaultValue>
<Prompt>Image Path</Prompt>
</ReportParameter>
</ReportParameters>
<rdrawGrid>true</rdrawGrid>
<InteractiveWidth>8.5in</InteractiveWidth>
<rdnapToGrid>true</rdnapToGrid>
<Body>
<ReportItems>
<Matrix Name="matrix1">
<MatrixColumns>
<MatrixColumn>
<Width>3.75in</Width>
</MatrixColumn>
</MatrixColumns>
<RowGroupings>
<RowGrouping>
<Width>1.75in</Width>
<DynamicRows>
<ReportItems>
<Textbox Name="PicIndex">
<rdefaultName>PicIndex</rdefaultName>
<ZIndex>1</ZIndex>
<Style>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!PicIndex.Value</Value>
</Textbox>
</ReportItems>
<Grouping Name="matrix1_PicIndex">
<GroupExpressions>
<GroupExpression>=Fields!PicIndex.Value</GroupExpression>
</GroupExpressions>
</Grouping>
</DynamicRows>
</RowGrouping>
</RowGroupings>
<ColumnGroupings>
<ColumnGrouping>
<DynamicColumns>
<ReportItems>
<Textbox Name="ColumnName">
<rdefaultName>ColumnName</rdefaultName>
<ZIndex>2</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<BackgroundColor>LightBlue</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!ColumnName.Value</Value>
</Textbox>
</ReportItems>
<Grouping Name="matrix1_ColumnName">
<GroupExpressions>
<GroupExpression>=Fields!ColumnName.Value</GroupExpression>
</GroupExpressions>
</Grouping>
</DynamicColumns>
<Height>0.25in</Height>
</ColumnGrouping>
</ColumnGroupings>
<DataSetName>DataSet2</DataSetName>
<Width>5.5in</Width>
<Corner>
<ReportItems>
<Textbox Name="textbox1">
<rdefaultName>textbox1</rdefaultName>
<ZIndex>3</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</Corner>
<Height>0.55208in</Height>
<MatrixRows>
<MatrixRow>
<Height>0.30208in</Height>
<MatrixCells>
<MatrixCell>
<ReportItems>
<Rectangle Name="rectangle1">
<ReportItems>
<Image Name="image1">
<Sizing>AutoSize</Sizing>
<Left>0.25in</Left>
<MIMEType />
<ZIndex>1</ZIndex>
<Visibility>
<Hidden>=IIF(First(Fields!ColumnName.Value = "image"), Len(Fields!CellValue.Value)=0, true)</Hidden>
</Visibility>
<Width>0.3in</Width>
<Source>External</Source>
<Style />
<Value>="file:" + Parameters!ImagePath.Value + Fields!CellValue.Value</Value>
</Image>
<Textbox Name="textbox2">
<Left>1.625in</Left>
<DataElementOutput>Output</DataElementOutput>
<rdefaultName>textbox2</rdefaultName>
<Visibility>
<Hidden>=IIF(Fields!ColumnName.Value <> "image", False, True)</Hidden>
</Visibility>
<Width>1.875in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<BackgroundColor>PeachPuff</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>=Fields!CellValue.Value</Value>
</Textbox>
</ReportItems>
<Visibility>
<Hidden>=IIF(True, False, True)</Hidden>
</Visibility>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<BackgroundColor>LightGrey</BackgroundColor>
</Style>
</Rectangle>
</ReportItems>
</MatrixCell>
</MatrixCells>
</MatrixRow>
</MatrixRows>
</Matrix>
</ReportItems>
<Height>0.625in</Height>
</Body>
<rd:ReportID>a944d20c-558a-4805-9d4c-aecc9757f678</rd:ReportID>
<LeftMargin>1in</LeftMargin>
<DataSets>
<DataSet Name="DataSet2">
<Query>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
<CommandText>SELECT 1 as PicIndex, 'image' as ColumnName, 'image1.jpg' as CellValue
union
SELECT 2,'image','image2.jpg'
union
SELECT 3,'image','image3.jpg'
union
SELECT 4,'image',null
union
SELECT 5,'something else',null
union
SELECT 6,'another column', 'display my text!'</CommandText>
<DataSourceName>Gemini50DataSource</DataSourceName>
</Query>
<Fields>
<Field Name="PicIndex">
<rd:TypeName>System.Int32</rd:TypeName>
<DataField>PicIndex</DataField>
</Field>
<Field Name="ColumnName">
<rd:TypeName>System.String</rd:TypeName>
<DataField>ColumnName</DataField>
</Field>
<Field Name="CellValue">
<rd:TypeName>System.String</rd:TypeName>
<DataField>CellValue</DataField>
</Field>
</Fields>
</DataSet>
</DataSets>
<Width>5.625in</Width>
<InteractiveHeight>11in</InteractiveHeight>
<Language>en-US</Language>
<TopMargin>1in</TopMargin>
</Report>
Given a model in Power Pivot with a number of KPIs that are hidden with the 'hide from client tools' option. After restoring the model in SSAS and connecting to the model from Excel, the KPIs are visible under a separate category/table "KPIs".
Other hidden items in the model like columns and measures remain invisible.
Is this normal behavior and what can I do about this?
I am creating of may of dataflow component.
How make a property with list of predefined values?
Thanks in advance.
I am having problems exporting data into a flat file using specific code page. My application has a variable "User::CodePage" that stores code page value (936, 950, 1252, etc) based on the data source. This variable is assigned to the CodePage property of desitnation file connection using Property expression.
But, when I execute the package, the CodePage property of the Destination file connection defaults to the initial value that was set for "User:CodePage" variable in design mode. I checked the value within the variable during runtime and it changes correctly for each data source. But, the property of the destinatin file connection doesn't change and results in an error.
[Flat File Destination [473]] Error: Data conversion failed. The data conversion for column "Column01" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
[DTS.Pipeline] Error: The ProcessInput method on component "Flat File Destination" (473) failed with error code 0xC02020A0. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.
If I manually update the variable with correct code page and re-run the ETL, everything works fine. Just that it doesn't work during run-time mode.
Can someone please help me resolve this.
Thanks much.
Hi,
I developed a simple custom control flow component which has several read/write properties and one readonly property (lets call it ROP) whichs Get method simple returns the value of a private variable (VAR as string). In the Execute method the VAR has a value assigened. When I put the value of ROP or VAR into MsgBox I can see the correct value. However when I execute the component I can not see the value of the ROP in the property window. I see the property but its value is empty string. For example when I put a breakpoint to postexecute or check the property before click OK in a MsgBox I would expect that the property value would be updated in SSIS as well. Is there a way how to display correct values of custom tasks properties in property window?
Thanks for any hints.
Untill recently I had a smooth running SSIS package,but suddenly it throws error syaing
"OnError,,,,,,,The result of the expression
"@[User:trTextFileImpDirectory] +"SomeTextStringHere"+ @[User:trANTTextFileName] +(DT_STR,30,1252) @[User:taging_Date_Key]+ "SomeTextStringHere"
" on property "ConnectionString" cannot be written to the property. The expression was evaluated, but cannot be set on the property."
I have child SSIS package running under a parent package (through execute package task)
I have few flat file connection managers in child package for text file import , in which I am building text file path dynamically at run time by assigning an expression in connection string property of connection manager.
The Expression is as follows
"@[User:trTextFileImpDirectory] +"SomeTextStringHere."+ @[User:trANTTextFileName] +(DT_STR,30,1252) @[User:taging_Date_Key]+ +"SomeTextStringHere"
Where @[User:trTextFileImpDirectory] is a variable which contains path of directory containg text
files.Value in this variable is assigned at runtime from parent package's variable,which in turns fetch
value from a configuration file on local server.
With my current configuration this path has been configured to some other server's directory over network ( I.e my package picks text files from some other servers folder over network)
While
"Some string here"+ @[User:trANTTextFileName]" part of file name string.
(DT_STR,30,1252) @[User:taging_Date_Key] Contain the date of processing ,value in this variable is also picked up at run time from parent package variable.
1) So can someone give me some insight into possible reason of failures.
2) Is it possible that problem arises if directory (from which I m picking text files) is assigned password or is there exist some problem in accessing forlders over network ?
3) Or there can be some problem in package configuration at design time( I.e where I m assigning value in variable from parent package vriables)?
How do I hide a field on a table?
View 1 Replies View Related
Can someone please give a query for getting the list of all hidden reports from "Report Server Database" tables?
I do not have access to this database, thus not able to explore the tables myself.
Many Thanks
Is there any way to have a parameter hidden for a report without it being Read-Only? I want the user to be able to select a specific parameter within a report and have another parameter passed via URL.
View 3 Replies View RelatedShould stored produres that are "hidden" from us users be used?
I'm thinking in particular of using sp_MSgetversion to get the SQL Server version number and to be able to run different script if i'm on SQL Server 7.
Why are they not documented in the first place? Is it because they might change and they don't want us to use them?
Hi all,
My report has a number of tables.
These table design is as [Total(numeric),Year(numeric),Month(varchar(15)].
Each table on report is populated based on individual tables in Mngt Studio.
My problem is.If table is empty,the table on report does not get populated/displayed.It is hidden.How do I return a message,Example {"No Value for table A"} instead and show the table in report only when the table has some value.
I have written an expression like this.But it just hides the table if its empty,and im not able to return a value "No Value"instead.
=IIF(Fields!Month.Value IS Nothing,"No Value for table A",False)
I have a package with an Execute Process task that is running csvde. I need the window style to be "hidden" in order to be able to run the package as a job. However, selecting the "hidden" option is not causing the window to not be displayed. Am I missing something?
Thanks,
Ron Rice
In my report I have a dataset that is returning an ID field among other things. I am setting a hidden parameter = to that ID field. That parameter is then used to return another dataset.
My problem is that the original dataset with the ID field does not always bring back data (this is expected). If data is not brought back, I get an error when I try to execute the report ("The 'X' parameter is missing a value").
I have the parameter set to "Allow Null Values".
This value is not required in the SQL Server stored procedure that returns values for the new dataset.
The parameter is of type Integer. (So I am not able to set the "Allow Blank Value" property)
This is NOT a multi-value parameter.
Does anyone have any suggestions/ideas/workarounds to solve my problem?
Hi,
I have conditionially visible groups that are show/hide based on a report parameter. The problem is that I also want to have a document label on this group. When the group is hidden a blank entry appears in the doument map rather that no entry at all. Is this a bug or is there some work around. Thanks.
I have a report that has a List1 that is the main group then a sublist2 the exact same size in it that list1 which groups by Ceiling so I can limit the amount of rows on a page.
I want to figure out the amount of pages ABS(Total rows in my group / the # I set in ceiling per page)
THe issue is if I put anything in my list1 Like a textbox to run code to store the row count, it throws off the output (Add's additional blank pages to the report0. I tried inserting this code function in other areas as well with no success.
Is there any way to add a hidden value to my List1 that will not offset the output of list 2?
Thanks Here's my report
[code]
Code Snippet
<?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="SPProduction">
<DataSourceReference>SPProduction</DataSourceReference>
<rd:DataSourceID>1cde06a1-b276-4548-85bc-8a6a541faa3d</rd:DataSourceID>
</DataSource>
</DataSources>
<BottomMargin>0.1in</BottomMargin>
<RightMargin>0.2in</RightMargin>
<ReportParameters>
<ReportParameter Name="InvoiceID">
<DataType>String</DataType>
<Nullable>true</Nullable>
<Prompt>InvoiceID</Prompt>
</ReportParameter>
<ReportParameter Name="BatchID">
<DataType>Integer</DataType>
<Nullable>true</Nullable>
<Prompt>BatchID</Prompt>
</ReportParameter>
</ReportParameters>
<rd:DrawGrid>true</rd:DrawGrid>
<InteractiveWidth>8.5in</InteractiveWidth>
<rd:SnapToGrid>false</rd:SnapToGrid>
<Body>
<ReportItems>
<List Name="Body_MainGroup">
<Left>0.19792in</Left>
<ReportItems>
<Rectangle Name="rectangle8">
<Left>0.20833in</Left>
<ReportItems>
<Textbox Name="textbox86">
<Left>5.67708in</Left>
<Top>0.37708in</Top>
<ZIndex>12</ZIndex>
<Width>1.54167in</Width>
<Style>
<TextAlign>Left</TextAlign>
<FontSize>9pt</FontSize>
</Style>
<Value>=First(Fields!EmployerName.Value)</Value>
</Textbox>
<Textbox Name="textbox87">
<Left>5.67708in</Left>
<Top>0.04167in</Top>
<ZIndex>11</ZIndex>
<Width>1.54167in</Width>
<Style>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>DarkSlateBlue</Color>
</Style>
<Height>0.1875in</Height>
<Value>Employer Name</Value>
</Textbox>
<Line Name="line30">
<Top>0.305in</Top>
<ZIndex>10</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Textbox Name="textbox88">
<Left>3.53125in</Left>
<Top>0.375in</Top>
<ZIndex>9</ZIndex>
<Width>1.125in</Width>
<Style>
<TextAlign>Left</TextAlign>
<FontSize>9pt</FontSize>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>=First(Fields!EmployerID.value)</Value>
</Textbox>
<Textbox Name="textbox89">
<Left>4.66667in</Left>
<Top>0.375in</Top>
<ZIndex>8</ZIndex>
<Width>1in</Width>
<Style>
<TextAlign>Left</TextAlign>
<FontSize>9pt</FontSize>
</Style>
<Height>0.25in</Height>
<Value>=Fields!EmployerCode.Value</Value>
</Textbox>
<Textbox Name="textbox90">
<Left>3.53125in</Left>
<Top>0.05in</Top>
<ZIndex>7</ZIndex>
<Width>1.125in</Width>
<Style>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>DarkSlateBlue</Color>
</Style>
<Height>0.1875in</Height>
<Value>Employer ID</Value>
</Textbox>
<Textbox Name="textbox91">
<Left>1.01042in</Left>
<Top>0.375in</Top>
<ZIndex>6</ZIndex>
<Width>0.875in</Width>
<Style>
<TextAlign>Left</TextAlign>
<FontSize>9pt</FontSize>
<Format>d</Format>
</Style>
<Height>0.25in</Height>
<Value>=First(Fields!DueDate.value)</Value>
</Textbox>
<Textbox Name="textbox92">
<Left>0.125in</Left>
<Top>0.05in</Top>
<ZIndex>5</ZIndex>
<Width>0.875in</Width>
<Style>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>DarkSlateBlue</Color>
</Style>
<Height>0.1875in</Height>
<Value>Printed Date</Value>
</Textbox>
<Textbox Name="textbox93">
<Left>0.125in</Left>
<Top>0.375in</Top>
<ZIndex>4</ZIndex>
<Width>0.875in</Width>
<Style>
<TextAlign>Left</TextAlign>
<FontSize>9pt</FontSize>
<Format>d</Format>
</Style>
<Height>0.25in</Height>
<Value>=Now()</Value>
</Textbox>
<Textbox Name="textbox94">
<Left>4.66667in</Left>
<Top>0.05in</Top>
<ZIndex>3</ZIndex>
<Width>1in</Width>
<Style>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>DarkSlateBlue</Color>
</Style>
<Height>0.1875in</Height>
<Value>Employer Code</Value>
</Textbox>
<Textbox Name="textbox95">
<Left>1.01042in</Left>
<Top>0.05in</Top>
<ZIndex>2</ZIndex>
<Width>0.875in</Width>
<Style>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>DarkSlateBlue</Color>
</Style>
<Height>0.1875in</Height>
<Value>Due Date</Value>
</Textbox>
<Textbox Name="textbox96">
<Left>1.89583in</Left>
<Top>0.375in</Top>
<ZIndex>1</ZIndex>
<Width>1.625in</Width>
<Style>
<TextAlign>Left</TextAlign>
<FontSize>9pt</FontSize>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>=First(Fields!InvoiceStartdate.Value & " - " & Fields!InvoiceEndDate.Value)</Value>
</Textbox>
<Textbox Name="textbox97">
<Left>1.89583in</Left>
<Top>0.05in</Top>
<Width>1.625in</Width>
<Style>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>DarkSlateBlue</Color>
</Style>
<Height>0.1875in</Height>
<Value>Periods Billed</Value>
</Textbox>
</ReportItems>
<Top>8.05209in</Top>
<ZIndex>5</ZIndex>
<Width>7.25416in</Width>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<BorderWidth>
<Default>3pt</Default>
</BorderWidth>
</Style>
<Height>0.75in</Height>
</Rectangle>
<Rectangle Name="rectangle7">
<Left>2.26354in</Left>
<ReportItems>
<Textbox Name="textbox39">
<Left>0.84375in</Left>
<ZIndex>16</ZIndex>
<Width>1in</Width>
<Style>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<Color>MidnightBlue</Color>
<TextDecoration>Underline</TextDecoration>
<PaddingRight>2pt</PaddingRight>
<FontStyle>Italic</FontStyle>
</Style>
<CanGrow>true</CanGrow>
<Height>0.15625in</Height>
<Value>*Status Codes</Value>
</Textbox>
<Textbox Name="textbox40">
<Left>0.35417in</Left>
<Top>1.45833in</Top>
<ZIndex>15</ZIndex>
<Width>1.625in</Width>
<Style>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<FontSize>8pt</FontSize>
<Color>MidnightBlue</Color>
</Style>
<CanGrow>true</CanGrow>
<Value>(Include New Enrollment Cards)</Value>
</Textbox>
<Textbox Name="textbox41">
<Left>0.35417in</Left>
<Top>1.20833in</Top>
<ZIndex>14</ZIndex>
<Width>1.35417in</Width>
<Style>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Times New Roman</FontFamily>
<FontSize>8pt</FontSize>
<Color>MidnightBlue</Color>
</Style>
<CanGrow>true</CanGrow>
<Height>0.15in</Height>
<Value>(Include Enrollment Cards)</Value>
</Textbox>
<Textbox Name="textbox42">
<Left>0.10417in</Left>
<Top>1.33333in</Top>
<ZIndex>13</ZIndex>
<Width>1.375in</Width>
<Style>
<TextAlign>Left</TextAlign>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>MidnightBlue</Color>
</Style>
<CanGrow>true</CanGrow>
<Height>0.15in</Height>
<Value>R = Reinstated</Value>
</Textbox>
<Textbox Name="textbox56">
<Left>0.10417in</Left>
<Top>1.08333in</Top>
<ZIndex>12</ZIndex>
<Width>1.375in</Width>
<Style>
<TextAlign>Left</TextAlign>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>MidnightBlue</Color>
</Style>
<CanGrow>true</CanGrow>
<Height>0.15in</Height>
<Value>N = New Employee</Value>
</Textbox>
<Textbox Name="textbox74">
<Left>0.10417in</Left>
<Top>0.83333in</Top>
<ZIndex>11</ZIndex>
<Width>1.375in</Width>
<Style>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<TextDecoration>Underline</TextDecoration>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>Additions</Value>
</Textbox>
<Textbox Name="textbox75">
<Left>0.10417in</Left>
<Top>0.70833in</Top>
<ZIndex>10</ZIndex>
<Width>1.27083in</Width>
<Style>
<TextAlign>Left</TextAlign>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>MidnightBlue</Color>
</Style>
<CanGrow>true</CanGrow>
<Height>0.15in</Height>
<Value>SL = Sick Leave</Value>
</Textbox>
<Textbox Name="textbox76">
<Left>0.10417in</Left>
<Top>0.58333in</Top>
<ZIndex>9</ZIndex>
<Width>1.38542in</Width>
<Style>
<TextAlign>Left</TextAlign>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>MidnightBlue</Color>
</Style>
<CanGrow>true</CanGrow>
<Height>0.15in</Height>
<Value>LO = Layoff</Value>
</Textbox>
<Textbox Name="textbox77">
<Left>0.10417in</Left>
<Top>0.43333in</Top>
<ZIndex>8</ZIndex>
<Width>1.42708in</Width>
<Style>
<TextAlign>Left</TextAlign>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>MidnightBlue</Color>
</Style>
<CanGrow>true</CanGrow>
<Height>0.15in</Height>
<Value>LA = Leave of Absensce</Value>
</Textbox>
<Textbox Name="textbox78">
<Left>1.71875in</Left>
<Top>1.08333in</Top>
<ZIndex>7</ZIndex>
<Style>
<TextAlign>Left</TextAlign>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>MidnightBlue</Color>
</Style>
<CanGrow>true</CanGrow>
<Height>0.15in</Height>
<Value>TM = Transfer/Management</Value>
</Textbox>
<Textbox Name="textbox79">
<Left>1.71875in</Left>
<Top>0.95833in</Top>
<ZIndex>6</ZIndex>
<Width>1.375in</Width>
<Style>
<TextAlign>Left</TextAlign>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>MidnightBlue</Color>
</Style>
<CanGrow>true</CanGrow>
<Height>0.15in</Height>
<Value>TS = Seniority Loss</Value>
</Textbox>
<Textbox Name="textbox80">
<Left>1.71875in</Left>
<Top>0.83333in</Top>
<ZIndex>5</ZIndex>
<Width>1.375in</Width>
<Style>
<TextAlign>Left</TextAlign>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>MidnightBlue</Color>
</Style>
<CanGrow>true</CanGrow>
<Height>0.15in</Height>
<Value>TR = Retired</Value>
</Textbox>
<Textbox Name="textbox81">
<Left>1.71875in</Left>
<Top>0.70833in</Top>
<ZIndex>4</ZIndex>
<Width>1.375in</Width>
<Style>
<TextAlign>Left</TextAlign>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>MidnightBlue</Color>
</Style>
<CanGrow>true</CanGrow>
<Height>0.15in</Height>
<Value>TQ = Quit</Value>
</Textbox>
<Textbox Name="textbox82">
<Left>1.71875in</Left>
<Top>0.58333in</Top>
<ZIndex>3</ZIndex>
<Width>1.375in</Width>
<Style>
<TextAlign>Left</TextAlign>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>MidnightBlue</Color>
</Style>
<CanGrow>true</CanGrow>
<Height>0.15in</Height>
<Value>TF = Fired</Value>
</Textbox>
<Textbox Name="textbox83">
<Left>1.71875in</Left>
<Top>0.43333in</Top>
<ZIndex>2</ZIndex>
<Width>1.375in</Width>
<Style>
<TextAlign>Left</TextAlign>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>MidnightBlue</Color>
</Style>
<CanGrow>true</CanGrow>
<Height>0.15in</Height>
<Value>TD = Deceased</Value>
</Textbox>
<Textbox Name="textbox84">
<Left>0.10417in</Left>
<Top>0.18333in</Top>
<ZIndex>1</ZIndex>
<Width>1.375in</Width>
<Style>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<TextDecoration>Underline</TextDecoration>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>Off-Temporarily</Value>
</Textbox>
<Textbox Name="textbox85">
<Left>1.96875in</Left>
<Top>0.18333in</Top>
<Width>1.125in</Width>
<Style>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<TextDecoration>Underline</TextDecoration>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>Termination</Value>
</Textbox>
</ReportItems>
<Top>8.86251in</Top>
<ZIndex>4</ZIndex>
<Width>3.35833in</Width>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>1.60833in</Height>
</Rectangle>
<Rectangle Name="rectangle5">
<Left>0.20833in</Left>
<ReportItems>
<Textbox Name="textbox37">
<Left>5.19792in</Left>
<Top>0.08854in</Top>
<ZIndex>31</ZIndex>
<Width>2.04167in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>Status Code * (PLEASE DATE)</Value>
</Textbox>
<Textbox Name="textbox34">
<Left>3.65104in</Left>
<Top>0.08854in</Top>
<ZIndex>30</ZIndex>
<Width>1.46875in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>Date of Birth</Value>
</Textbox>
<Textbox Name="textbox31">
<Left>2.64583in</Left>
<Top>0.07813in</Top>
<ZIndex>29</ZIndex>
<Width>0.91667in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>Hire Date</Value>
</Textbox>
<Textbox Name="textbox29">
<Left>1.40104in</Left>
<Top>0.08854in</Top>
<ZIndex>28</ZIndex>
<Width>1.13542in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>Member L Name</Value>
</Textbox>
<Textbox Name="textbox28">
<Left>0.07292in</Left>
<Top>0.08333in</Top>
<rd:DefaultName>textbox28</rd:DefaultName>
<ZIndex>27</ZIndex>
<Width>1.22917in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>Member F Name</Value>
</Textbox>
<Line Name="line29">
<Left>5.18229in</Left>
<ZIndex>26</ZIndex>
<Width>0in</Width>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>3in</Height>
</Line>
<Textbox Name="textbox24">
<Left>2.11458in</Left>
<Top>3.10417in</Top>
<rd:DefaultName>textbox24</rd:DefaultName>
<ZIndex>25</ZIndex>
<Width>3.28125in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>700</FontWeight>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>NEW UNION MEMBER INFORMATION</Value>
</Textbox>
<Line Name="line28">
<Left>3.625in</Left>
<ZIndex>24</ZIndex>
<Width>0in</Width>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>3in</Height>
</Line>
<Line Name="line27">
<Left>2.625in</Left>
<ZIndex>23</ZIndex>
<Width>0in</Width>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>3.02083in</Height>
</Line>
<Line Name="line25">
<Left>1.375in</Left>
<ZIndex>22</ZIndex>
<Width>0in</Width>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>2.98958in</Height>
</Line>
<Line Name="line24">
<Top>3.00521in</Top>
<ZIndex>21</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Line Name="line26">
<Top>2.88021in</Top>
<ZIndex>20</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Line Name="line19">
<Top>2.75521in</Top>
<ZIndex>19</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Line Name="line20">
<Top>2.38021in</Top>
<ZIndex>18</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Line Name="line21">
<Top>2.63021in</Top>
<ZIndex>17</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Line Name="line22">
<Top>2.50521in</Top>
<ZIndex>16</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Line Name="line23">
<Top>2.25521in</Top>
<ZIndex>15</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Line Name="line14">
<Top>2.13021in</Top>
<ZIndex>14</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Line Name="line15">
<Top>1.75521in</Top>
<ZIndex>13</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Line Name="line16">
<Top>2.00521in</Top>
<ZIndex>12</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Line Name="line17">
<Top>1.88021in</Top>
<ZIndex>11</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Line Name="line18">
<Top>1.63021in</Top>
<ZIndex>10</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Line Name="line9">
<Top>1.50521in</Top>
<ZIndex>9</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Line Name="line10">
<Top>1.13021in</Top>
<ZIndex>8</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Line Name="line11">
<Top>1.38021in</Top>
<ZIndex>7</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Line Name="line12">
<Top>1.25521in</Top>
<ZIndex>6</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Line Name="line13">
<Top>1.00521in</Top>
<ZIndex>5</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Line Name="line8">
<Top>0.875in</Top>
<ZIndex>4</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Line Name="line7">
<Top>0.5in</Top>
<ZIndex>3</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Line Name="line6">
<Top>0.75in</Top>
<ZIndex>2</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Line Name="line5">
<Top>0.625in</Top>
<ZIndex>1</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Line Name="line4">
<Top>0.375in</Top>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
</ReportItems>
<Top>10.52084in</Top>
<ZIndex>3</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>3.44792in</Height>
</Rectangle>
<Rectangle Name="rectangle4">
<Left>0.25in</Left>
<ReportItems>
<Textbox Name="textbox30">
<Left>0.01563in</Left>
<ZIndex>1</ZIndex>
<Width>3.66667in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>="Generated time : " & now()</Value>
</Textbox>
<Textbox Name="textbox20">
<Left>4.76563in</Left>
<Width>2.44791in</Width>
<Style>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>="Page " & code.getCurrentPageNumber(Fields!InvoiceGroup.Value) & " of " & code.getCurrentPageNumber(Fields!InvoiceGroup.Value)</Value>
</Textbox>
</ReportItems>
<Top>7.67708in</Top>
<ZIndex>2</ZIndex>
<Width>7.22917in</Width>
<PageBreakAtEnd>true</PageBreakAtEnd>
<Height>0.27083in</Height>
</Rectangle>
<List Name="List_InvoiceGroup">
<ReportItems>
<Textbox Name="InvoiceGroup">
<Left>3.21875in</Left>
<rd:DefaultName>InvoiceGroup</rd:DefaultName>
<ZIndex>17</ZIndex>
<Width>1.08333in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>700</FontWeight>
<FontSize>8pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>="Page " & code.getPageNumber(Fields!InvoiceGroup.Value) </Value>
</Textbox>
<Textbox Name="textbox15">
<Left>4.22916in</Left>
<Top>5.28125in</Top>
<ZIndex>16</ZIndex>
<Style>
<BorderStyle>
<Default>Double</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<VerticalAlign>Bottom</VerticalAlign>
<BackgroundColor>Gainsboro</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>=code.ResetOffset() & "PAGE TOTAL"</Value>
</Textbox>
<Table Name="table2">
<Footer>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox16">
<ZIndex>2</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox17">
<ZIndex>1</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox18">
<Style>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>700</FontWeight>
<FontSize>8pt</FontSize>
<Format>C</Format>
<PaddingRight>2pt</PaddingRight>
<FontStyle>Italic</FontStyle>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!Rate.Value)</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.20888in</Height>
</TableRow>
</TableRows>
</Footer>
<Left>4.22916in</Left>
<Top>5.53125in</Top>
<TableGroups>
<TableGroup>
<Header>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox23">
<ZIndex>5</ZIndex>
<Style>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontSize>8pt</FontSize>
<BackgroundColor>=iif((code.GetCurrentGroupNumber + 1) mod 2, "#e8e8c9", "White")</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=code.GetGroupNumber() </Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox26">
<ZIndex>4</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontSize>8pt</FontSize>
<BackgroundColor>=iif(code.GetCurrentGroupNumber mod 2, "#e8e8c9", "White")</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=First(Fields!BenefitTypeName.Value)</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox32">
<ZIndex>3</ZIndex>
<Style>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontSize>8pt</FontSize>
<Format>C</Format>
<BackgroundColor>=iif(code.GetCurrentGroupNumber mod 2, "#e8e8c9", "White")</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!Rate.Value)</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.2in</Height>
</TableRow>
</TableRows>
</Header>
<Grouping Name="table2_Group1">
<GroupExpressions>
<GroupExpression>=Fields!BenefitTypeID.Value</GroupExpression>
<GroupExpression>=Fields!AccountID.Value</GroupExpression>
</GroupExpressions>
</Grouping>
</TableGroup>
</TableGroups>
<ZIndex>15</ZIndex>
<Style>
<BorderStyle>
<Default>Double</Default>
</BorderStyle>
<FontSize>8pt</FontSize>
</Style>
<Header>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox35">
<ZIndex>8</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>700</FontWeight>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<BackgroundColor>Gainsboro</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Row No</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox36">
<ZIndex>7</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>700</FontWeight>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<BackgroundColor>Gainsboro</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>BenefitType Description</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox38">
<ZIndex>6</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>700</FontWeight>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<BackgroundColor>Gainsboro</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Page Total Amount</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.25in</Height>
</TableRow>
</TableRows>
</Header>
<TableColumns>
<TableColumn>
<Width>0.625in</Width>
</TableColumn>
<TableColumn>
<Width>1.90625in</Width>
</TableColumn>
<TableColumn>
<Width>0.71875in</Width>
</TableColumn>
</TableColumns>
</Table>
<Rectangle Name="rectangle2">
<Left>0.20833in</Left>
<ReportItems>
<Table Name="table1">
<Top>0.125in</Top>
<Details>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox6">
<rd:DefaultName>textbox6</rd:DefaultName>
<ZIndex>7</ZIndex>
<Style>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontSize>7pt</FontSize>
<BackgroundColor>=iif(RowNumber(Nothing) mod 2, "#e8e8c9", "White")</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Code.GetRowNumber(Fields!InvoiceGroup.Value, Fields!EmployeeID.Value)</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="EmployeeID_1">
<rd:DefaultName>EmployeeID_1</rd:DefaultName>
<ZIndex>6</ZIndex>
<Style>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontSize>7pt</FontSize>
<BackgroundColor>=iif(RowNumber(Nothing) mod 2, "#e8e8c9", "White")</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!EmployeeID.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="EmployeeFName">
<rd:DefaultName>EmployeeFName</rd:DefaultName>
<ZIndex>5</ZIndex>
<Style>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontSize>7pt</FontSize>
<BackgroundColor>=iif(RowNumber(Nothing) mod 2, "#e8e8c9", "White")</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=iif(fields!InvoiceGroup.value = fields!InvoiceID.value, Fields!EmployeeLName.value & ", " & Fields!EmployeeFName.value & " " & Fields!EmployeeMI.value,"Owed Invoice: " & fields!InvoiceID.value)</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="BenefitTypeName">
<rd:DefaultName>BenefitTypeName</rd:DefaultName>
<ZIndex>4</ZIndex>
<Style>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontSize>7pt</FontSize>
<BackgroundColor>=iif(RowNumber(Nothing) mod 2, "#e8e8c9", "White")</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=iif(fields!InitialFee.value = 1,Fields!BenefitTypeName.Value & " " & fields!PlanTypeDesc.value & " " & Fields!CoverageTypeDesc.value & " (InitialFee)", Fields!BenefitTypeName.Value & " " & fields!PlanTypeDesc.value & " " & Fields!CoverageTypeDesc.value)</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="Rate">
<rd:DefaultName>Rate</rd:DefaultName>
<ZIndex>3</ZIndex>
<Style>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontSize>7pt</FontSize>
<BackgroundColor>=iif(RowNumber(Nothing) mod 2, "#e8e8c9", "White")</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=FormatCurrency(Fields!Rate.Value,2)</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="PeriodToBill">
<rd:DefaultName>PeriodToBill</rd:DefaultName>
<ZIndex>2</ZIndex>
<Style>
<BorderStyle>
<Right>Solid</Right>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<BorderWidth>
<Right>1pt</Right>
</BorderWidth>
<PaddingBottom>2pt</PaddingBottom>
<FontSize>7pt</FontSize>
<BorderColor>
<Right>Black</Right>
</BorderColor>
<BackgroundColor>=iif(RowNumber(Nothing) mod 2, "#e8e8c9", "White")</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Month(Fields!PeriodToBill.Value) & "/" & day(Fields!PeriodToBill.Value) & "/" & year(Fields!PeriodToBill.Value)</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox19">
<rd:DefaultName>textbox19</rd:DefaultName>
<ZIndex>1</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>700</FontWeight>
<FontSize>7pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=code.FirstEmployee(Fields!EmployeeID.Value)</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox98">
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>700</FontWeight>
<FontSize>7pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=code.FirstEmployee(Fields!EmployeeID.Value)</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.15625in</Height>
</TableRow>
</TableRows>
<Sorting>
<SortBy>
<SortExpression>=Fields!EmployeeLName.Value</SortExpression>
<Direction>Ascending</Direction>
</SortBy>
<SortBy>
<SortExpression>=Fields!BenefitTypeName.Value</SortExpression>
<Direction>Ascending</Direction>
</SortBy>
<SortBy>
<SortExpression>=Fields!PeriodToBill.Value</SortExpression>
<Direction>Ascending</Direction>
</SortBy>
<SortBy>
<SortExpression>=Fields!InitialFee.Value</SortExpression>
<Direction>Ascending</Direction>
</SortBy>
</Sorting>
</Details>
<Header>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox9">
<rd:DefaultName>textbox9</rd:DefaultName>
<ZIndex>15</ZIndex>
<Style>
<BorderStyle>
<Default>Double</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<BorderWidth>
<Default>1.5pt</Default>
</BorderWidth>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>White</Default>
</BorderColor>
<BackgroundColor>LightGrey</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Row ID</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox10">
<rd:DefaultName>textbox10</rd:DefaultName>
<ZIndex>14</ZIndex>
<Style>
<BorderStyle>
<Default>Double</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<BorderWidth>
<Default>1.5pt</Default>
</BorderWidth>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>White</Default>
</BorderColor>
<BackgroundColor>LightGrey</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Employee ID</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox8">
<rd:DefaultName>textbox8</rd:DefaultName>
<ZIndex>13</ZIndex>
<Style>
<BorderStyle>
<Default>Double</Default>
</BorderStyle>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<BorderWidth>
<Default>1.5pt</Default>
</BorderWidth>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>White</Default>
</BorderColor>
<BackgroundColor>LightGrey</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Employee Name</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox7">
<rd:DefaultName>textbox7</rd:DefaultName>
<ZIndex>12</ZIndex>
<Style>
<BorderStyle>
<Default>Double</Default>
</BorderStyle>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<BorderWidth>
<Default>1.5pt</Default>
</BorderWidth>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>White</Default>
</BorderColor>
<BackgroundColor>LightGrey</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Benefit Type</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox12">
<rd:DefaultName>textbox12</rd:DefaultName>
<ZIndex>11</ZIndex>
<Style>
<BorderStyle>
<Default>Double</Default>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<BorderWidth>
<Default>1.5pt</Default>
</BorderWidth>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>White</Default>
</BorderColor>
<BackgroundColor>LightGrey</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Rate</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox22">
<rd:DefaultName>textbox22</rd:DefaultName>
<ZIndex>10</ZIndex>
<Style>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<BackgroundColor>LightGrey</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Billing Period</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox14">
<rd:DefaultName>textbox14</rd:DefaultName>
<ZIndex>9</ZIndex>
<Style>
<BorderStyle>
<Bottom>Solid</Bottom>
<Default>Double</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<BorderWidth>
<Bottom>1pt</Bottom>
<Default>1.5pt</Default>
</BorderWidth>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Bottom>Black</Bottom>
<Default>White</Default>
</BorderColor>
<BackgroundColor>LightGrey</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Severance Hours for Prior Month</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox11">
<rd:DefaultName>textbox11</rd:DefaultName>
<ZIndex>8</ZIndex>
<Style>
<BorderStyle>
<Bottom>Solid</Bottom>
<Default>Double</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<BorderWidth>
<Bottom>1pt</Bottom>
<Default>1.5pt</Default>
</BorderWidth>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Bottom>Black</Bottom>
<Default>White</Default>
</BorderColor>
<BackgroundColor>LightGrey</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Status Code * (Above) Please Date</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.32292in</Height>
</TableRow>
</TableRows>
</Header>
<TableColumns>
<TableColumn>
<Width>0.5in</Width>
</TableColumn>
<TableColumn>
<Width>0.625in</Width>
</TableColumn>
<TableColumn>
<Width>1.25in</Width>
</TableColumn>
<TableColumn>
<Width>1.88542in</Width>
</TableColumn>
<TableColumn>
<Width>0.75in</Width>
</TableColumn>
<TableColumn>
<Width>0.75in</Width>
</TableColumn>
<TableColumn>
<Width>0.75in</Width>
</TableColumn>
<TableColumn>
<Width>0.75in</Width>
</TableColumn>
</TableColumns>
<Height>0.47917in</Height>
</Table>
</ReportItems>
<Top>3.47917in</Top>
<ZIndex>14</ZIndex>
<Width>7.26042in</Width>
<Style>
<BorderStyle>
<Default>Double</Default>
</BorderStyle>
</Style>
<Height>1.75in</Height>
</Rectangle>
<Rectangle Name="rectangle1">
<Left>0.20833in</Left>
<ReportItems>
<Textbox Name="textbox21">
<Left>5.67708in</Left>
<Top>0.37708in</Top>
<ZIndex>12</ZIndex>
<Width>1.54167in</Width>
<Style>
<TextAlign>Left</TextAlign>
<FontSize>9pt</FontSize>
</Style>
<Value>=First(Fields!EmployerName.Value)</Value>
</Textbox>
<Textbox Name="textbox33">
<Left>5.67708in</Left>
<Top>0.04167in</Top>
<ZIndex>11</ZIndex>
<Width>1.54167in</Width>
<Style>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>DarkSlateBlue</Color>
</Style>
<Height>0.1875in</Height>
<Value>Employer Name</Value>
</Textbox>
<Line Name="line1">
<Top>0.305in</Top>
<ZIndex>10</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Textbox Name="textbox5">
<Left>3.53125in</Left>
<Top>0.375in</Top>
<ZIndex>9</ZIndex>
<Width>1.125in</Width>
<Style>
<TextAlign>Left</TextAlign>
<FontSize>9pt</FontSize>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>=First(Fields!EmployerID.value)</Value>
</Textbox>
<Textbox Name="textbox4">
<Left>4.66667in</Left>
<Top>0.375in</Top>
<ZIndex>8</ZIndex>
<Width>1in</Width>
<Style>
<TextAlign>Left</TextAlign>
<FontSize>9pt</FontSize>
</Style>
<Height>0.25in</Height>
<Value>=Fields!EmployerCode.Value</Value>
</Textbox>
<Textbox Name="PurchaseOrderLabel">
<Left>3.53125in</Left>
<Top>0.05in</Top>
<ZIndex>7</ZIndex>
<Width>1.125in</Width>
<Style>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>DarkSlateBlue</Color>
</Style>
<Height>0.1875in</Height>
<Value>Employer ID</Value>
</Textbox>
<Textbox Name="OrderDate">
<Left>1.01042in</Left>
<Top>0.375in</Top>
<ZIndex>6</ZIndex>
<Width>0.875in</Width>
<Style>
<TextAlign>Left</TextAlign>
<FontSize>9pt</FontSize>
<Format>d</Format>
</Style>
<Height>0.25in</Height>
<Value>=First(Fields!DueDate.value)</Value>
</Textbox>
<Textbox Name="CurrentDateLabel">
<Left>0.125in</Left>
<Top>0.05in</Top>
<ZIndex>5</ZIndex>
<Width>0.875in</Width>
<Style>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>DarkSlateBlue</Color>
</Style>
<Height>0.1875in</Height>
<Value>Printed Date</Value>
</Textbox>
<Textbox Name="CurrentDate">
<Left>0.125in</Left>
<Top>0.375in</Top>
<ZIndex>4</ZIndex>
<Width>0.875in</Width>
<Style>
<TextAlign>Left</TextAlign>
<FontSize>9pt</FontSize>
<Format>d</Format>
</Style>
<Height>0.25in</Height>
<Value>=Now()</Value>
</Textbox>
<Textbox Name="ShipMethodLabel">
<Left>4.66667in</Left>
<Top>0.05in</Top>
<ZIndex>3</ZIndex>
<Width>1in</Width>
<Style>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>DarkSlateBlue</Color>
</Style>
<Height>0.1875in</Height>
<Value>Employer Code</Value>
</Textbox>
<Textbox Name="OrderDateLabel">
<Left>1.01042in</Left>
<Top>0.05in</Top>
<ZIndex>2</ZIndex>
<Width>0.875in</Width>
<Style>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>DarkSlateBlue</Color>
</Style>
<Height>0.1875in</Height>
<Value>Due Date</Value>
</Textbox>
<Textbox Name="SalesPerson">
<Left>1.89583in</Left>
<Top>0.375in</Top>
<ZIndex>1</ZIndex>
<Width>1.625in</Width>
<Style>
<TextAlign>Left</TextAlign>
<FontSize>9pt</FontSize>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>=First(Fields!InvoiceStartdate.Value & " - " & Fields!InvoiceEndDate.Value)</Value>
</Textbox>
<Textbox Name="SalesPersonLabel">
<Left>1.89583in</Left>
<Top>0.05in</Top>
<Width>1.625in</Width>
<Style>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>DarkSlateBlue</Color>
</Style>
<Height>0.1875in</Height>
<Value>Periods Billed</Value>
</Textbox>
</ReportItems>
<Top>2.72917in</Top>
<ZIndex>13</ZIndex>
<Width>7.25416in</Width>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<BorderWidth>
<Default>3pt</Default>
</BorderWidth>
</Style>
<Height>0.75in</Height>
</Rectangle>
<Rectangle Name="rectangle3">
<Left>4.08333in</Left>
<ReportItems>
<Textbox Name="textbox73">
<Left>0.84375in</Left>
<ZIndex>16</ZIndex>
<Width>1in</Width>
<Style>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<Color>MidnightBlue</Color>
<TextDecoration>Underline</TextDecoration>
<PaddingRight>2pt</PaddingRight>
<FontStyle>Italic</FontStyle>
</Style>
<CanGrow>true</CanGrow>
<Height>0.15625in</Height>
<Value>*Status Codes</Value>
</Textbox>
<Textbox Name="textbox72">
<Left>0.35417in</Left>
<Top>1.45833in</Top>
<ZIndex>15</ZIndex>
<Width>1.625in</Width>
<Style>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<FontSize>8pt</FontSize>
<Color>MidnightBlue</Color>
</Style>
<CanGrow>true</CanGrow>
<Value>(Include New Enrollment Cards)</Value>
</Textbox>
<Textbox Name="textbox59">
<Left>0.35417in</Left>
<Top>1.20833in</Top>
<ZIndex>14</ZIndex>
<Width>1.35417in</Width>
<Style>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Times New Roman</FontFamily>
<FontSize>8pt</FontSize>
<Color>MidnightBlue</Color>
</Style>
<CanGrow>true</CanGrow>
<Height>0.15in</Height>
<Value>(Include Enrollment Cards)</Value>
</Textbox>
<Textbox Name="textbox60">
<Left>0.10417in</Left>
<Top>1.33333in</Top>
<ZIndex>13</ZIndex>
<Width>1.375in</Width>
<Style>
<TextAlign>Left</TextAlign>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>MidnightBlue</Color>
</Style>
<CanGrow>true</CanGrow>
<Height>0.15in</Height>
<Value>R = Reinstated</Value>
</Textbox>
<Textbox Name="textbox61">
<Left>0.10417in</Left>
<Top>1.08333in</Top>
<ZIndex>12</ZIndex>
<Width>1.375in</Width>
<Style>
<TextAlign>Left</TextAlign>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>MidnightBlue</Color>
</Style>
<CanGrow>true</CanGrow>
<Height>0.15in</Height>
<Value>N = New Employee</Value>
</Textbox>
<Textbox Name="textbox62">
<Left>0.10417in</Left>
<Top>0.83333in</Top>
<ZIndex>11</ZIndex>
<Width>1.375in</Width>
<Style>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<TextDecoration>Underline</TextDecoration>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>Additions</Value>
</Textbox>
<Textbox Name="textbox69">
<Left>0.10417in</Left>
<Top>0.70833in</Top>
<ZIndex>10</ZIndex>
<Width>1.27083in</Width>
<Style>
<TextAlign>Left</TextAlign>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>MidnightBlue</Color>
</Style>
<CanGrow>true</CanGrow>
<Height>0.15in</Height>
<Value>SL = Sick Leave</Value>
</Textbox>
<Textbox Name="textbox70">
<Left>0.10417in</Left>
<Top>0.58333in</Top>
<ZIndex>9</ZIndex>
<Width>1.38542in</Width>
<Style>
<TextAlign>Left</TextAlign>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>MidnightBlue</Color>
</Style>
<CanGrow>true</CanGrow>
<Height>0.15in</Height>
&l
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
show in picture . I want to do Hide Instance for MSSQL . But the menu show nothing . only have option YES and No .
View 4 Replies View RelatedI have a few SSIS (2012) packages that create 3 different unicode XML-files and FTP's them to a remote location. Two of the XML- files are flawless, the third cannot be processed as it violates XML well formed rules. When you open the flawed XML file you can't see anything out order, but invisibly it half way contains the hidden characters FF FE.
The heading <?xml version="1.0" encoding="UCS-2"?> is specified in the Flat File Destination. The XML body is generated in an OLE DB Source with a FOR XML statement.
The offending characters FF FE come right after the header <?xml version="1.0" encoding="UCS-2"?> and right before the first XML-element.
The file also contains FF FE right at its beginning, but that is the BOM (Byte Order Mark).
I investigated the first character generated by the FOR XML statement. That is '<', as it should be. So The FF FE is not generated by the FOR XML statement.
I have deleted the Flat File Destination building block and copy-and-pasted the Flat File Destination building block element from a package that generates well-formed XML files. It didn't work, the characters FF FE keep appearing a second time. So the FF FE don't come from the Flat File Destination building block neither.
No one is responsible for the appearance of the second #FFFE in the resulting XML file, yet those disrupting bytes are there.
How can I prevent or remove those hidden characters?
I have looked for programs that can search and replace characters from files, like fnr, but they can't remove "hidden" bytes.
Anyone?
I have a picky client who does not want to see the command window open when a batch file is called from DTS.
Can anyone help me in running it hidden?
I am having an issue with page breaks on tables.
I have 2 tables that I have set to PageBreakOnStart. They have conditional visibility. What I am seeing is that if i put an item in ToggleItem, the page break functionality does not work anymore.
Is this by design? I would have expected the page break to be there if the item is visible, and not if it is hidden.
Any ideas?
Thanks!
BobP
I have 2 datasets in my report and I want to pass a field from the 1st dataset as a parameter to the 2nd dataset.
How can I do this?
I tried to set the report parameter from a query using the 1st dataset but the parameter is always equal to the first record in the recordset-it never changes per row.
Hello Friends,
I have created a SSRS report in which I am using matrix. In this matrix we have one column group and three row groups.So based on column group I am hinding the data which belong to some column group field value "X".
So the data is getting hidded for the column group value "X". Its coming fine in the BIDS but the problem here is its just hiding the values but the layout is still there, its not getting shrinked. Its just showing the white spaces.
So can anyone help me out in solving this issue
Thanks & Regard's
I have a need to import only non-hidden rows from an excel spreadsheet. When I create the package in SSIS, it imports everything. Due to the use of the data on the spreadsheet, we cannot simply delete the data.
Is there a special setting in the Excel Source or Connection manager that can be set to "only import non-hidden rows"?
Also, how do I go about setting the sheet with an index instead of the actual Sheet name? The user changes the sheet name at random, but I know I only need the first two sheets on the file.
Thanks!
Matt Michuta
Can the results screen on the data tab be permanently hidden?
Thanks
BobP
I am working on a login system in flex and asp. I am encrypting the password before it is inserted it into the SQL database. But then when i do SELECT statement with username and encrypted password it returns 0 users found.
I outputted the sql statement and they passwords look excatly the same. But the SQL Select count(*) returns a 0.
link to the encrypting is used:
http://www.4guysfromrolla.com/webtech/110599-1.2.shtml
other information:
script language: asp + flex
database: sql server 2005
So i am thinking that their are hidden chars in the password. Is their a way to check this or even convert/exclude them ?
Any links or tips would be very helpfull
Hi. I have a rectangle in the page header which contains the report graphic and title. I use the rectangle's Propeties > Visibility tab > Expression, with the following code,
=IIF(Globals!PageNumber = 1, False, True)
However, on pages after page 1, the report table's height is the same as page 1 and it's positioned at the same spot as page 1 -- down about 2 inches from the top. How do I get the table's height to fill the page on pages after page 1?
Thank you.
I have been trying for some time to create a columnar report where certain columns can be hidden as requested by the user. I have tried placing the complete column set in the report, and then hiding a subset of columns, but blank pages are produced when rendered to PDF since the report body does not appear to shrink as columns are hidden and justify themselves to the left. I have tried a table, list, and matrix to no avail...
Does anyone know of a workaround, a trick, or even a hack that may accomplish what I am after?
Thanks.
I have a report that has 10 columns. While viewing, users should see only 8 columns and 2 will be hidden.
But is there any way we can export those 2 hidden columns to excel?
Any help is greatly appreciated.
Thanks,
I have a report that has several headings for users to click on to toggle visibility of the data regions that the headings represent. Several of the columns in the data tables have interactive sort enabled. However, every time the user clicks the sort indicator, the region collapses again and is hidden. So, ultimately for users the interactive sort becomes a two-click action, after which they have to visually re-orient.
I tried putting the table into a rectangle and toggling visibility of the rectangle instead of the table, but it exhibited the same behavior.
How can I get it so the regions do not get hidden just because the user sorts?
Thanks,
Joel
What is the vb.net syntax to bind data from a sqldatasource to a hidden field in a form?
View 6 Replies View Related