Estimating hardware requirements for a SQL Server 2005 installation

SQL Server Setup & Upgrade

Index ‹ SQL Server

- Previous
  - 1
    - Error - The report server cannot decrypt the symmetric key? SSRS had been working fine on my comp till the time i insatlled VS 2005. I have started getting following error since VS2005 install The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content and then restart the service. Check the documentation for more information. (rsReportServerDisabled) Get Online Help Bad Data. Why does this error cropped and how can i fix it I am using SQL Server 2000. Thanks Tag: Estimating hardware requirements for a SQL Server 2005 installation
  - 2
    - need to determine which db is pricipal Hi All, i am working with database mirroring and i need to be able to determine which database will be principal. for example if server A is principle and server B is mirrored and server A is down, then server B take owner and become principle, after fixing server A i want it to be principle again, is it possible Tag: Estimating hardware requirements for a SQL Server 2005 installation
  - 3
    - Different ways to set DATEFIRST Hi All, My week starts on Monday rather than on Sunday which is default(US, English) in SQL Server and would like to change the same so I would get proper weeknumber and dayindex using DATEPART. I am looking at different ways of setting DATEFIRST(SET DATEFIRST 1) in SQL Server 2005. I could set in a stored procedure, but this isn't a feasible way for me because I am using .nettiers to generate by business objects and stored procedures. I need to alter the sp's everytime I newly generate the code and sp's. I couldn't set it in a function which I was hoping initially . I understand this datefirst is stored in one of the sys table in MASTER DB and I couldn't find a straight forward way to change this. Can anyone suggest me a way to set the DATEFIRST either at a database level or at a server level(probably by changing the sys table in MASTER DB). Any help on this would be greatly appreciated. Ponnu Trellisys.net Tag: Estimating hardware requirements for a SQL Server 2005 installation
  - 4
    - custom url not recognized i have this action.jumpto url = "javascript:void window.open('http://bklc-crm01:5555/cs/cases/edit.aspx id={" & cstr(Fields!incidentid.Value) & "}','_self')" for some reason when i use this field (incidentid.value) there is no hyperlink generated, however when i change the value to another field, the hyperlink works, what shall i be looking for, incident value is a set of number with dashes! Tag: Estimating hardware requirements for a SQL Server 2005 installation
  - 5
    - Only able to access Report Manager as Administrator Hi, I have Reporting Services set up with the permissions (via Right Click Server/Permisions in SSMS or System Role Assignments in Report Manager) set as follows: BUILTIN\Administrators - System Administrator When logged in as an administrator I am able to access Report Manager, no problem. However, I want to add a new group so that non-administrators can access Report Manager. However, whatever new item I add in the permissions appears to have no effect. For instance, if I add a permission for Users, i.e. : BUILTIN\Administrators - System Administrator BUILTIN\Users - System Administrator I can still only access Report Manager as an administrator.. Any other user just gets the blank page. I have tried creating a custom group, Report Users, with the same result. I checked IIS to ensure anonymous access was turned off (this was an issue I had earlier on in my setup - it was turned on, but is now firmly off). I don't know much about IIS, but I guess the problem is there somewhere. Does anybody have any idea what the problem could be and how I get around it Thanks very much in advance Andy Tag: Estimating hardware requirements for a SQL Server 2005 installation
  - 6
    - SQL Agent Roles I have a domain account that is assigned the the SQLAgentOperator, SQLAgentReader, and SQLAgentUser roles. That domain account is able to create a job and delete the job. But, it is unable to edit the job. If I create a SQL Login with these same permissions, it is able to edit the job. What am I missing We were looking forward to implementing these new built-in security roles because we had to use our own security roles to give us similar functionality in SQL 2000 but it doesn't seem to be working properly in 2005. Michelle Tag: Estimating hardware requirements for a SQL Server 2005 installation
  - 7
    - error for sending(saving) data to database Hi, I’m using VS2005 and I’m trying to link the C# windows form to MSSQL. I used BindingNavigator Control to read the data. After that I add sqlcommand and sqldataadapter to send the data to the database. My code is this sqlDataAdapter1.InsertCommand.CommandText = "INSERT INTO SUDENT (" + "S_ID, S_NAME, S_ADDRESS, S_PHONE" + ") VALUES ('" + S_IDComboBox.Text + "', '" + S_NAMETextBox.Text + "', '" + S_ADDRESSTextBox.Text + "', '" + S_PHONETextBox.Text + "')" ; sqlDataAdapter1.InsertCommand.ExecuteNonQuery(); It gave me this error “ NulleferenceException was Unhandled ”and “ Object refrence not set to an instance of an object ” so I add this line sqlCommand1 = ( "INSERT INTO STUDENT (S_ID,S_NAME,S_ADDRESS,S_PHONE) VALUES (@S_ID,@S_NAME,@S_ADDRESS,@S_PHONE)" ,sqlConnection1); Then it gave me some stupid error. By the way it didn’t make a new object of SqlCommand although I tried …. So can u help me to solve my problem Thank you Tag: Estimating hardware requirements for a SQL Server 2005 installation
  - 8
    - How to migrate from MySQL 4.1 to MS SQL Express 2005 I am trying to migrate from MySQL 4.1 to MS SQL Express 2005 1. do i need to create an empty db under Express 2. can this be done from within Express by pulling from MySQL into Express or do I need to work from command lines 3. what would be the cleanest way to approach this I have a MySQL dump and did look at the result from within Express, but it was not an import, I would like to find a way to import if possible that data. Table by table would be fine. Tag: Estimating hardware requirements for a SQL Server 2005 installation
  - 9
    - Parent - Multiple Child Package Execution I have a parent package "A", I also have 4 child packages "B","B1","B2",B3" In BIDS, I created a file connection in the package "A" to connect to the child packages. So whenever I want to run B1 or B2, I change the path in the file connection to point to B1 or B2 and so on. Since the developement environment is File system this works perfectly fine. But in the Test / Production environment all packages are stored in the Sql server. How can I paramaterize the child package connection so that I can use configuration / variables to select which child package to execute. Thanks Tag: Estimating hardware requirements for a SQL Server 2005 installation
  - 10
    - msdb restore on new server Hello all! First of all our servers: SQL_PROD: production server with SQL Server 2005 SQL_TEST: test server with SQL Server 2005 What we are trying to do: We are testing our backup and recovery procedures. To do so we are using the backups from SQL_PROD and restoring them on SQL_TEST. We are restoring: all user databases, master database, msdb database and model database. The issue we are experiencing: I think we've hit a kink in our recovery procedures concerning msdb database in the context of a recovery on another machine (SQL_TEST in this case). We include msdb in our nightly backups so that, in the event of server loss, our maintenance plans and jobs get restored. On SQL_TEST (after a recovery), the maintenance plans and jobs do get restored but the problem is that they reference the SQL_PROD server (server's name, disks, etc...). Deleting the jobs and maintenance plans from SQL_TEST we got no errors and the jobs and plans disappeared from beneath the Maintenance Plans and Jobs nodes. Doing a refresh on the nodes, the “deleted” plans and jobs reappear beneath their respective nodes! Upon the second deletion (and any consecutive delete) we get the error: Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) ... The SELECT permission was denied on the object 'sysmaintplan_plans', database 'msdb', schema 'dbo'. (Microsoft SQL Server, Error: 229) Clicking on "Show technical details" reveals this: ... Server Name: SQL_PROD Error Number: 229 Severity: 14 State: 5 Line Number: 1 ... Note that SQL_PROD is being referenced in the error message! This morning I took a look at SQL_PROD’s Maintenance Plans and Jobs (the source of the msdb backup) and surprise surprise: THEY WERE ALL GONE!!! This is a MAJOR BUG!!! Deleting a job or a plan on one server should not have the effect of deleting it from a different server (regardless of the origins of the msdb database). Is this a known bug Or is it considered “normal” behavior My questions are: How do we delete the maintenance plans and jobs from SQL_TEST without deleting them from SQL_PROD What is the proper/recommended method to backup and restore maintenance plans and jobs (in fact msdb) Is it by scripting things and recreating them on the recovery server in an empty msdb or is there a way to restore msdb properly from the crashed server Thanks for your help. Regards, Mark Tabash Tag: Estimating hardware requirements for a SQL Server 2005 installation
  - 11
    - Some things about SMO Hey, I have got two problems using SMO. First I cannot start and stop the SQL Server Agent. What property should I use I can only found server.jobserver.restart but this didn't work. Second Question is how to start a job from the server.jobserver.jobs. Is it Job.start or Job.invoke I got an error message "Start failed for job "My Job" " And how can I get the current status if a job is running, if it succeeded or failed. I found: AJob.State which says that my job is idle and AJob.LastRunOutcome which is false after I called AJob.start Can anyone help grtz, Bart Tag: Estimating hardware requirements for a SQL Server 2005 installation
  - 12
    - Add hidden field to report 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> <Value>LO = Layoff</Value> </Textbox> <Textbox Name="textbox71"> <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="textbox66"> <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="textbox67"> <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="textbox68"> <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="textbox63"> <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="textbox64"> <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="textbox65"> <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="textbox58"> <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="textbox57"> <Left>1.96875in</Left> <Top>0.18333in</Top> <rd:DefaultName>textbox57</rd:DefaultName> <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>0.85417in</Top> <ZIndex>12</ZIndex> <Width>3.35833in</Width> <Style> <BorderStyle> <Default>Solid</Default> </BorderStyle> </Style> <Height>1.60833in</Height> </Rectangle> <Textbox Name="Title"> <Left>4.58333in</Left> <Top>0.10417in</Top> <ZIndex>11</ZIndex> <Width>2.87916in</Width> <Style> <TextAlign>Right</TextAlign> <FontFamily>Tahoma</FontFamily> <FontWeight>700</FontWeight> <FontSize>14pt</FontSize> <Color>DarkSlateBlue</Color> </Style> <Height>0.375in</Height> <Value>Invoice Number</Value> </Textbox> <Textbox Name="OrderNumber"> <Left>3.69791in</Left> <Top>0.47917in</Top> <ZIndex>10</ZIndex> <Width>3.76458in</Width> <Style> <TextAlign>Right</TextAlign> <FontFamily>Tahoma</FontFamily> <FontWeight>700</FontWeight> <FontSize>12pt</FontSize> <Color>DarkSlateBlue</Color> </Style> <Height>0.25in</Height> <Value>="Invoice # " & Fields!InvoiceGroup.Value & " - Reprint"</Value> </Textbox> <Textbox Name="TB_EmployerCityStatezip"> <Left>0.01042in</Left> <Top>2.51042in</Top> <ZIndex>9</ZIndex> <Width>2.625in</Width> <Style> <TextAlign>Left</TextAlign> <FontSize>8pt</FontSize> </Style> <Height>0.125in</Height> <Value>=" " &Fields!EmployerCity.Value & ", " & Fields!EmployerState.Value & " " & Fields!EmployerZip.Value</Value> </Textbox> <Textbox Name="tB_EmployerAddress3"> <Left>0.01042in</Left> <Top>2.38542in</Top> <ZIndex>8</ZIndex> <Width>2.625in</Width> <Style> <TextAlign>Left</TextAlign> <FontSize>8pt</FontSize> </Style> <Height>0.125in</Height> <Value>=" " &Fields!EmployerAddress3.Value</Value> </Textbox> <Textbox Name="TB_EmployerAddress2"> <Left>0.01042in</Left> <Top>2.26042in</Top> <ZIndex>7</ZIndex> <Width>2.625in</Width> <Style> <TextAlign>Left</TextAlign> <FontSize>8pt</FontSize> </Style> <Height>0.125in</Height> <Value>=" " & Fields!EmployerAddress2.Value</Value> </Textbox> <Textbox Name="tB_EmployerAddress1"> <Left>0.01042in</Left> <Top>2.13542in</Top> <ZIndex>6</ZIndex> <Width>2.625in</Width> <Style> <TextAlign>Left</TextAlign> <FontSize>8pt</FontSize> </Style> <Height>0.125in</Height> <Value>= " " & Fields!EmployerAddress1.Value</Value> </Textbox> <Textbox Name="TB_EmployerName"> <Left>0.01042in</Left> <Top>1.71875in</Top> <ZIndex>5</ZIndex> <Width>2.61458in</Width> <Style> <TextAlign>Left</TextAlign> <FontWeight>700</FontWeight> <FontSize>12pt</FontSize> </Style> <Height>0.41667in</Height> <Value>=Fields!EmployerName.Value</Value> </Textbox> <Textbox Name="ProvName"> <Top>0.45833in</Top> <rd:DefaultName>ProvName</rd:DefaultName> <ZIndex>4</ZIndex> <Width>3.61458in</Width> <Style> <TextAlign>Left</TextAlign> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <FontWeight>700</FontWeight> <FontSize>12pt</FontSize> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <CanGrow>true</CanGrow> <Height>0.25in</Height> <Value>=First(Fields!ProvName.Value)</Value> </Textbox> <Textbox Name="textbox3"> <Top>0.83333in</Top> <ZIndex>3</ZIndex> <Width>2.375in</Width> <Style> <TextAlign>Left</TextAlign> <FontSize>8pt</FontSize> </Style> <CanGrow>true</CanGrow> <Height>0.125in</Height> <Value> Harwood Heights, IL 60656</Value> </Textbox> <Textbox Name="textbox2"> <Top>0.70833in</Top> <rd:DefaultName>textbox2</rd:DefaultName> <ZIndex>2</ZIndex> <Width>2.375in</Width> <Style> <TextAlign>Left</TextAlign> <FontSize>8pt</FontSize> </Style> <CanGrow>true</CanGrow> <Height>0.125in</Height> <Value> P.O. Box 56319</Value> </Textbox> <Textbox Name="textbox1"> <rd:DefaultName>textbox1</rd:DefaultName> <ZIndex>1</ZIndex> <Width>3.19792in</Width> <Style> <TextAlign>Left</TextAlign> <FontWeight>700</FontWeight> <Color>DarkSlateBlue</Color> <FontStyle>Italic</FontStyle> </Style> <CanGrow>true</CanGrow> <Height>0.25in</Height> <Value>Mail all checks with two white copies to:</Value> </Textbox> <Textbox Name="textbox43"> <Left>0.19792in</Left> <Top>5.53126in</Top> <rd:DefaultName>textbox43</rd:DefaultName> <Width>4.03125in</Width> <Style> <TextAlign>Center</TextAlign> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <FontFamily>Times New Roman</FontFamily> <FontSize>12pt</FontSize> <Color>Red</Color> <TextDecoration>Underline</TextDecoration> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <CanGrow>true</CanGrow> <Height>0.48958in</Height> <Value>Make Sure to Sign this report after the Grand Total</Value> </Textbox> </ReportItems> <DataSetName>SpProductionData</DataSetName> <ZIndex>1</ZIndex> <Width>7.48332in</Width> <Style> <BackgroundColor>White</BackgroundColor> </Style> <Grouping Name="list1_Details_Group"> <PageBreakAtStart>true</PageBreakAtStart> <GroupExpressions> <GroupExpression>=Ceiling(RowNumber("Body_MainGroup_Details_Group")/20)</GroupExpression> </GroupExpressions> </Grouping> <Height>6.19013in</Height> </List> <Rectangle Name="rectangle6"> <Left>0.22916in</Left> <ReportItems> <Textbox Name="textbox25"> <Left>4.58854in</Left> <Top>1.2284in</Top> <ZIndex>5</ZIndex> <Width>0.625in</Width> <Style> <TextAlign>Center</TextAlign> <PaddingLeft>2pt</PaddingLeft> <FontFamily>Times New Roman</FontFamily> <FontSize>9pt</FontSize> <PaddingRight>2pt</PaddingRight> </Style> <CanGrow>true</CanGrow> <Height>0.15in</Height> <Value>Date</Value> </Textbox> <Line Name="line2"> <Left>4.33854in</Left> <Top>1.2284in</Top> <ZIndex>4</ZIndex> <Width>1.125in</Width> <Style> <BorderStyle> <Default>Solid</Default> </BorderStyle> </Style> <Height>0in</Height> </Line> <Textbox Name="textbox27"> <Left>2.42187in</Left> <Top>1.23882in</Top> <ZIndex>3</ZIndex> <Width>0.625in</Width> <Style> <TextAlign>Center</TextAlign> <PaddingLeft>2pt</PaddingLeft> <FontFamily>Times New Roman</FontFamily> <FontSize>9pt</FontSize> <PaddingRight>2pt</PaddingRight> </Style> <CanGrow>true</CanGrow> <Value>Signature</Value> </Textbox> <Line Name="line3"> <Left>1.66146in</Left> <Top>1.2284in</Top> <ZIndex>2</ZIndex> <Width>2.33333in</Width> <Style> <BorderStyle> <Default>Solid</Default> </BorderStyle> </Style> <Height>0in</Height> </Line> <Table Name="table3"> <Footer> <TableRows> <TableRow> <TableCells> <TableCell> <ReportItems> <Textbox Name="textbox44"> <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> <ColSpan>2</ColSpan> <ReportItems> <Textbox Name="textbox45"> <ZIndex>1</ZIndex> <Style> <TextAlign>Center</TextAlign> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <FontFamily>Times New Roman</FontFamily> <FontSize>8pt</FontSize> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <CanGrow>true</CanGrow> <Value>="The Information is certified correct on this Report as of: " & now()</Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox46"> <Style> <TextAlign>Left</TextAlign> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <FontWeight>700</FontWeight> <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> <Top>0.25in</Top> <TableGroups> <TableGroup> <Header> <TableRows> <TableRow> <TableCells> <TableCell> <ReportItems> <Textbox Name="textbox47"> <ZIndex>6</ZIndex> <Style> <TextAlign>Center</TextAlign> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <FontWeight>700</FontWeight> <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="textbox48"> <ZIndex>5</ZIndex> <Style> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <FontWeight>700</FontWeight> <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="textbox49"> <ZIndex>4</ZIndex> <Style> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <FontWeight>700</FontWeight> <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!BankAccountName.Value)</Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox50"> <ZIndex>3</ZIndex> <Style> <TextAlign>Left</TextAlign> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <FontWeight>700</FontWeight> <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.1875in</Height> </TableRow> </TableRows> </Header> <Grouping Name="table3_Group1"> <GroupExpressions> <GroupExpression>=Fields!BenefitTypeID.Value</GroupExpression> <GroupExpression>=Fields!AccountID.Value</GroupExpression> </GroupExpressions> </Grouping> </TableGroup> </TableGroups> <ZIndex>1</ZIndex> <Width>7.25in</Width> <Style> <FontSize>8pt</FontSize> </Style> <Header> <TableRows> <TableRow> <TableCells> <TableCell> <ReportItems> <Textbox Name="textbox51"> <ZIndex>14</ZIndex> <Style> <TextAlign>Left</TextAlign> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <FontWeight>700</FontWeight> <FontSize>8pt</FontSize> <BackgroundColor>Gainsboro</BackgroundColor> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <CanGrow>true</CanGrow> <Value>Row No</Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox52"> <ZIndex>13</ZIndex> <Style> <TextAlign>Left</TextAlign> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <FontWeight>700</FontWeight> <FontSize>8pt</FontSize> <BackgroundColor>Gainsboro</BackgroundColor> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <CanGrow>true</CanGrow> <Value>BenefitType Description</Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox53"> <ZIndex>12</ZIndex> <Style> <TextAlign>Left</TextAlign> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <FontWeight>700</FontWeight> <FontSize>12pt</FontSize> <BackgroundColor>Gainsboro</BackgroundColor> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <CanGrow>true</CanGrow> <Value>*Make Seperate Checks Payable to*</Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox54"> <ZIndex>11</ZIndex> <Style> <TextAlign>Left</TextAlign> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <FontWeight>700</FontWeight> <FontSize>8pt</FontSize> <BackgroundColor>Gainsboro</BackgroundColor> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <CanGrow>true</CanGrow> <Value>Amount</Value> </Textbox> </ReportItems> </TableCell> </TableCells> <Height>0.25in</Height> </TableRow> <TableRow> <TableCells> <TableCell> <ReportItems> <Textbox Name="textbox101"> <ZIndex>10</ZIndex> <Style> <TextAlign>Center</TextAlign> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <FontWeight>700</FontWeight> <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="textbox107"> <ZIndex>9</ZIndex> <Style> <TextAlign>Left</TextAlign> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <FontWeight>700</FontWeight> <FontSize>8pt</FontSize> <BackgroundColor>=iif(code.GetCurrentGroupNumber mod 2, "#e8e8c9", "White")</BackgroundColor> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <CanGrow>true</CanGrow> <Value>Severance</Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox108"> <ZIndex>8</ZIndex> <Style> <TextAlign>Left</TextAlign> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <FontWeight>700</FontWeight> <FontSize>8pt</FontSize> <BackgroundColor>=iif(code.GetCurrentGroupNumber mod 2, "#e8e8c9", "White")</BackgroundColor> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <CanGrow>true</CanGrow> <Value>NPWU Severance Trust</Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox109"> <ZIndex>7</ZIndex> <Style> <TextAlign>Left</TextAlign> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <FontWeight>700</FontWeight> <FontSize>8pt</FontSize> <Format>C</Format> <BackgroundColor>=iif(code.GetCurrentGroupNumber mod 2, "#e8e8c9", "White")</BackgroundColor> <PaddingRight>2pt</PaddingRight> <FontStyle>Italic</FontStyle> <PaddingTop>2pt</PaddingTop> </Style> <CanGrow>true</CanGrow> <Value>***********</Value> </Textbox> </ReportItems> </TableCell> </TableCells> <Height>0.1875in</Height> </TableRow> </TableRows> </Header> <TableColumns> <TableColumn> <Width>0.625in</Width> </TableColumn> <TableColumn> <Width>2.61458in</Width> </TableColumn> <TableColumn> <Width>3.13542in</Width> </TableColumn> <TableColumn> <Width>0.875in</Width> </TableColumn> </TableColumns> <Height>0.83388in</Height> </Table> <Textbox Name="textbox55"> <Top>0.01042in</Top> <Width>7.25in</Width> <Style> <TextAlign>Center</TextAlign> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <FontFamily>Times New Roman</FontFamily> <FontWeight>700</FontWeight> <FontSize>14pt</FontSize> <BackgroundColor>Black</BackgroundColor> <Color>White</Color> <TextDecoration>Underline</TextDecoration> <PaddingRight>2pt</PaddingRight> <FontStyle>Italic</FontStyle> <PaddingTop>2pt</PaddingTop> </Style> <CanGrow>true</CanGrow> <Height>0.25in</Height> <Value>=code.ResetOffset() & "GRAND TOTAL"</Value> </Textbox> </ReportItems> <Top>6.25351in</Top> <Width>7.26042in</Width> <Style> <BorderStyle> <Default>Solid</Default> </BorderStyle> </Style> <Height>1.38882in</Height> </Rectangle> </ReportItems> <DataSetName>SpProductionData</DataSetName> <Style> <TextAlign>Right</TextAlign> </Style> <Grouping Name="Body_MainGroup_Details_Group"> <PageBreakAtEnd>true</PageBreakAtEnd> <GroupExpressions> <GroupExpression>=Fields!InvoiceGroup.Value</GroupExpression> </GroupExpressions> </Grouping> </List> </ReportItems> <Height>14.02084in</Height> </Body> <rd:ReportID>4ced04b7-8e86-4b0d-8230-b834c5742018</rd:ReportID> <LeftMargin>0.2in</LeftMargin> <DataSets> <DataSet Name="SpProductionData"> <Query> <rd:UseGenericDesigner>true</rd:UseGenericDesigner> <CommandType>StoredProcedure</CommandType> <CommandText>Sproc_Reports_GenerateInvoiceReportReprint</CommandText> <QueryParameters> <QueryParameter Name="@InvoiceID"> <Value>=Parameters!InvoiceID.Value</Value> </QueryParameter> <QueryParameter Name="@BatchID"> <Value>=Parameters!BatchID.Value</Value> </QueryParameter> </QueryParameters> <DataSourceName>SPProduction</DataSourceName> </Query> <Fields> <Field Name="ReportBatch"> <rd:TypeName>System.Int32</rd:TypeName> <DataField>ReportBatch</DataField> </Field> <Field Name="InvoiceGroup"> <rd:TypeName>System.String</rd:TypeName> <DataField>InvoiceGroup</DataField> </Field> <Field Name="EmployerID"> <rd:TypeName>System.Int32</rd:TypeName> <DataField>EmployerID</DataField> </Field> <Field Name="ShipName"> <rd:TypeName>System.String</rd:TypeName> <DataField>ShipName</DataField> </Field> <Field Name="EmployerName"> <rd:TypeName>System.String</rd:TypeName> <DataField>EmployerName</DataField> </Field> <Field Name="EmployerAddress1"> <rd:TypeName>System.String</rd:TypeName> <DataField>EmployerAddress1</DataField> </Field> <Field Name="EmployerAddress2"> <rd:TypeName>System.String</rd:TypeName> <DataField>EmployerAddress2</DataField> </Field> <Field Name="EmployerAddress3"> <rd:TypeName>System.String</rd:TypeName> <DataField>EmployerAddress3</DataField> </Field> <Field Name="EmployerCity"> <rd:TypeName>System.String</rd:TypeName> <DataField>EmployerCity</DataField> </Field> <Field Name="EmployerState"> <rd:TypeName>System.String</rd:TypeName> <DataField>EmployerState</DataField> </Field> <Field Name="EmployerZip"> <rd:TypeName>System.String</rd:TypeName> <DataField>EmployerZip</DataField> </Field> <Field Name="InvoiceID"> <rd:TypeName>System.String</rd:TypeName> <DataField>InvoiceID</DataField> </Field> <Field Name="EmployeeID"> <rd:TypeName>System.Int32</rd:TypeName> <DataField>EmployeeID</DataField> </Field> <Field Name="EmployeeFName"> <rd:TypeName>System.String</rd:TypeName> <DataField>EmployeeFName</DataField> </Field> <Field Name="EmployeeLName"> <rd:TypeName>System.String</rd:TypeName> <DataField>EmployeeLName</DataField> </Field> <Field Name="EmployeeMI"> <rd:TypeName>System.String</rd:TypeName> <DataField>EmployeeMI</DataField> </Field> <Field Name="EmployeeSSN"> <rd:TypeName>System.String</rd:TypeName> <DataField>EmployeeSSN</DataField> </Field> <Field Name="BenefitTypeID"> <rd:TypeName>System.Int32</rd:TypeName> <DataField>BenefitTypeID</DataField> </Field> <Field Name="BenefitTypeName"> <rd:TypeName>System.String</rd:TypeName> <DataField>BenefitTypeName</DataField> </Field> <Field Name="CoverageTypeDesc"> <rd:TypeName>System.String</rd:TypeName> <DataField>CoverageTypeDesc</DataField> </Field> <Field Name="PlanTypeDesc"> <rd:TypeName>System.String</rd:TypeName> <DataField>PlanTypeDesc</DataField> </Field> <Field Name="InvoiceStartdate"> <rd:TypeName>System.DateTime</rd:TypeName> <DataField>InvoiceStartdate</DataField> </Field> <Field Name="InvoiceEndDate"> <rd:TypeName>System.DateTime</rd:TypeName> <DataField>InvoiceEndDate</DataField> </Field> <Field Name="DueDate"> <rd:TypeName>System.DateTime</rd:TypeName> <DataField>DueDate</DataField> </Field> <Field Name="EmployerCode"> <rd:TypeName>System.String</rd:TypeName> <DataField>EmployerCode</DataField> </Field> <Field Name="ProvCode"> <rd:TypeName>System.String</rd:TypeName> <DataField>ProvCode</DataField> </Field> <Field Name="ProvID"> <rd:TypeName>System.Int32</rd:TypeName> <DataField>ProvID</DataField> </Field> <Field Name="ProvName"> <rd:TypeName>System.String</rd:TypeName> <DataField>ProvName</DataField> </Field> <Field Name="AccountID"> <rd:TypeName>System.Int32</rd:TypeName> <DataField>AccountID</DataField> </Field> <Field Name="BankAccountName"> <rd:TypeName>System.String</rd:TypeName> <DataField>BankAccountName</DataField> </Field> <Field Name="Rate"> <rd:TypeName>System.Decimal</rd:TypeName> <DataField>Rate</DataField> </Field> <Field Name="InitialFee"> <rd:TypeName>System.Int32</rd:TypeName> <DataField>InitialFee</DataField> </Field> <Field Name="PeriodToBill"> <rd:TypeName>System.DateTime</rd:TypeName> <DataField>PeriodToBill</DataField> </Field> <Field Name="CreateDate"> <rd:TypeName>System.DateTime</rd:TypeName> <DataField>CreateDate</DataField> </Field> </Fields> </DataSet> </DataSets> <Code>private offset as Integer = 0 private Row as integer = 0 Private GroupIDOld as string = "" Private GroupIDOld1 as string = "" Private PageCount as integer = 0 Private CurrentPage as integer = 0 Private EmployeeIDOld as integer = 0 Private strReturn as string = "" Public Function GetCurrentPageNumber(byval GroupID as string) as Integer return CurrentPage end Function Public Function FirstEmployee(byval EmployeeID as integer) as string return strReturn end Function Public Function GetPageNumber(byval GroupID as string) as Integer If GroupID <> GroupIDOld1 GroupIDOld1 = GroupID CurrentPage = 1 else CurrentPage +=1 end if return CurrentPage end Function Public Function GetGroupNumber() as integer offset += 1 Return offset End Function Public Function GetCurrentGroupNumber() as integer Return offset End Function Public Function ResetOffset() as string offset = 0 return "" End Function Public Function GetRowNumber(byval GroupID as string, byval EmployeeID as integer) as Integer If GroupID <> GroupIDOld GroupIDOld = GroupID Row = 1 StrReturn = "" else Row+=1 if EmployeeIDOld = EmployeeID StrReturn = "********" else StrReturn = "" end if end if EmployeeIDOld = EmployeeID return row end Function </Code> <Width>7.70833in</Width> <InteractiveHeight>11in</InteractiveHeight> <Language>en-US</Language> <TopMargin>0.2in</TopMargin> </Report> [/code] Tag: Estimating hardware requirements for a SQL Server 2005 installation
  - 13
    - Making Reports Customizeable for Users on a .NET site Hello, We have a small .NET intranet site and I have some experience with Reporting Services. What I am looking to do is develop some reports on our website. However, I would like to make it so the user can do some customization of their reports. For example, there would be sections of reports (Headcounts, Turnover, etc.) and in each section there would be measurements they could click to include. So I could select the Headcounts section and select the measurements such as Terminations, Hires, and Period End Headcount. I may not select the Turnover sections at all. I am almost thinking like a Google page where you can move around the sections and have your own customized report. Maybe these sections could work as Web Parts, or something like that. Does any of this make sense Is it possible Are there are websites or examples that are out there that I could get an idea to see if this has been done and how to do it Thank you. -Gumbatman Tag: Estimating hardware requirements for a SQL Server 2005 installation
  - 14
    - Connections through a server alias, IP address, or any other alternate name are not supported. Hi I am trying to connect to another sql server in my company using the IP address for exmp. : 111.111.1.1\SQL2005 but it show this message: Connections through a server alias, IP address, or any other alternate name are not supported. it was working well on SQL2000 Please help Tag: Estimating hardware requirements for a SQL Server 2005 installation
  - 15
    - How to deliver a report dynamically based on the dataset with standard edition? Hi All, I am working on a report which displays profit and loss discrepancy between two systems. So if there is discrepancy, in other words, the dataset returns value, then I want reporting serive to deliever the report to intended users. I am currently using standard edition with no data-driven subscription support. I do not know what is the workaround for this implementation. Tks for advise in advance. Alex Tag: Estimating hardware requirements for a SQL Server 2005 installation
  - 16
    - Design table need help Currently I need to design database table and got stuck. I have a project and its sub projects. A parent project and its sub projects share the same requirement.The description of the requirement will be changed every day. For example Project A - Do Some thing 1 on Project A [09/28/2007] Project A-A1 - Do Some thing 1 on Project A [09/28/2007] , Do Some thing 2 on Project A [09/29/2007] Every time the comments updated, both project A and project A-A1 should share the same update i.e select project A and its subproject will be displayed Project A Do Some thing 1 on Project A [09/28/2007] , Do Some thing 2 on Project A [09/29/2007] Project A-A1 Do Some thing 1 on Project A [09/28/2007] , Do Some thing 2 on Project A [09/29//2007] When you tried to insert new sub project, the requirement will be shared with the parent project ie. Project A - Do Some thing 1 on Project A [09/28/2007] Project A-A1 - Do Some thing 1 on Project A [09/28/2007] , Do Some thing 2 on Project A [09/29/2007] Project A-A2 - Do Some thing 1 on Project A [09/28/2007] , Do Some thing 2 on Project A [09/29/2007] , Do Some thing 2 on Project A-A2 [09/30/2007] assume Project A-A1 and Project A-A2 are sub project of project A Could anyone show me how to design the database table for those mess Thank you Tag: Estimating hardware requirements for a SQL Server 2005 installation
- Next
  - 1
    - Online/Offline Application that must synchronize with SQL 2005 Hi ! I must developp a WPF Application with online and offline capabilities! First I think to use XML file on the local application and transfer these XML files to a webservice that will synchronize them with the SQL 2005 Server BUT I read about "Replication"... and I think it will be much simpler to implement!!! Do you think it is a good idea to have a "local" SQL Express database and replicate it (when connection available is) with the principal database that will run a standard SQL 2005 version! Do you have another suggestion to make such an application Thanks for help!!! PlaTyPuS PS: when the sql express solution a good idea is, does it give a simple solution to programm an automatic synchronization every hour Tag: Estimating hardware requirements for a SQL Server 2005 installation
  - 2
    - SSAS - Custom Rollup in Snapshot Cube - SQL 2000 vs SQL 2005 In AS SQL 2000, I have a snapshot cube. The date dimension is defined with a custom rollup formula for Year (Avg([Snapshot Date].CurrentMember.Children)), Quarter (Avg([Snapshot Date].CurrentMember.Children))...etc. In SQL 2005, I cannot see how do to this. The date dimension has a custom rollup field for my Year, Quarter, etc., but it does not allow MDX. Help!!! All my data is adding!!! Linda Tag: Estimating hardware requirements for a SQL Server 2005 installation
  - 3
    - Problem returning SQL data I'm having trouble with the display of data when I test my asp page. I basically retrieves or pulls data from different tables in a database. Based on an ID number (which I can change manually by typing in a value and appending it to the URL), it shows GuestName, GuestDescription and URL as text link. I can get it to do that much. But for some reason it's not showing the URL associated with the Guest Name. I dont think it's the display section of my code. I think it's the Select statement. Here is what the output looks like in my Firefox and IE browsers when I test. Some data has been changed to protect it's integrity: (Name in bold) Mark Crisp's author of The Bush Lexicon. His new book... Related Links: John Doe interviewed by Susan Smith, 123 News What it should say in the link is this: Mark Crisp's blog (as text link) When I test for different data I just change the end of the URL like this: defaultprogram4.asp ID=1234 (this number represents an ID column in a table) Code Snippet <% set con = Server.CreateObject("ADODB.Connection") con.Open "File Name=E:\webservice\Company\Company.UDL" set rs = Server.CreateObject("ADODB.Recordset") id=request.querystring("id") 'If this line is commented out the page will be blank. 'However you can still append a record number to the end of the URL and display that one. IF id <> "" then id=id else id="1234" end if 'This line shows the default record of 1234. If this line is commented out the page will ONLY show the default record but will NOT allow you 'to append a different number strSQL = "SELECT *, T_Programs.ID AS Expr1, T_ProgramGuests.ProgramID AS Expr2, T_ProgramGuests.GuestName AS Expr3, T_ProgramGuests.GuestDescription AS Expr4, T_ProgramLinks.URL AS Expr5, T_ProgramLinks.Description AS Expr6 FROM T_ProgramGuests CROSS JOIN T_Programs CROSS JOIN T_ProgramLinks WHERE (T_ProgramGuests.ProgramID = '" & id & "')" rs.Open strSQL,con 'open a connection to the database %> <br /> <strong><% Response.Write RS ("GuestName") %> </strong> <% Response.Write RS("GuestDescription") %><br /><br /> Related Links:<br /> <li class='basic'><A HREF="<%= RS("URL") %>"><%= RS("Description") %></A></li>  <% recProgram.Close con.Close set recProgram = nothing set con = nothing %> Bottom line here is this: Why would I be seeing one name but a link not associated with that name It's as though it's reading a name from the ProgramGuests table and a URL from the ProgramLinks table (Except that: it shows a completely different unrelated URL to that name). What am I missing Tag: Estimating hardware requirements for a SQL Server 2005 installation
  - 4
    - Jump to report Navigation Can I have a report that is nothing more than a parameter and when the user selects from the list it will jump to another report based on which parameter was selected I can create a report with a text box that I can click to jump. I'd like to be able to eliminate the click on text box if possible and jump directly from parameter select pull down box. Thanks. Tag: Estimating hardware requirements for a SQL Server 2005 installation
  - 5
    - Error using /SET I have a data importing .dtsx file that I would like to point towards another server on occasion. I tried: DTEXEC /FILE "fubar.dtsx" /SET "\Package.Connections[ConnectionManagerName].Properties[ConnectionString];Data Source=NEWSVR;Initial Catalog=Fubar;Provider=SQLNCLI;Integrated Security=SSPI;Auto Translate=False;" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EWCDI but I keep getting the error: Argument ""\Package.Connections[ConnectionManagerName].Properties[ConnectionString];Data Source=NEWSVR;Initial Catalog=Fubar;Provider=SQLNCLI;Integrated Security=SSPI;Auto Translate=False;"" for option "set" is not valid. Staring at the XML within the .dtsx file gave me no insight other than I suspect the "ConnectionManagerName" is the problem. How do I figure out the magic incantation It's definitely not as trivial as using '-S NEWSVR' on SQLCMD! Tag: Estimating hardware requirements for a SQL Server 2005 installation
  - 6
    - How to remove Reporting Server Sp2 Hi all, After I install the Sp2 for Reporting Service, one of the report is given me the wrong result. So I want to remove the Sp2 Thanks, Tag: Estimating hardware requirements for a SQL Server 2005 installation
  - 7
    - Problems with ProcessAdd and secondary DataSource We have a SSAS 2005 cube in place and have been using ProcessAdd XMLA for some time with success. The current environment has a single datasource called 'Sales' and a single DSV called 'Sales'. The sales datasource is a DB2 database. Everything works great. In preperation for adding some new data sources, we have built a version in our test environment that is configured with two data sources and a single DSV. 'Master' is the primary DS and it points to an empty DB on SQL Server. 'Sales' is a secondary DS and it points to the original DB2 database. There is a single DSV that is called 'Master'. Everything works well through SSMS, but I can't seem to build the correct XMLA to get ProcessAdd working again. If I build it with the 'Master' datasource and DSV it gives me a bunch of errors that arent specific enough for me to take action. Things like Error ErrorCode = " 3240034316 " Description = " Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'DIM IBU HIER VER', Name of 'IBU' was being processed. " Source = " Microsoft SQL Server 2005 Analysis Services " HelpFile = "" If I build the xmla for ProcessAdd with the 'Sales' datasource and 'Master' DSV and then rename 'Master' to 'Sales' it appears to work and executes successfuly.. However, when you watch the activity on the profiler, it is not using the query from the out-of-line DSV query but instead it goes back to SSAS DB and uses the query stored there. All of the ProcessAdd examples I have seen seem to deal with a single DSV and DS. Can there be multiple datasources in the ProcessAdd xmla Is it possible to make this scenario work Thanks, Marty Tag: Estimating hardware requirements for a SQL Server 2005 installation
  - 8
    - Relative date ---'Rolling 3 months' --help please Hi, I need to add special relative date categories in SSAS that similar to the functionality offered by Cognos/Powerplay. With Cognos, you can create relative time categories very easily-- like ‘Rolling 3 months’, ‘Prior Rolling 12 Months’ etc. I created Time Dimension with SSAS BI Studio, added a new named calculation ‘Rolling 3 Months’ to the Time Dimension. Below is calculation code: CREATE MEMBER CURRENTCUBE .[Time].[Rolling 3 Months].[Rolling 3] AS null , VISIBLE = 1 ; Scope ( { [Measures].[ORDERS] } ); // Rolling 3 Months ( [Time].[Rolling 3 Months].[Rolling 3], [Time].[Month].[Month]. Members ) = Tail ([Time].[Month]. members ,3 ); End Scope ; I uesd Tail() function in SS Management studio, it got the result I want. But it doesn’t work in SSAS BI Studio. Am I missing something here Or any suggestions would be greatly appreciated. Thanks. Tag: Estimating hardware requirements for a SQL Server 2005 installation
  - 9
    - Rename SQL Bit in Reporting services Hello, What is the best way to rename a bit "True/False" to "Open/Closed" or "yes/no" in the expression editior. Thanks B Tag: Estimating hardware requirements for a SQL Server 2005 installation
  - 10
    - Writeback with ProClarity Hi there, I need to writeback to my cube. I've set it all up on the cube, and I can go into SSMS, execute this command: update cube [NHCFE DW] set ([DIM TIME].[Financial].[Fin Year Name].&[2006], [DIM GL Transactions].[Codes Hierarchy].[GL Account].&[106], [Measures].[Forecast Value])=100 And it works just fine. Now all I need is a client tool to enable users to write back. Imagine my disappointment when I saw that Excel 2007 just refuses to play. Not only that, but you can't work around with the Add-In that used to allow Excel 2003 to do writeback. A bit embarrassing, especially as I'd insisted on Excel 2007 being rolled out, because it 'works really, really well with cubes.' OK, I know a little bit of ProClarity, so I reached for that. Sure enough, there is writeback built in there. However, It's working in such a weird way that I'm not sure whether it's going to be useable or not. Could I ask you lot to sense check what's happening here, because I may be missing something obvious. I assumed that ProClarity would just issue the mdx pretty much as I'd written above. When I trapped it with Profiler, I saw that It was explicitly sending an [All] for every attribute in the cube. OK, verbose, but no big problem. It was explicitly sending the default member on the time dimension. This IS a big problem. I have a default member set up in the cube calcualtions - this sort of thing: CALCULATE; ALTER CUBE CURRENTCUBE UPDATE DIMENSION [DIM Time], DEFAULT_MEMBER = StrToMember("[DIM Time].[Calendar].[Time Key].&[" + format(DateAdd("d",-1,now()),"yyyyMMdd") +"]"); So, the default member on the time dimension is alwys yesterday. Up to now, this has been a great help to users. Now however, when ProClarity sends the update command to the Cube, it starts like this: (red represents default member) UPDATE CUBE [NHCFE DW] SET ( [Measures].[Forecast Value], [DIM TIME].[Calendar].[Time Key].&[20070813], [DIM TIME].[Hierarchy].[Fin Period Key].&[200612], [DIM TIME].[Year].&[2007], [DIM TIME].[Month Key].&[200708], [DIM TIME].[Time Key].&[20070813], [DIM TIME].[Ac Year Name].&[06/07], [DIM TIME].[Fin Period Key].&[200612], [DIM TIME].[Financial DIM TIME Calculations].&[Current DIM TIME], [DIM TIME].[Fin Year Name].&[2006], [DIM STAFF].[STAFF ID].[All], [DIM STAFF].[NAME].[All], [DIM ROOM].[Site-Room].[All], etc etc etc etc So, I can only update the Financial Period that contains the default member.i,e the current one. Anything else, and the co-ordinate doesn't exist. I don't even want the default member to be getting involved here, I just want to specify the Financial Periods that I want to update. What's going on here What am I doing wrong Any help gratefully received... edit >here's the error Profiles throws:"Errors in cell writeback: Unable to write back to a cell because the specified cell does not exist in the cube space. <edit Tag: Estimating hardware requirements for a SQL Server 2005 installation
  - 11
    - How to selectively apply a filter Based on some report parameters value My dataset to display is coming from a stored procedure. Now based on a report parameter which user selects, I want to filter the results being displayed but only if user selects certain value in the parameter drop down. I tried using iif statement and I can use it to filter dataset based on parameter but can't get how NOT to apply the filter for a particular value of the user selected parameter. Hope I am clear. Tag: Estimating hardware requirements for a SQL Server 2005 installation
  - 12
    - datetime format setting --> mm-dd-yyyy instead of dd-MM-yyyy in SQL Server 2005 / expre(is it with sql server login language I’m getting a datetime format problem(mm-dd-yyyy for dd-MM-yyyy), when I install SQL Server 2005 Express. {The exception is: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.} My windows Regional and Language options – English (United Kingdom), Sort date format is dd-MM-yyyy. When converting the date time in Sql server is using the mm-dd-yyyy format. But I’m supplying the dd-mm-yyyy format date time. I tried number of things none of them worked for me 1. Tried changing the default language and get the date time format - exec sp_configure 'default language', 2057 reconfigure - did not work EXEC sp_defaultlanguage 'my user name', 'British' - did not work (Ref: http://www.cactushop.com/support/UKUS-date-format-issues-with-MS-SQL---conversion-errors-or-blank-pages__592__.htm ) 2. Tried a registry hack by opening regedit, and get the following 3 language keys and change it to decimal 2057: [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\ClientSetup\CurrentVersion] [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\Setup [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup] (Ref: http://www.sqlteam.com/forums/topic.asp TOPIC_ID=62891 ) - did not work 3. Every thing in the Regional and Language options to UK and British with the date time format input language keyboard and every think else I could think of, which could link to US English or US date format --------- Did not work 4. even went into the extend of modifying the date format on a Windows machine for new users account by editing the HKEY_USERS registry key and creating a new user - Did not work (Ref: http://www.windowsitpro.com/Article/ArticleID/39407/39407.html ) 5. Uninstall and reinstall SQL server express several time and did the steps 1 – 4 where applicable – did not work…. If anyone has any idea of what I have to do to change the date time format in the SQL Server 2005 to use the dd-mm-yyyy format for dates.... Please help me or point me in the direction in which I have to look for an answer. Thank you very much…. Tag: Estimating hardware requirements for a SQL Server 2005 installation
  - 13
    - What types of permissions are required for the anonymous account to access local cubes? I created a local cube from an AS 2005 cube and when I try to connect to it using a web application the following exception is returned: Exception: A connection cannot be made. Ensure that the server is running. And the connection string that I am using is: " Provider=MSOLAP;Data Source=MyPath\LocalcubeName.cub;Catalog=Local cube 1;MDX Compatibility=2; " Everything works properly in the following cases: 1. If I am debugging. 2. And also outside of debugging if I change the anonymous user to my network account and change web.config to use impersonation. What types of permissions are required for the anonymous account to access the local cube Thanks, Abdel Tag: Estimating hardware requirements for a SQL Server 2005 installation
  - 14
    - Unwanted aggregation in the row set Dear All, I tryed to do the following OpenQuery([ssas DS], select {[Measures].[Weekday], [Measures].[Weekday], [Measures].[sales count]} on columns, {[Dim Time].[Weekday].members} on rows from CubeName) It returns me the followings: Weekday Weekday Sales Count All 5 5 20402295 1 1 1 3445560 2 2 2 3950970 3 3 3 4532115 4 4 4 4498965 5 5 5 3974685 But I don't want the row "All 5 5 20402295" to be included in the row how can I remove it from the rowset Thanks Tony Chun Tung Siu Tag: Estimating hardware requirements for a SQL Server 2005 installation
  - 15
    - Iterating the rows of a script component Hi There, Can someone please let me know what is the best way to iterate the output rows of a script component and stick in those ids in a where clause of a select query (to retrieve additional info from a database) Is this possible at all If not, what is the best way to deal with this situation Thanks a lot!! Tag: Estimating hardware requirements for a SQL Server 2005 installation
  - 16
    - SSAS architecture scalability question I have a question about how to build a scalable SSAS systems. The business scenario is that a lot of users need to query a huge cube. Solution 1: Network Load Balance manager and synchronize feature. The problem is that the database is duplicated on every ssas server. Solution 2: Remote partition on multiple ssas server and only one ssas query server. This solution only good to process partitions and no benefit to query. Solution 3: Create linked cube on multiple ssas server which link to one ssas source server. The execution of mdx script after 'Calculate' happens on the linked server. But what is the answers for the following two questions How does the query workload distribute between linked server and source server What is the exactly logic of 'Calculate' (mdx script function) for linked server Solution 4: Create molap cube on a shared phsical storage (SAN) and multiple ssas servers use the same SAN. Is this solution possible Can any expert give me answers to my questions and suggest other possible solutions Thanks. Tag: Estimating hardware requirements for a SQL Server 2005 installation

SultanOfSuede

Is there any good online documentation describing rules of thumb for estimating and planning a SQL Server 2005 deployment in support of a Windows rich client/WCF services architecture

TIA,

Ian

Top

Re: Estimating hardware requirements for a SQL Server 2005 installation

Jens K. Suessmeyer

Well you do not want to hear that answer, but it depends.It’s like asking, How much gas will I need when I travel from NYC to Seattle. Well that depends on how much data / luggage will be transported, which transport device you use, how much data will be retrieved, how often you will query the database, how many users will access the database, etc. There are many parameters to consider.

Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---

Top

Re: Estimating hardware requirements for a SQL Server 2005 installation

kMaylo

Hi-

can’t you make an approximation

i mean the average requirement

thanx

Maylo

Top