Accessing more than: group

Showing posts with label group. Show all posts

Sunday, March 25, 2012

adding a filegroup

when you add a filegroup to a existing server on a half full harddrive
does it take longer to add if the file group size is very large likje
over 100 gigs
*** Sent via Developersdex http://www.codecomments.com ***Is the question does it take longer to load a 100 gig database on a 1/2 full
hard drive then an empty one?
I would think that it would take longer depending on the fragmentation of
your hard drive, your speed of your new drives, your bus speed, your RAID
controller, what type of cabling you are using to connect to your RAID, the
list goes on and on...
Please clarify...
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/
"Bill" <nospam@.devdex.com> wrote in message
news:%23THF5$K7GHA.3492@.TK2MSFTNGP06.phx.gbl...
>
> when you add a filegroup to a existing server on a half full harddrive
> does it take longer to add if the file group size is very large likje
> over 100 gigs
> *** Sent via Developersdex http://www.codecomments.com ***|||Mr Bruk:
What I meant was, does it take longer to add a small file group vs a
very large file group, on a drive that already has data on it.
Is adding a file group to a dataset set to a fixed amount of time with
no connection to the size of the filegroup.
In other words does it take longer to add a 100 gig file group vs a 20
gig filegeroup?
Bill
*** Sent via Developersdex http://www.codecomments.com ***|||A filegroup doesn't by itself have any size. It is the database files that b
elongs to a file group
that has size. Yes, adding a larger file will take longer than a small file.
You can test this for
yourself. Create a database with a data file of size 20 MB vs 20GB and you w
ill see this. Note that
in 2005, you have "instant file initialization" but only for database files
(see
http://www.karaszi.com/SQLServer/info_dont_shrink.asp for a few comments on
instant file
initialization and what permission is needed). So in 2005, try both with a l
arge data file and a
large log file to see the difference.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Bill" <nospam@.devdex.com> wrote in message news:%23%23wrYsT7GHA.4552@.TK2MSFTNGP05.phx.gbl..
.
> Mr Bruk:
> What I meant was, does it take longer to add a small file group vs a
> very large file group, on a drive that already has data on it.
> Is adding a file group to a dataset set to a fixed amount of time with
> no connection to the size of the filegroup.
> In other words does it take longer to add a 100 gig file group vs a 20
> gig filegeroup?
>
> Bill
> *** Sent via Developersdex http://www.codecomments.com ***|||this question is straightforward the filegroup is being added due to the
other filegroups being full.
My question is does it take four times longer to add (blank as of yet)a
80gig filegroup vs a 20gig filegroup... At this time there is no data in
there, this is being done to add hd space for more room for additional
data..
Bill
*** Sent via Developersdex http://www.codecomments.com ***|||See my reply from earlier today. Again, a filegroup doesn't have a size, the
files does. Depending
on whether you get instant file initialization is a big factor. If you don't
get instant file
initialization, then you look at create time for a file which proportional t
o the file size (windows
has to zero out the newly allocated hard drive space).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Bill" <nospam@.devdex.com> wrote in message news:O0zUTjW7GHA.3812@.TK2MSFTNGP02.phx.gbl...[vb
col=seagreen]
>
> this question is straightforward the filegroup is being added due to the
> other filegroups being full.
> My question is does it take four times longer to add (blank as of yet)a
> 80gig filegroup vs a 20gig filegroup... At this time there is no data in
> there, this is being done to add hd space for more room for additional
> data..
> Bill
> *** Sent via Developersdex http://www.codecomments.com ***[/vbcol]

adding a filegroup

when you add a filegroup to a existing server on a half full harddrive
does it take longer to add if the file group size is very large likje
over 100 gigs
*** Sent via Developersdex http://www.codecomments.com ***
Is the question does it take longer to load a 100 gig database on a 1/2 full
hard drive then an empty one?
I would think that it would take longer depending on the fragmentation of
your hard drive, your speed of your new drives, your bus speed, your RAID
controller, what type of cabling you are using to connect to your RAID, the
list goes on and on...
Please clarify...
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/
"Bill" <nospam@.devdex.com> wrote in message
news:%23THF5$K7GHA.3492@.TK2MSFTNGP06.phx.gbl...
>
> when you add a filegroup to a existing server on a half full harddrive
> does it take longer to add if the file group size is very large likje
> over 100 gigs
> *** Sent via Developersdex http://www.codecomments.com ***
|||Mr Bruk:
What I meant was, does it take longer to add a small file group vs a
very large file group, on a drive that already has data on it.
Is adding a file group to a dataset set to a fixed amount of time with
no connection to the size of the filegroup.
In other words does it take longer to add a 100 gig file group vs a 20
gig filegeroup?
Bill
*** Sent via Developersdex http://www.codecomments.com ***
|||A filegroup doesn't by itself have any size. It is the database files that belongs to a file group
that has size. Yes, adding a larger file will take longer than a small file. You can test this for
yourself. Create a database with a data file of size 20 MB vs 20GB and you will see this. Note that
in 2005, you have "instant file initialization" but only for database files (see
http://www.karaszi.com/SQLServer/info_dont_shrink.asp for a few comments on instant file
initialization and what permission is needed). So in 2005, try both with a large data file and a
large log file to see the difference.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Bill" <nospam@.devdex.com> wrote in message news:%23%23wrYsT7GHA.4552@.TK2MSFTNGP05.phx.gbl...
> Mr Bruk:
> What I meant was, does it take longer to add a small file group vs a
> very large file group, on a drive that already has data on it.
> Is adding a file group to a dataset set to a fixed amount of time with
> no connection to the size of the filegroup.
> In other words does it take longer to add a 100 gig file group vs a 20
> gig filegeroup?
>
> Bill
> *** Sent via Developersdex http://www.codecomments.com ***
|||this question is straightforward the filegroup is being added due to the
other filegroups being full.
My question is does it take four times longer to add (blank as of yet)a
80gig filegroup vs a 20gig filegroup... At this time there is no data in
there, this is being done to add hd space for more room for additional
data..
Bill
*** Sent via Developersdex http://www.codecomments.com ***
|||See my reply from earlier today. Again, a filegroup doesn't have a size, the files does. Depending
on whether you get instant file initialization is a big factor. If you don't get instant file
initialization, then you look at create time for a file which proportional to the file size (windows
has to zero out the newly allocated hard drive space).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Bill" <nospam@.devdex.com> wrote in message news:O0zUTjW7GHA.3812@.TK2MSFTNGP02.phx.gbl...
>
> this question is straightforward the filegroup is being added due to the
> other filegroups being full.
> My question is does it take four times longer to add (blank as of yet)a
> 80gig filegroup vs a 20gig filegroup... At this time there is no data in
> there, this is being done to add hd space for more room for additional
> data..
> Bill
> *** Sent via Developersdex http://www.codecomments.com ***

adding a filegroup

Adding a Field

Hello Group,
I am adding a field an SQL table. This field will not be used a PK or FK.
It is just another field to hold data.
My question is at the point of saving the field into the table I get a
screen that says "The following tables will be saved to the database...list
of a bunch of tables". What is that? I am not doing anything to the relate
d
tables at all.
RichRich wrote:
> Hello Group,
> I am adding a field an SQL table. This field will not be used a PK or FK.
> It is just another field to hold data.
> My question is at the point of saving the field into the table I get a
> screen that says "The following tables will be saved to the database...li
st
> of a bunch of tables". What is that? I am not doing anything to the rela
ted
> tables at all.
> Rich
Don't modify your tables using Enterprise Manager - script the changes
using ALTER TABLE, then you can see precisely what error you're running
in to.
All of your database objects should be created/altered using DDL
scripts, and those scripts should be stored safely away in a version
control package.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Hello Tracy,
I did not think that it was an error however using a script seems to make
sense. Let me check this.
Rich
"Tracy McKibben" wrote:

> Rich wrote:
> Don't modify your tables using Enterprise Manager - script the changes
> using ALTER TABLE, then you can see precisely what error you're running
> in to.
> All of your database objects should be created/altered using DDL
> scripts, and those scripts should be stored safely away in a version
> control package.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>|||Rich wrote:
> Hello Tracy,
> I did not think that it was an error however using a script seems to make
> sense. Let me check this.
>
Maybe not an "error", so to speak, but still likely to be something more
meaningful than what you get in Enterprise Manager.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Hello Tracy,
I am looking at BOL and do not see anything on adding a field into a
table...I would hate to have to create a new table and then move the data
into the new table...can I just script a new field only?
Rich
"Tracy McKibben" wrote:

> Rich wrote:
> Don't modify your tables using Enterprise Manager - script the changes
> using ALTER TABLE, then you can see precisely what error you're running
> in to.
> All of your database objects should be created/altered using DDL
> scripts, and those scripts should be stored safely away in a version
> control package.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>|||Yes, look in BOL for ALTER TABLE.
Example:
ALTER TABLE MyTable
ADD COLUMN MyNewColumn varchar(25) NOT NULL
Also, those messages in Enterprise Mangler happen because if you change a ta
ble, Enterprise Mangler will re-script all related tables. (Behind the scene
s, I believe, Enterprise Mangler will create a new table, transfer the data,
drop the old table, and the rename the new table. Way too much effort just
to add a column!)
--
Arnie Rowland
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Rich" <Rich@.discussions.microsoft.com> wrote in message news:35D78AC4-EECD-4E31-BCA8-8FC4F8
DE5E21@.microsoft.com...[vbcol=seagreen]
> Hello Tracy,
>
> I am looking at BOL and do not see anything on adding a field into a
> table...I would hate to have to create a new table and then move the data
> into the new table...can I just script a new field only?
>
> Rich
>
> "Tracy McKibben" wrote:
>|||Not quite...
Where you're adding a column, you don't use the word COLUMN. I guess it's so
rt of the default.
ALTER TABLE MyTable
ADD MyNewColumn varchar(25) NOT NULL
--
HTH
Kalen Delaney, SQL Server MVP
"Arnie Rowland" <arnie@.1568.com> wrote in message news:uPXS6xDrGHA.3856@.TK2M
SFTNGP02.phx.gbl...
Yes, look in BOL for ALTER TABLE.
Example:
ALTER TABLE MyTable
ADD COLUMN MyNewColumn varchar(25) NOT NULL
Also, those messages in Enterprise Mangler happen because if you change a ta
ble, Enterprise Mangler will re-script all related tables. (Behind the scene
s, I believe, Enterprise Mangler will create a new table, transfer the data,
drop the old table, and the rename the new table. Way too much effort just
to add a column!)
--
Arnie Rowland
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Rich" <Rich@.discussions.microsoft.com> wrote in message news:35D78AC4-EECD-4E31-BCA8-8FC4F8
DE5E21@.microsoft.com...[vbcol=seagreen]
> Hello Tracy,
>
> I am looking at BOL and do not see anything on adding a field into a
> table...I would hate to have to create a new table and then move the data
> into the new table...can I just script a new field only?
>
> Rich
>
> "Tracy McKibben" wrote:
>|||Oops...

--
Arnie Rowland
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message news:uk0zkY
FrGHA.3604@.TK2MSFTNGP02.phx.gbl...
Not quite...
Where you're adding a column, you don't use the word COLUMN. I guess it's so
rt of the default.
ALTER TABLE MyTable
ADD MyNewColumn varchar(25) NOT NULL
--
HTH
Kalen Delaney, SQL Server MVP
"Arnie Rowland" <arnie@.1568.com> wrote in message news:uPXS6xDrGHA.3856@.TK2M
SFTNGP02.phx.gbl...
Yes, look in BOL for ALTER TABLE.
Example:
ALTER TABLE MyTable
ADD COLUMN MyNewColumn varchar(25) NOT NULL
Also, those messages in Enterprise Mangler happen because if you change a ta
ble, Enterprise Mangler will re-script all related tables. (Behind the scene
s, I believe, Enterprise Mangler will create a new table, transfer the data,
drop the old table, and the rename the new table. Way too much effort just
to add a column!)
--
Arnie Rowland
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Rich" <Rich@.discussions.microsoft.com> wrote in message news:35D78AC4-EECD-4E31-BCA8-8FC4F8
DE5E21@.microsoft.com...[vbcol=seagreen]
> Hello Tracy,
>
> I am looking at BOL and do not see anything on adding a field into a
> table...I would hate to have to create a new table and then move the data
> into the new table...can I just script a new field only?
>
> Rich
>
> "Tracy McKibben" wrote:
>|||"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message news:uk0zkY
FrGHA.3604@.TK2MSFTNGP02.phx.gbl...
Not quite...
Where you're adding a column, you don't use the word COLUMN. I guess it's so
rt of the default.
ALTER TABLE MyTable
ADD MyNewColumn varchar(25) NOT NULL
<<<<<<<<<<<<<<
I always get tripped up on that syntax.
[vbcol=seagreen]
--
HTH
Kalen Delaney, SQL Server MVP
"Arnie Rowland" <arnie@.1568.com> wrote in message news:uPXS6xDrGHA.3856@.TK2M
SFTNGP02.phx.gbl...
Yes, look in BOL for ALTER TABLE.
Example:
ALTER TABLE MyTable
ADD COLUMN MyNewColumn varchar(25) NOT NULL
Also, those messages in Enterprise Mangler happen because if you change a ta
ble, Enterprise Mangler will re-script all related tables. (Behind the scene
s, I believe, Enterprise Mangler will create a new table, transfer the data,
drop the old table, and the rename the new table. Way too much effort just
to add a column!)
--
Arnie Rowland
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Rich" <Rich@.discussions.microsoft.com> wrote in message news:35D78AC4-EECD-4E31-BCA8-8FC4F8
DE5E21@.microsoft.com...[vbcol=seagreen]
> Hello Tracy,
>
> I am looking at BOL and do not see anything on adding a field into a
> table...I would hate to have to create a new table and then move the data
> into the new table...can I just script a new field only?
>
> Rich
>
> "Tracy McKibben" wrote:
>|||I just made that mistake today, that's why I recognized it immediately in th
e post here.
:-)
--
HTH
Kalen Delaney, SQL Server MVP
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:Orbz5lGrGHA.3992@.TK2MSFTNGP04.phx.gbl...
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message news:uk0zkY
FrGHA.3604@.TK2MSFTNGP02.phx.gbl...
Not quite...
Where you're adding a column, you don't use the word COLUMN. I guess it's so
rt of the default.
ALTER TABLE MyTable
ADD MyNewColumn varchar(25) NOT NULL
<<<<<<<<<<<<<<
I always get tripped up on that syntax.
[vbcol=seagreen]
--
HTH
Kalen Delaney, SQL Server MVP
"Arnie Rowland" <arnie@.1568.com> wrote in message news:uPXS6xDrGHA.3856@.TK2M
SFTNGP02.phx.gbl...
Yes, look in BOL for ALTER TABLE.
Example:
ALTER TABLE MyTable
ADD COLUMN MyNewColumn varchar(25) NOT NULL
Also, those messages in Enterprise Mangler happen because if you change a ta
ble, Enterprise Mangler will re-script all related tables. (Behind the scene
s, I believe, Enterprise Mangler will create a new table, transfer the data,
drop the old table, and the rename the new table. Way too much effort just
to add a column!)
--
Arnie Rowland
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Rich" <Rich@.discussions.microsoft.com> wrote in message news:35D78AC4-EECD-4E31-BCA8-8FC4F8
DE5E21@.microsoft.com...[vbcol=seagreen]
> Hello Tracy,
>
> I am looking at BOL and do not see anything on adding a field into a
> table...I would hate to have to create a new table and then move the data
> into the new table...can I just script a new field only?
>
> Rich
>
> "Tracy McKibben" wrote:
>

Thursday, March 22, 2012

Adding a blank line after a group of rows

I have an rdl report that shows rows group by category. I would like to include a blank line after each set of categories. Can anyone point me to how I would do that in the rdl.

thanks

idriss

Hi,

Add a blank Group Footer and increase the height of it as per your requirements.

HTH,
Suprotim Agarwal

--
http://www.dotnetcurry.com
--

Adding a Adam NT group to SQL Server?

Hello all, I 'm not sure if this is the right forum for this, and I apologies if so...

This post has been moved around a couple times so i apologies.

But in a nut shell I'm attempting to grant SQL server access to a ADAM user group account within an ADAM instance.

I have set up the ADAM instance. Added the ADAM user to an ADAM security group. now I need to add that user group to a SQL instance that resides on our AD domain ( non-ADAM instance.) obviously when I attempt to view all available domains within SQL security manager, all I see is our standard domain, I can't seem to figure out how to make the ADAM domain visible to our AD domain.

Any Thoughts?

Thanks

I'll move this post over to the SQL Server Security forum where I think folks will be better equiped to answer your question.

Best of luck-

Cheers,

Adam

|||

Check this duplicate thread.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1741431&SiteID=1

|||

Apparently it was moved to a different forum with no sucess. I was then requested to post within the AD group which again got thrown back in here.. I dont know where i can go to get an answer( does anyone know if there is an ADAM forum?)

Thanks

Adding a Adam NT group to SQL Server?

Hello all, I 'm not sure if this is the right forum for this, and I apologies if so...

This post has been moved around a couple times so i apologies.

But in a nut shell I'm attempting to grant SQL server access to a ADAM user group account within an ADAM instance.

Any Thoughts?

Thanks

I'll move this post over to the SQL Server Security forum where I think folks will be better equiped to answer your question.

Best of luck-

Cheers,

Adam

|||

Check this duplicate thread.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1741431&SiteID=1

|||

Thanks

Adding a Adam group to SQL Server

Hello all, I 'm not sure if this is the right forum for this, and I apologies if so...

But in a nut shell I'm attempting to grant SQL server access to a ADAM user group account within an ADAM instance.

Any Thoughts?

Thanks

Unfortunately I am not familiar with ADAM, and given that there hasn't been any response yet I would assume most people in this forum have limited or no experience on this topic either.

I would suggest asking in the Windows or AD forums and find out if there is a difference in ADAM authetntication with respect of regular ADs.

-Raul Garcia

SDE/T

SQL Server Engine

|||Will do. Thank you.|||

Not possible. ADAM is not a network OS like AD.... ADAM groups aren't available to SQL server ...

what you can do is: If all your users exist in AD and your ADAM is domain joined, create the groups in AD instead and use them in ADAM as well. ADAM can use AD security principals for Authentication and Authorization.

thanks

Adding a Adam group to SQL Server

Hello all, I 'm not sure if this is the right forum for this, and I apologies if so...

But in a nut shell I'm attempting to grant SQL server access to a ADAM user group account within an ADAM instance.

Any Thoughts?

Thanks

Unfortunately I am not familiar with ADAM, and given that there hasn't been any response yet I would assume most people in this forum have limited or no experience on this topic either.

I would suggest asking in the Windows or AD forums and find out if there is a difference in ADAM authetntication with respect of regular ADs.

-Raul Garcia

SDE/T

SQL Server Engine

|||Will do. Thank you.|||

Not possible. ADAM is not a network OS like AD.... ADAM groups aren't available to SQL server ...

thanks

sql

Adding a Adam group to SQL Server

Hello all, I 'm not sure if this is the right forum for this, and I apologies if so...

But in a nut shell I'm attempting to grant SQL server access to a ADAM user group account within an ADAM instance.

Any Thoughts?

Thanks

Unfortunately I am not familiar with ADAM, and given that there hasn't been any response yet I would assume most people in this forum have limited or no experience on this topic either.

I would suggest asking in the Windows or AD forums and find out if there is a difference in ADAM authetntication with respect of regular ADs.

-Raul Garcia

SDE/T

SQL Server Engine

|||Will do. Thank you.|||

Not possible. ADAM is not a network OS like AD.... ADAM groups aren't available to SQL server ...

thanks

Monday, March 19, 2012

Add values of distinct rows

Hello All,

I have a scenario wherein I wanted to add the values of distinct transaction number, how do I do that. i.e.

Financial organisation (GROUP (Company))

12/31/2003 606.60 approved 123 (Transaction Number) (1st Row)

5643577(Wok Report) (2nd Row)

01/05/2004 1000.00 approved 124 (Transaction Number) (to Satisfy $1000 three work reports were raised)

5643500(Wok Report)

5643501(Wok Report)

5643502(Wok Report)

02/05/2004 2000.00 approved 125 (Transaction Number) (to Satisfy $2000 three work reports were raised)

5643300(Wok Report)

5643301(Wok Report)

5643302(Wok Report)

Total 3606.60 (Total per Company group)

I want to add the visible row values only. Because the 1000.00 and 2000.00 was repeating for 01/05/2004 and 02/05/04 I am hinding the repeated values.

Please help me completing the above task.

Thanks,

Deepak Vodethela

Deekpak,

Unfortunatley, from my experiences, this is not possible as of SSRS 2005. I tried to do the same thing recently and I ended up changing my SQL to give me what I wanted.

|||

Thanks for the reply Todd. Can't we write a custom function to do the needful i.e. which has to check for the distict Transaction number and pick up the value and do the sum by group. I am not an expert at SSRS but just curious.

To change my query it will be a very big task. Right now I am joining 11 tables to get the required fields and if I want to add the sum on a group then it'll be a laborious task.

Any help would be appriciated.

Add user to Local Group Error

Guys,

I need help installing SQL Server 2005. I meet all of the pre-req's and setup seems to run normally until it starts installing the services and database engine. I receive the following error:

SQL Server Setup was unable add user NT AUTHORITY\NETWORK SERVICE to local group SQLSERVER2005DTSUser$server.

It repeats the error for for the other groups that are created with SQL install.

Am i missing something that's obvious? I couldn't find anything in the documentation or anywhere else.

Here are a couple of things to try:

1. Check the installation log files, located at %Program Files%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files for more details on the error.

2. Try to add the service manually to the local groups using the Computer Management Admin tool. Then re-run setup.

Paul

add totals to a matrix

Hi,
I've defined a matrix in a report which looks like this:
group by column group by column
Description Data Data
Description Data Data
Now I'd like to add a colum which sums up the Data:
group by column group by column Total
Description Data1 Data2
sum(Data1+Data2)
Description Data3 Data4
sum(Data1+Data2)
The only thing which I found is to add subtotals but this only counts
my first group by column. How can I add a total column?
ThanksOk. I just found out I have to add an aggregate function to my data
fields (in this case summ) and now it works).
Thanks
florian schrieb:
> Hi,
> I've defined a matrix in a report which looks like this:
> group by column group by column
> Description Data Data
> Description Data Data
> Now I'd like to add a colum which sums up the Data:
> group by column group by column Total
> Description Data1 Data2
> sum(Data1+Data2)
> Description Data3 Data4
> sum(Data1+Data2)
> The only thing which I found is to add subtotals but this only counts
> my first group by column. How can I add a total column?
> Thanks

Sunday, March 11, 2012

Add space between matrix row group

I have a 2 row groups in a matrix and I need to add some space between the top one so that all the columns don't run together. Is there a way to do this?

Click on the row that you want to add the space below, go to the properties window and increase your 'Height' value. Also, make sure that the 'VerticalAlign' field is set to 'Top'. This will add empty space between that row and the one directly below it.

Hope this helps.

Jarret

|||I guess I wasn't clear. I dont need space between the rows, but between the last column in a row group and the first column in the next row group. Does that make sense?|||

Click on the last column in the matrix, and in the properties window, increase the Padding-Right value. You might want to increase the Width of that column to handle the additional padding. Does this do what you are trying to accomplish?

Hope this helps.

Jarret

|||

No, padding won't help. Here's my layout. I need more space between the subject areas.

ELA

Math

Science

Social Studies

Below Basic

Basic

Proficient

Advanced

Below Basic

Basic

Proficient

Advanced

Below Basic

Basic

Proficient

Advanced

Below Basic

Basic

Proficient

Advanced

17%

46%

37%

14%

36%

30%

20%

32%

23%

24%

40%

37%

15%

57%

30%

22%

49%

16%

13%

22%

50%

13%

15%

14%

44%

22%

21%

16%

36%

44%

13%

39%

22%

26%

27%

33%

21%

18%

23%

40%

17%

20%

|||That's what it currently looks like. How do you want it to look?|||

So, you are wanting something like a 'spacer' column? What if you add another blank column to you report? Right click your textbox below the 'Advanced' column and select 'Add Column', then just leave it blank.

Jarret

|||

ELA				Math
Below Basic	Basic	Proficient	Advanced	Below Basic	Basic	Proficient	Advanced
17%	46%	37%	1%	14%	36%	30%	20%
9%	57%	30%	4%	22%	49%	16%	13%
16%	36%	44%	4%	13%	39%	22%	26%

See the space I've added between ELA and Math sections? Thats what I want.

|||That adds a second column of data that will repeat. So instead of one column under advanced I have two.|||Would you still want the tables to appear horizontally next to each other? Have you considered placing the matrix in a list control and adding a groupping by subject? This would effectively give you a matrix per subject but they would be layed out vertically.|||I have to lay them out horizontally bc of how many rows there are. If I do it vertically the report gets too long to read.|||Does anybody have a clue how to do this? It seems like it'd be so simple...

Thursday, March 8, 2012

Add new SQL Server in "SQL Server Group"

Hi,
Does anyone know how to add a new SQL Server under the "SQL Server Group"
using Enterprise Manager other than run the setup.exe in MSDE?
Thanks.
Paul
Paul wrote:
> Hi,
> Does anyone know how to add a new SQL Server under the "SQL Server
> Group" using Enterprise Manager other than run the setup.exe in MSDE?
> Thanks.
> Paul
SQL EM does not actually create new instances of SQL Server. It only
"adds" instances of SQL Server that already exist to its UI. To create a
new instance of SQL Server, you need to re-run the SQL Server
installation and apply the necessary service packs. I'm not sure MSDE
supports multiple instances. It might, but I'm not sure.
David Gugick
Imceda Software
www.imceda.com
|||David,
Thanks. MSDE does support multiple instances. I am just trying to find a
better way to add a new instance.
Paul
"David Gugick" wrote:

> Paul wrote:
> SQL EM does not actually create new instances of SQL Server. It only
> "adds" instances of SQL Server that already exist to its UI. To create a
> new instance of SQL Server, you need to re-run the SQL Server
> installation and apply the necessary service packs. I'm not sure MSDE
> supports multiple instances. It might, but I'm not sure.
> --
> David Gugick
> Imceda Software
> www.imceda.com
>
|||To install another instance of SQL Server you must go through setup..
If you merely wish to administer an existing SQL in your SEM, then right
click the server group, and select Register server
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:0B1A4C3B-2FEC-49B6-AF61-3A3F98921FEE@.microsoft.com...
> Hi,
> Does anyone know how to add a new SQL Server under the "SQL Server Group"
> using Enterprise Manager other than run the setup.exe in MSDE?
> Thanks.
> Paul
|||Wayne,
Thanks.
Paul
"Wayne Snyder" wrote:

> To install another instance of SQL Server you must go through setup..
> If you merely wish to administer an existing SQL in your SEM, then right
> click the server group, and select Register server
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:0B1A4C3B-2FEC-49B6-AF61-3A3F98921FEE@.microsoft.com...
>
>
|||No problem
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:7EE2E3E4-10BE-4D72-A0CB-CD1E78ADBE82@.microsoft.com...[vbcol=seagreen]
> Wayne,
> Thanks.
> Paul
> "Wayne Snyder" wrote:
Group"[vbcol=seagreen]

Add new SQL Server in "SQL Server Group"

Hi,
Does anyone know how to add a new SQL Server under the "SQL Server Group"
using Enterprise Manager other than run the setup.exe in MSDE?
Thanks.
PaulPaul wrote:
> Hi,
> Does anyone know how to add a new SQL Server under the "SQL Server
> Group" using Enterprise Manager other than run the setup.exe in MSDE?
> Thanks.
> Paul
SQL EM does not actually create new instances of SQL Server. It only
"adds" instances of SQL Server that already exist to its UI. To create a
new instance of SQL Server, you need to re-run the SQL Server
installation and apply the necessary service packs. I'm not sure MSDE
supports multiple instances. It might, but I'm not sure.
--
David Gugick
Imceda Software
www.imceda.com|||David,
Thanks. MSDE does support multiple instances. I am just trying to find a
better way to add a new instance.
Paul
"David Gugick" wrote:
> Paul wrote:
> > Hi,
> >
> > Does anyone know how to add a new SQL Server under the "SQL Server
> > Group" using Enterprise Manager other than run the setup.exe in MSDE?
> > Thanks.
> >
> > Paul
> SQL EM does not actually create new instances of SQL Server. It only
> "adds" instances of SQL Server that already exist to its UI. To create a
> new instance of SQL Server, you need to re-run the SQL Server
> installation and apply the necessary service packs. I'm not sure MSDE
> supports multiple instances. It might, but I'm not sure.
> --
> David Gugick
> Imceda Software
> www.imceda.com
>|||To install another instance of SQL Server you must go through setup..
If you merely wish to administer an existing SQL in your SEM, then right
click the server group, and select Register server
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:0B1A4C3B-2FEC-49B6-AF61-3A3F98921FEE@.microsoft.com...
> Hi,
> Does anyone know how to add a new SQL Server under the "SQL Server Group"
> using Enterprise Manager other than run the setup.exe in MSDE?
> Thanks.
> Paul|||Wayne,
Thanks.
Paul
"Wayne Snyder" wrote:
> To install another instance of SQL Server you must go through setup..
> If you merely wish to administer an existing SQL in your SEM, then right
> click the server group, and select Register server
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:0B1A4C3B-2FEC-49B6-AF61-3A3F98921FEE@.microsoft.com...
> > Hi,
> >
> > Does anyone know how to add a new SQL Server under the "SQL Server Group"
> > using Enterprise Manager other than run the setup.exe in MSDE?
> > Thanks.
> >
> > Paul
>
>|||No problem
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:7EE2E3E4-10BE-4D72-A0CB-CD1E78ADBE82@.microsoft.com...
> Wayne,
> Thanks.
> Paul
> "Wayne Snyder" wrote:
> > To install another instance of SQL Server you must go through setup..
> >
> > If you merely wish to administer an existing SQL in your SEM, then right
> > click the server group, and select Register server
> >
> > --
> > Wayne Snyder, MCDBA, SQL Server MVP
> > Mariner, Charlotte, NC
> > www.mariner-usa.com
> > (Please respond only to the newsgroups.)
> >
> > I support the Professional Association of SQL Server (PASS) and it's
> > community of SQL Server professionals.
> > www.sqlpass.org
> >
> > "Paul" <Paul@.discussions.microsoft.com> wrote in message
> > news:0B1A4C3B-2FEC-49B6-AF61-3A3F98921FEE@.microsoft.com...
> > > Hi,
> > >
> > > Does anyone know how to add a new SQL Server under the "SQL Server
Group"
> > > using Enterprise Manager other than run the setup.exe in MSDE?
> > > Thanks.
> > >
> > > Paul
> >
> >
> >

Add new SQL Server in "SQL Server Group"

Hi,
Does anyone know how to add a new SQL Server under the "SQL Server Group"
using Enterprise Manager other than run the setup.exe in MSDE?
Thanks.
PaulPaul wrote:
> Hi,
> Does anyone know how to add a new SQL Server under the "SQL Server
> Group" using Enterprise Manager other than run the setup.exe in MSDE?
> Thanks.
> Paul
SQL EM does not actually create new instances of SQL Server. It only
"adds" instances of SQL Server that already exist to its UI. To create a
new instance of SQL Server, you need to re-run the SQL Server
installation and apply the necessary service packs. I'm not sure MSDE
supports multiple instances. It might, but I'm not sure.
David Gugick
Imceda Software
www.imceda.com|||David,
Thanks. MSDE does support multiple instances. I am just trying to find a
better way to add a new instance.
Paul
"David Gugick" wrote:

> Paul wrote:
> SQL EM does not actually create new instances of SQL Server. It only
> "adds" instances of SQL Server that already exist to its UI. To create a
> new instance of SQL Server, you need to re-run the SQL Server
> installation and apply the necessary service packs. I'm not sure MSDE
> supports multiple instances. It might, but I'm not sure.
> --
> David Gugick
> Imceda Software
> www.imceda.com
>|||To install another instance of SQL Server you must go through setup..
If you merely wish to administer an existing SQL in your SEM, then right
click the server group, and select Register server
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:0B1A4C3B-2FEC-49B6-AF61-3A3F98921FEE@.microsoft.com...
> Hi,
> Does anyone know how to add a new SQL Server under the "SQL Server Group"
> using Enterprise Manager other than run the setup.exe in MSDE?
> Thanks.
> Paul|||Wayne,
Thanks.
Paul
"Wayne Snyder" wrote:

> To install another instance of SQL Server you must go through setup..
> If you merely wish to administer an existing SQL in your SEM, then right
> click the server group, and select Register server
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:0B1A4C3B-2FEC-49B6-AF61-3A3F98921FEE@.microsoft.com...
>
>|||No problem
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:7EE2E3E4-10BE-4D72-A0CB-CD1E78ADBE82@.microsoft.com...[vbcol=seagreen]
> Wayne,
> Thanks.
> Paul
> "Wayne Snyder" wrote:
>
Group"[vbcol=seagreen]

Tuesday, March 6, 2012

Add Line for Series Group Total to chart

Have trend chart with lines for monthly costs for individual assets. I need
to add another line for the total each month. When I add a new Value to sum
the costs, I get duplicate lines on the chart. What am I doing wrong?
TIA
DeanIn your new Value set the following value:
= sum(Fields!Yourfield.Value, "DATASETNAME")
Hope this helps.
"Dean" <deanl144@.hotmail.com.nospam> escribió en el mensaje
news:uv2uapZEIHA.3548@.TK2MSFTNGP06.phx.gbl...
> Have trend chart with lines for monthly costs for individual assets. I
> need to add another line for the total each month. When I add a new Value
> to sum the costs, I get duplicate lines on the chart. What am I doing
> wrong?
> TIA
> Dean
>

Saturday, February 25, 2012

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]

try to remove padding for all the fields and can grow must be false for non numerical fields.make these two changes and put that above mentioned text box in different places and see the result.and try to put rectangles inside list and text boxes inside the table

|||Can the cangrow option make a differance if the textbox is hidden? I will try this tomorrow, but everything I have tried thus far still causes that first page to show up blank if I have "ANY" objects on it, not just textboxs.|||I was able to resolve this by using the rowcount function, and just specifying the previous list as the scope to count.

Sunday, March 25, 2012

adding a filegroup

adding a filegroup

adding a filegroup

Adding a Field

Thursday, March 22, 2012

Adding a blank line after a group of rows

Adding a Adam NT group to SQL Server?

Adding a Adam NT group to SQL Server?

Adding a Adam group to SQL Server

Adding a Adam group to SQL Server

Adding a Adam group to SQL Server

Monday, March 19, 2012

Add values of distinct rows

Add user to Local Group Error

add totals to a matrix

Sunday, March 11, 2012

Add space between matrix row group

Thursday, March 8, 2012

Add new SQL Server in "SQL Server Group"

Add new SQL Server in "SQL Server Group"

Add new SQL Server in "SQL Server Group"

Tuesday, March 6, 2012

Add Line for Series Group Total to chart

Saturday, February 25, 2012

Add hidden field to report

Accessing more than

Blog Archive

About Me