custom url not recognized

SQL Server Reporting Services

Index ‹ SQL Server

- Previous
  - 1
    - tabel scan Hi All, When an end user view a report using report manager or a custom build web site, would query of the report scan the tables in original data base In this case it is a OLTP data base. Thanks Tag: custom url not recognized
  - 2
    - Cannot Load SQLSpars.dll We'll likely need to see all the log files plus summary.txt, which is in their parent directory. The files are big enought that you shouldn't try to post them here. Instead, please provide a link. Paul Tag: custom url not recognized
  - 3
    - Strange thing in All examples at MSDN Hi, I have seen many examples at MSDN library related to SQL Querries in all queries one thing is same the way they use tables in there queries. BUT wht is this really i am not getting this, can anyone tell me.. the code and the problem is as follows: Code Snippet FROM Purchasing.ProductVendor JOIN Purchasing.Vendor ON (ProductVendor.VendorID = Vendor.VendorID) In the above code u see "Purchasing.ProductVendor", I want to ask that wht is this Purchasing Stands for, If we suppose that purxchasing is the database name then also normally we use database name as Purchasing.dbo.ProductVendor BUT I am not getting that what is this, Please if someone knows then explain it to me, Thanks. Tag: custom url not recognized
  - 4
    - SQL server database services option greyed out Hi, I'm trying to install SQL Server 2005 onto my XP Professional PC. When I get to the "Components to install" part, the "SQL server database services option" is greyed out. Infact, all options except "Workstation components..." are greyed out. I've tried uninstalling all previous versions of SQL server and trying again, but with the same results. any help would be much appreciated Simon Tag: custom url not recognized
  - 5
    - Where do I buy SQL Server Management Studio? Hi Jeffery, for the Express Edition the SQL Server Management Studio Express is the full version! What will you do What is the matter you won`t use it ... CU tosc Tag: custom url not recognized
  - 6
    - Sorting a table with numbers and letters I have a field (varchar) in a list that contains numbers and letters. I want to sort this table but I have only two functions that will work to convert the values: Val The Val function sorts the numbers in the string, but the letters are not sorted CStr The CStr function sorts the letters, but the numbers are not sorted How can I sort the numbers and letters Tag: custom url not recognized
  - 7
    - Error with SMO.TransferData() (Exception from HRESULT: 0xC0011008) Thank you for the example, Aaron. However, it did not work. Please note that I cannot connect to the default instance of SQL Server (also note that I only have SQL Express installed). I did try to apply your approach as best I could considering that I need to connect to the User Instance of SQL Express running with my application: Code Snippet Dim srv As Smo.Server Dim source As Smo.Server '*******This is the code to determine the Master Database name, used in original code Dim dbName_Master As String Dim SqlCon_Master As SqlClient.SqlConnection = New SqlClient.SqlConnection( My .Settings.LM_Master_SQLConStr) SqlCon_Master.Open() dbName_Master = SqlCon_Master.Database.ToString() 'This did not help: SqlCon_Master.ChangeDatabase("master") Console.WriteLine( "Master DB Name: " & dbName_Master) '******* Dim srvCon As New ServerConnection(SqlCon_Master) srv = New Smo.Server(srvCon) ''Verify User Instance connection Console.WriteLine( "User Instance Server: " & srv.InstanceName) If srv.Databases.Contains( "MasterDB_Copy" ) Then srv.Databases( "MasterDB_Copy" ).Drop() End If Dim newDB As New Smo.Database(srv, "MasterDB_Copy" ) newDB.Create() 'Create connection to Source DB Dim sourceCon As New ServerConnection(SqlCon_Master) source = New Smo.Server(sourceCon) ''Verify User Instance connection Console.WriteLine( "User Instance Server: " & source.InstanceName) Dim MasterDB As Smo.Database = source.Databases(dbName_Master) Dim xfr As New Smo.Transfer(MasterDB) xfr.CopyAllObjects = True xfr.DropDestinationObjectsFirst = True xfr.CopySchema = True xfr.CopyData = True xfr.DestinationServer = srv.Name xfr.DestinationDatabase = newDB.Name xfr.Options.IncludeIfNotExists = True Try xfr.TransferData() Catch ex As Exception Console.WriteLine( "Error: " & ex.Message) End Try srv = Nothing source = Nothing I still get the same error upon reaching TransferData(). If it means anything to this thread, I am using SMO for Backup and Restore successfully...so some SMO functions are working on my machine. Is there anything else I can try Thanks, AL Tag: custom url not recognized
  - 8
    - Can't uninstall SQL Server 2005 or install .NET 3.0 64bit after installing Office 2007 Well I had no response on the 64bit NET forum so I am posting here !! Windows Automatic Update has just failed to install .NET 3.0 (x64) WAU decided for itself that I needed this update Add Remove Programs reports the following (x64) programs ... .NET Framework 2.0 .NET Framework 2.0 SDK MS SQL SERVER 2005 VS2005 64bit prerequisites VS2005 64bit Remote Debugger MSinfo32 reports OS Name Microsoft(R) Windows(R) Server 2003 Standard x64 Edition Version 5.2.3790 Service Pack 2 Build 3790 Other OS Description R2 OS Manufacturer Microsoft Corporation System Name DEV-1 System Manufacturer Dell Inc. System Model Dell DXC051 System Type x64-based PC Processor EM64T Family 15 Model 6 Stepping 4 GenuineIntel ~3392 Mhz Processor EM64T Family 15 Model 6 Stepping 4 GenuineIntel ~3392 Mhz BIOS Version/Date Dell Inc. A05, 31/03/2006 BTW this is a fresh install because I was completely and utterly unable to uninstall SqlServer2005 which was necessitated by foolishly installing Office 2007 (Office 2003 being no longer available!) Tag: custom url not recognized
  - 9
    - Whats the different between SQL Express & SQL Server 2005? Hi, I'm working in a small company (less than 30 user), we can't buy MSSql Server 2005: Q1: can we use the Express edtion do access our data I mean for commersial purpose.. Q2: dose the Express edition stand to (30 connection) at the same time Q3: can I add users to it Tag: custom url not recognized
  - 10
    - SQL Server Management Studio Express on Vista Home Premium (Error on attaching and detaching .mdf) When you are launching the Management Studio are you right clicking it and choosing to run it as administrator This solved our issues trying to attach/detach databases in SQL 2005. Tag: custom url not recognized
  - 11
    - SUM returns incorrect value in SQL Server Mobile Query ... Bug?? Please mail to pragya dot agarwal at microsoft dot com Thanks Pragya Tag: custom url not recognized
  - 12
    - Blocking in Analysis Services We have a report in Reporting Services that connects to a Cube. The report has 4 input parameters that are also derived from the same cube. If the report is running and another user tries to select the drop downs for the report or runs just the query portion in report designer, the query will not return until the report has finished. It looks like the report is creating some type of wait. Has anyone ran across something like this Tag: custom url not recognized
  - 13
    - converting varchar to int Yes, it is definitely a varchar. You may have to look out for columns in the table that is being used as source to insert/update the value in the table which has a corresponding column of INT datatype. Shyam Tag: custom url not recognized
  - 14
    - Error - The report server cannot decrypt the symmetric key? Excluding snapshots, the actual data is not stored in the report catalog. Yes, you will loose only the data source credentials. You can go to the Report Manager to change them. FSE is about delivering subsribed reports (users can subscribe to reports believe it or not) to a network file share. Tag: custom url not recognized
  - 15
    - 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: custom url not recognized
  - 16
    - 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: custom url not recognized
- Next
  - 1
    - Only able to access Report Manager as Administrator I eventually found out what this was.. It was nothing to do with Windows authentication - as I suspected because the access I granted worked in SSMS, but not via the web interface. It was just that I had to add Browser access for my users via the Report Manager web interface .. on the home page/properties/New Role Assignment .. Once I did that everything worked as I had hoped. A previous installation I carried out didn't require this.. I suspect that all users were granted Browser access by default, which wasn't the case here. Thanks for your interest Chuck! Andy Tag: custom url not recognized
  - 2
    - SQL Agent Roles it is a BUG ( more like a flaw ). We have the same issue. But thanks to your thread, now we'll use the workaround and for the moment create a jobadmin-user and distribute it's credentials to those who are now jobadmin using their windows account. Let's hope sp2 fixes this flaw ! Tag: custom url not recognized
  - 3
    - 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: custom url not recognized
  - 4
    - 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: custom url not recognized
  - 5
    - 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: custom url not recognized
  - 6
    - msdb restore on new server Hi, suggest to refer http://msdn2.microsoft.com/en-us/library/ms190749.aspx and http://msdn2.microsoft.com/en-us/library/ms188274.aspx Tag: custom url not recognized
  - 7
    - Some things about SMO Hey there, I've logged in now with other credentials to SQL Server and the Accepsstop property is now true of the service but it still runs into an exception when service.stop is called. This is the exception: ex.InnerException {"StopService failed for Service 'SQLSERVERAGENT'."} System.Exception Tag: custom url not recognized
  - 8
    - 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: custom url not recognized
  - 9
    - Making Reports Customizeable for Users on a .NET site kcon, It appears that you are doing what we are thinking about. Can you give me a little (just a little) more specific information about what you are doing It is just so we don't have to start from scratch. Or do you know of a website, book, that may give me a little more information about good design when creating this sort of page. Thank you. -Gumbatman Tag: custom url not recognized
  - 10
    - 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: custom url not recognized
  - 11
    - How to deliver a report dynamically based on the dataset with standard edition? I don't know why it won't work if you are executing the call as a local admin on your local machine where SSRS is installed. If not, does it work if you add the the Windows identity the call is going under to the local Administrators group If so, you need grant that user System Admin rights in the Report Manager. Tag: custom url not recognized
  - 12
    - 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: custom url not recognized
  - 13
    - Estimating hardware requirements for a SQL Server 2005 installation 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 Tag: custom url not recognized
  - 14
    - 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: custom url not recognized
  - 15
    - SSAS - Custom Rollup in Snapshot Cube - SQL 2000 vs SQL 2005 Looks like this table is structured for a regular (not parent-child) dimension, but could you describe: how these columns map to the Day/Week/Month/Quarter/Year attributes some sample data for the columns which are mapped to these attributes Attribute relationships defined for Day/Week/Month/Quarter/Year attributes the user hierarchy which is defined for these attributes Tag: custom url not recognized
  - 16
    - 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: custom url not recognized

Jnash

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!

Top

Re: custom url not recognized

Jnash

i fixed it, in order to get it to fill out property i used the .tostring method for the field

Top