I am facing a serious issue is BIDS.
I have configured a Un-Pivot transform, source to unpivot is sort, when I change the source to derived column (one column name is same for both) and try to open Unpivot it gives me unreferenced lineage id (this is correct). Now When I select Delete Unreferenced Lineage Column and select Apply , it works till here. As soon as I select OK, BIDS crashes and closes.
I have a package with numerous data flows in it. (I know - this is not recommended as a best practice.) Anyway, one of the Data Flows just started giving me some trouble. When I opened that particular Data Flow, then BIDS would crash. I tried loading the project again, and opening that Data Flow task, and it just kept crashing. I rebooted - same deal.
The Data Flow was itself very simple. There was an OLE DB Source, and OLE DB Destination, a conditional split, a derived column, a data conversion and a Lookup. Pretty routine stuff. Out of the blue really, and long after I created it - it just starting crashing BIDS when I opened it.
My solution was to copy the Data Flow control flow component and paste it back into the same package. This worked perfectly fine, and didn't see any issues after. So, apparently something in the meta data became corrupt, and caused it to crash.
Anyway, just curious if others have seen this behavior, but also wanted to post this as a solution in case someone else has the same problem.
I need to transform the following layout by hopefully using the pivot transform, but am confused about the editor ......I have a compound primary key that I want to keep intact but then values in the row need to be broken out into their own row.
I need to go from this...
PKcol1 PKcol2 PKcol3 col4 col5 col6 col7
A 2007 1 Y N N N
A 2007 2 Y Y N N
A 2007 3 N N N Y
into this....
A 2007 1 col4 Y
A 2007 1 col5 N
A 2007 1 col6 N
A 2007 1 col7 N
A 2007 2 col4 Y
A 2007 2 col5 Y
A 2007 2 col6 N
A 2007 2 col7 N
A 2007 3 col4 N
A 2007 3 col5 N
A 2007 3 col6 N
A 2007 3 col7 Y
Can I do this using the pivot transform? Any suggestions?
I am trying to find the equivalent to MS Access's TRANSFORM and PIVOT in T-SQL. I've tried using GROUP BY with CUBE, and I can't seem to get the data in the correct format. Can someone help? And please explain things to me like I am an idiot, because I am.
Here is the current table and the desired results that I want.
Current Table
MonthTypeSubtypeTotalTime
1TaskASubA5
1TaskASubB10
1TaskASubC8
1TaskBSubX5
2TaskASubA4
2TaskBSubX5
Desired Result:
TypeSubTypeJanuaryFebruary
TaskASubA54
TaskASubB100
TaskASubC80
TaskBSubX55
Thanks.
Colleen
Hey, did someone try to use the pivot transform?
It's not what you would call easy to configure...
In BOL there is the following section:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/55f5db6e-6777-435f-8a06-b68c129f8437.htm
I have followed the instructions there and I get an error when I try to map the new output column to the pivotkey:
"Output column "Yellow" (69) cannot be mapped to PivotKey input column"
So I mapped the new output column to the column holding the quantity values. This worked.
May this be a bug in BOL?
Further on I got some strange behaviour of the pivot transform:
My input is the following CSV-Flatfile:
sk1;sk2;pk1;qty
A;1;Yellow;2
A;1;Green;1
B;1;Yellow;5
A;2;Blue;3
A;2;Green;9
A;1;Green;5
If I omit the last line, everything is fine.
When passing the file as is into the pivot transform the output is:
SK1 SK2 Yellow Green Blue
A 1 2 1 NULL
B 1 5 NULL NULL
A 2 NULL 9 3
A 1 NULL 5 NULL
As you can see the key a;1 is duplicate. The cols SK1 and SK2 are my primary key of the destination table.
When the input is sorted by the first two colums the pivot transform throws an Error:
Error: 0xC02020CF at Pivot w sort, Pivot [39]: Duplicate pivot key value "Green".
I expected to have a sum over all Green for the key A;1. It seems that I have to use an aggregate which in my opinion should
be obsolete here.
As a conclusion I have to say that this task is far away from perfect but not bad for a start.
Regards
Fridtjof
Hello,
In a SQL statement that uses PIVOT, is it possible to create Custom Column Headers instead of being stuck with using Column Headers based on the data?
Is it possible to join another query to a query that uses TRANSFORM and PIVOT by means of UNION? Does anything special need to happen in this case?
Thanks in Advance,
CCGP
I have to create a report using the below query (query is in MS Access).
Can anyone tell me how to create a Transform Pivot report in SSRS?
TRANSFORM Sum(CD1([CheckAmount]))
AS [The Value]
SELECT "Total
Amount of Checks" AS Type, tblResult.AccountNumber,
tblResult.CheckDate, tblResult.Status, Sum(CD1([CheckAmount]))
AS Total
FROM tblResult
GROUP BY "Total Amount
of Checks ", tblResult.AccountNumber, tblResult.CheckDate,
tblResult.Status
PIVOT IIf(IsNull([statusdate]),"Outstanding",Format([StatusDate],"Short
Date"));
I have a pivot transform that it believe is configured correctly but is not distributing the values accross the columns on the same row. for example.
input:
id seqno codevalue
1 A red
1 B red
2 C blue
2 A green
2 B violet
3 A green
desired output:
id Seq_A Seq_B Seq_C
1 red red null
2 green violet blue
3 green null null
what I am getting:
id Seq_A Seq_B Seq_C
1 red null null
1 null red null
2 green null null
2 null violet null
2 null null blue
3 green null null
I do have the pivot usage for the id column set to 1. I have the pivot usage for seqno column set to 2 and codevalue column set to 3. I have the source column for each of the output columns set to the lineageID of the apprpriate input columns. I have the pivotKey values set for each of the destination columns. A for column Seq_A, B for column Seq_B, C for column Seq_C. All four columns have sortkey positions set; 1 for id, 2 for Seq_A, 3 for Seq_B and 4 for column SEQ_C.
It seems like the id column's pivot usage is not set to 1 like it should but when I check it is 1.
I also have several other pivot transforms in the same data flow and they are working as expected.
I have a suspicion that there is some hidden meta data that is messed up that is over-ridding my settings (just my guess) I have deleted this transform and re-done it several times, checking each configuration value, but still getting the same result.
Need some help or thoughts on making this work.
Thanks
Is there any equivalent for Transform-pivot of MS Access in SQL Server 2005?
I have this query in MS Access that I need to migrate to SQL Server 2005
TRANSFORM Sum(CD1([CheckAmount]))
AS [The Value]
SELECT "Total
Amount of Checks" AS Type, tblResult.AccountNumber,
tblResult.CheckDate, tblResult.Status, Sum(CD1([CheckAmount]))
AS Total
FROM tblResult
GROUP BY "Total Amount
of Checks ", tblResult.AccountNumber, tblResult.CheckDate,
tblResult.Status
PIVOT IIf(IsNull([statusdate]),"Outstanding",Format([StatusDate],"Short
Date"));
I have a Pivot Transform in SSIS (2005) working perfectly, EXCEPT for that the first column of the output (the date) repeats for each of the following columns, which are themselves falling into the correct column, but not on the same line for a particular date as the others. Snipet of result from Data Viewer is:
dbDate site1 site2
1/1/2015 0:00 0.03 NULL
1/2/2015 0:00 0.04 NULL
[code]....
I have a pivot transform that pivots a batch type. After the pivot, each batch type has its own row with null values for the other batch types that were pivoted. I want to group two fields and max() the remaining batch types so that the multiple rows are displayed on one row. I tried using the aggregate transform, but since the batch type field is a string, the max() function fails in the package. Is there another transform or can I use the aggragate transform another way so that the max() will work on a string?
-- Ryan
Hi all,
In MyDatabase, I have a TABLE dbo.LabData created by the following SQLQuery.sql:
USE MyDatabase
GO
CREATE TABLE dbo.LabResults
(SampleID int PRIMARY KEY NOT NULL,
SampleName varchar(25) NOT NULL,
AnalyteName varchar(25) NOT NULL,
Concentration decimal(6.2) NULL)
GO
--Inserting data into a table
INSERT dbo.LabResults (SampleID, SampleName, AnalyteName, Concentration)
VALUES (1, 'MW2', 'Acetone', 1.00)
INSERT €¦ ) VALUES (2, 'MW2', 'Dichloroethene', 1.00)
INSERT €¦ ) VALUES (3, 'MW2', 'Trichloroethene', 20.00)
INSERT €¦ ) VALUES (4, 'MW2', 'Chloroform', 1.00)
INSERT €¦ ) VALUES (5, 'MW2', 'Methylene Chloride', 1.00)
INSERT €¦ ) VALUES (6, 'MW6S', 'Acetone', 1.00)
INSERT €¦ ) VALUES (7, 'MW6S', 'Dichloroethene', 1.00)
INSERT €¦ ) VALUES (8, 'MW6S', 'Trichloroethene', 1.00)
INSERT €¦ ) VALUES (9, 'MW6S', 'Chloroform', 1.00)
INSERT €¦ ) VALUES (10, 'MW6S', 'Methylene Chloride', 1.00)
INSERT €¦ ) VALUES (11, 'MW7', 'Acetone', 1.00)
INSERT €¦ ) VALUES (12, 'MW7', 'Dichloroethene', 1.00)
INSERT €¦ ) VALUES (13, 'MW7', 'Trichloroethene', 1.00)
INSERT €¦ ) VALUES (14, 'MW7', 'Chloroform', 1.00)
INSERT €¦ ) VALUES (15, 'MW7', 'Methylene Chloride', 1.00)
INSERT €¦ ) VALUES (16, 'TripBlank', 'Acetone', 1.00)
INSERT €¦ ) VALUES (17, 'TripBlank', 'Dichloroethene', 1.00)
INSERT €¦ ) VALUES (18, 'TripBlank', 'Trichloroethene', 1.00)
INSERT €¦ ) VALUES (19, 'TripBlank', 'Chloroform', 0.76)
INSERT €¦ ) VALUES (20, 'TripBlank', 'Methylene Chloride', 0.51)
GO
A desired Pivot Table is like:
MW2 MW6S MW7 TripBlank
Acetone 1.00 1.00 1.00 1.00
Dichloroethene 1.00 1.00 1.00 1.00
Trichloroethene 20.00 1.00 1.00 1.00
Chloroform 1.00 1.00 1.00 0.76
Methylene Chloride 1.00 1.00 1.00 0.51
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
I write the following SQLQuery.sql code for creating a Pivot Table from the Table dbo.LabData by using the PIVOT operator:
USE MyDatabase
GO
USE TABLE dbo.LabData
GO
SELECT AnalyteName, [1] AS MW2, AS MW6S, [11] AS MW7, [16] AS TripBlank
FROM
(SELECT SampleName, AnalyteName, Concentration
FROM dbo.LabData) p
PIVOT
(
SUM (Concentration)
FOR AnalyteName IN ([1], , [11], [16])
) AS pvt
ORDER BY SampleName
GO
////////////////////////////////////////////////////////////////////////////////////////////////////////////////
I executed the above-mentioned code and I got the following error messages:
Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'TABLE'.
Msg 207, Level 16, State 1, Line 1
Invalid column name 'AnalyteName'.
I do not know what is wrong in the code statements of my SQLQuery.sql. Please help and advise me how to make it right and work for me.
Thanks in advance,
Scott Chang
I have two data tables:
1) Production data with column headers: Key, Facility, Line, Time, Output
2) Costs data with column headers: Key, Site, Cost Center, Time, Cost
The tables have a common key named obviously as Key. The data looks like this:
Key
Facility
Line
Time
Output
Alpha
I would like to have two pivot tables which I can filter with ONE slicer based on the column Key. The first pivot table shows row labels Facility, Line and column labels Time. Value field is Output. The second pivot table shows row labels Site, Cost Center, and column lables Time. Value field is Cost.How can I do this with Power Pivot? I tried by linking both tables above to a table with unique Keys in PowerPivot and then creating a PivotTable where I would have used the Key from the Keys table.
Can I force the following measure to be visible for all rows in a pivot table?
Sales Special Visibility:=IF(
  HASONEVALUE(dimSalesCompanies[SalesCompany])
  ;IF(
    VALUES(dimSalesCompanies[SalesCompany]) = "Sales"
    ;CALCULATE([Sales];ALL(dimSalesCompanies[SalesCompany]))
    ;[Sales]
  )
  ;BLANK()
)
FYI, I also have other measures as well in the pivot table that I don't want to affect.
I have a simple pivot table (screenshot below) that has two variables on it: one for entry year and another for 6 month time intervals. I have very simple DAX functions that count rows to determine the population N (denominator), the number of records in the time intervals (numerator) and the simple percent of those two numbers.
The problem that I am having is that the function for the population N is not overriding the time interval on the pivot table when I use an ALL function to do so. I use ALL in other very simple pivot tables to do the same thing and it works fine.
The formula for all three are below, but the one that is the issue is the population N formula. Why ALL would not work, any other way to override the time period variable on the pivot table.
Population N (denominator):
=CALCULATE(COUNTROWS(analyticJudConsist),ALL(analyticJudConsist[CurrentTimeInCare1]))
Records in time interval (numerator):
=COUNTROWS(analyticJudConsist)
Percent:
=[countrows]/[denominatorCare]
How can I apply "Min" formula under a "new measure" (calculated field) within a pivot table under Power pivot 2010?Can see that neither does it allow me to apply "min" formula directly "formula box" nor could find any other option.Intent formula: "=Min(1,sum(a:b))" this isn't allowed so all I can do is "=sum(a:b)".
View 3 Replies View RelatedI have simple pivot table (below screenshot with info redacted) that displays a population number ("N" below), this is the denominator, a cumulative numerator number (below "#") and a simple cumulative percent that just divides the numerator by the denominator. It cumulates from top to bottom. The numerator and percent are cumulative using the below functions. There are two problems with the numerator and percent:
1. When there is not a number for the numerator, there is no value displayed for both the numerator and the percent..There should be a zero displayed for both values.
2. When there has been a prior number for the numerator and percent (for a prior month interval) but there is no number for the numerator in the current month interval, the prior month number and percent are not displayed in the current month interval--see the 3rd yellow line, this should display "3" and "16.7%" from the second yellow line.Here is the formula for the numerator:
=CALCULATE(count(s1Perm1[entity_id]),FILTER(ALL(s1Perm1[ExitMonthCategory]),s1Perm1[ExitMonthCategory] <= MAX(s1Perm1[ExitMonthCategory])))
Here is the formula for the percent:
=(CALCULATE(countrows(s1Perm1),FILTER(ALL(s1Perm1[ExitMonthCategory]),s1Perm1[ExitMonthCategory] <= MAX(s1Perm1[ExitMonthCategory]))))/(CALCULATE(COUNTROWS(s1Perm1),ALL(s1Perm1[Exit],s1Perm1[ExitMonthCategory])))
I have data in my Powerpivot window which was generated by a sql query. This data includes a field named 'Cost' and every row shows a value for 'Cost' greater than zero. The problem is that when I display this data in the pivot table all entries for Cost display as $0. At first I thought that maybe Cost was set to a bogus data type (such as 'text) but it is set to ''Decimal Number' so that's not the problem.Â
What is happening and how do I fix it so that my pivot table reflects the values for 'Cost'?
I have a data table that contains budget and actual data by month. Â I use the data to create a pivot that shows actual results next to budgeted results. Â I need a column that shows that variance between those columns. Â I think my issue is that the "Type" field contains actual and Budget. Â I sum on "Type". Â I can't seem to create a sum since those items are in the same field or am I missing something?
Table design
Month|Division|Subdivision|Type|Dept|Rate|Units|Amount
October|DC|Day|Budget|125|10.00|100|1000
October|DC|Day|Actual|125|10.00|110|1100
Output Design
DC
DAY
Actual
Budget
125 AvgOfRate
AvgOfRate
SumOfUnits
SumOfUnits
SumOfAmt
SumOfAmt
How to get a list of values to actually display in correct order in either a slicer or when on an axis on a pivot table?
I currently have the below list and have tried to add a preceding numeric (ex. "1. <=0") or preceding blank space, neither of which is visually great. Is there another way?
<= 0
1 - 6
7 - 12
13 - 18
19 - 24
25 - 30
31 - 36
37 - 42
43 - 48
49 - 54
55 - 60
61 - 66
67 - 72
73 - 78
79 - 84
85 - 90
91 - 96
97 - 102
> 102
I am using excel 2010 and creating pivot table from Power Pivot. I created a pivot table with department slicers. All is good, the problem I am having is whilst in an unfiltered position (ALL) of the slicers (departments) I get 200 pages, now when I click on a given department with say 10 pages, I still get the same 200 pages with the first 10 pages showing the data from the clicked department and 190 blank pages.
All I want is to get a WYSIWYG (What you see is what you get) of what is on the screen as my print, but I am getting extra blank pages right after the data. Â How do I resolve this.
Below are the steps I go thru to printÂ
1. Select slicers in unfiltered position (ALL)
2. Select entire pivot table
3. Select Page layout and select print area.
4. Save
5. Click on Print Preview to preview the print
6. Click on a given department in the slicer and repeat item 5, but this gives me blank pages after the data.
Do I need any other step?Â
I am using the pivot task to to a pivot of YTD-Values and after that I use derived columns to calculate month values and do a unpivot then.
All worked fine, but now I get this error message:
[ytd_pivot [123]] Error: Duplicate pivot key value "6".
The settings in the advanced editor seem to be correct (no duplicate pivot key value) and I am extracting the data from the source sorted by month.
Could it be a problem that I use all pivot columns (month 1 to 12) in the derived colum transformation and they aren´t available at this moment while data extracting is still going on?
any hints?
Cheers
Markus
We have 2 servers when you try to change something in a transfer for sql to a text file, it crashes and kicks you out of enterprise manager. I have seen this before. MS recommends applying sp4 or
MS03-031: Cumulative Security Patch for SQL Server (815495)
This is on a cluster. Has anyone seen this before
When we migrated from SQL 6.5 to 7.0 our users that had DBO privileges moved fine. When we went in and added a new user and tried to give them the same priviledges as the old user, the user looks different and does not have the same priviliges. When the user tries to run the SETUSER stored procedure it tell the user that was newly setup that they do not have the rights to perform the operation. Any help with be greatly appreciated.
View 1 Replies View RelatedWe are network admins at a college, with no database experience at all. We use an Altiris product which uses SQL to maintain a database. Our database is OK, but the transaction log has grown to 24 Gb and has caused a slowdown. When we try to back up the database in preparation for shrinking it to the recommended 100 Mb, the server seems to start the backup but crashes (restarts) after a few minutes. Has the situation got out of hand i.e. with files so big, is our server never going to be able to work with it? Or are we missing something obvious?
Any information on resolving the situation gratefully received, thanks in advance.
Denis
PS
I have a report that runs fine, but as soon as I add a sub-report to it, it crashes.
It makes no sense, there are two lists (One inside another, to group the invoices) which I think may be causing this crash, but all it tells me is
"A error occured during local report processing. A internal error occurred on the report server. See the error log for more details"
Where is this error log, I am running the report from vs2005, not off a report server.
Any help would be appriciated
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">
<ConnectionProperties>
<IntegratedSecurity>true</IntegratedSecurity>
<ConnectString>Data Source=DELL4400SQL;Initial Catalog=SpProductionDB</ConnectString>
<DataProvider>SQL</DataProvider>
</ConnectionProperties>
<rd:DataSourceID>1cde06a1-b276-4548-85bc-8a6a541faa3d</rd:DataSourceID>
</DataSource>
<DataSource Name="SPProduction1">
<DataSourceReference>SPProduction</DataSourceReference>
<rd:DataSourceID>1a5e7133-9291-42e3-a7bf-fb505900eb56</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="rectangle9">
<ReportItems>
<Rectangle Name="rectangle8">
<Left>0.03125in</Left>
<PageBreakAtStart>true</PageBreakAtStart>
<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>0.04167in</Top>
<ZIndex>4</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>0.05521in</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>0.96875in</Top>
<ZIndex>3</ZIndex>
<Width>3.35833in</Width>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>1.60833in</Height>
</Rectangle>
<CustomReportItem Name="customReportItem1">
<Style>
<TextAlign>Center</TextAlign>
<FontFamily>Tahoma</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>6pt</FontSize>
<BackgroundColor>White</BackgroundColor>
<Color>DarkSlateBlue</Color>
</Style>
<Top>1.209in</Top>
<ZIndex>2</ZIndex>
<CustomData>
<DataRowGroupings>
<DataGroupings>
<DataGrouping>
<Static>true</Static>
</DataGrouping>
</DataGroupings>
</DataRowGroupings>
<DataSetName>SpProductionData</DataSetName>
<DataRows>
<DataRow>
<DataCell>
<DataValue>
<Value />
</DataValue>
</DataCell>
</DataRow>
</DataRows>
<DataColumnGroupings>
<DataGroupings>
<DataGrouping>
<Static>true</Static>
</DataGrouping>
</DataGroupings>
</DataColumnGroupings>
</CustomData>
<Height>0.39583in</Height>
<CustomProperties>
<CustomProperty>
<Name>LicenseOwner</Name>
<Value />
</CustomProperty>
<CustomProperty>
<Name>LicenseKey</Name>
<Value />
</CustomProperty>
<CustomProperty>
<Name>AutoSize</Name>
<Value>False</Value>
</CustomProperty>
<CustomProperty>
<Name>BarHeight</Name>
<Value>0.5in</Value>
</CustomProperty>
<CustomProperty>
<Name>BarWidth</Name>
<Value>0.01in</Value>
</CustomProperty>
<CustomProperty>
<Name>BarRatio</Name>
<Value>1</Value>
</CustomProperty>
<CustomProperty>
<Name>Rotate</Name>
<Value>None</Value>
</CustomProperty>
<CustomProperty>
<Name>CodabarStartChar</Name>
<Value>A</Value>
</CustomProperty>
<CustomProperty>
<Name>CodabarStopChar</Name>
<Value>B</Value>
</CustomProperty>
<CustomProperty>
<Name>DisplayStartStopChar</Name>
<Value>True</Value>
</CustomProperty>
<CustomProperty>
<Name>AddChecksum</Name>
<Value>True</Value>
</CustomProperty>
<CustomProperty>
<Name>GuardBar</Name>
<Value>True</Value>
</CustomProperty>
<CustomProperty>
<Name>GuardBarHeight</Name>
<Value>0.55in</Value>
</CustomProperty>
<CustomProperty>
<Name>Code128CharSet</Name>
<Value>Auto</Value>
</CustomProperty>
<CustomProperty>
<Name>PostnetHeightTallBar</Name>
<Value>0.135in</Value>
</CustomProperty>
<CustomProperty>
<Name>PostnetHeightShortBar</Name>
<Value>0.06in</Value>
</CustomProperty>
<CustomProperty>
<Name>PlanetHeightTallBar</Name>
<Value>0.135in</Value>
</CustomProperty>
<CustomProperty>
<Name>PlanetHeightShortBar</Name>
<Value>0.06in</Value>
</CustomProperty>
<CustomProperty>
<Name>Symbology</Name>
<Value>Pdf417</Value>
</CustomProperty>
<CustomProperty>
<Name>QuietZoneWidth</Name>
<Value>0.1in</Value>
</CustomProperty>
<CustomProperty>
<Name>DisplayCode</Name>
<Value>True</Value>
</CustomProperty>
<CustomProperty>
<Name>TopMargin</Name>
<Value>0in</Value>
</CustomProperty>
<CustomProperty>
<Name>BottomMargin</Name>
<Value>0in</Value>
</CustomProperty>
<CustomProperty>
<Name>Code16kMode</Name>
<Value>Mode0</Value>
</CustomProperty>
<CustomProperty>
<Name>Extended</Name>
<Value>False</Value>
</CustomProperty>
<CustomProperty>
<Name>DataMatrixModuleSize</Name>
<Value>0.04in</Value>
</CustomProperty>
<CustomProperty>
<Name>DataMatrixFormat</Name>
<Value>Auto</Value>
</CustomProperty>
<CustomProperty>
<Name>DataMatrixEncoding</Name>
<Value>Auto</Value>
</CustomProperty>
<CustomProperty>
<Name>EanUpcSupplement</Name>
<Value>None</Value>
</CustomProperty>
<CustomProperty>
<Name>EanUpcSupplementCode</Name>
<Value />
</CustomProperty>
<CustomProperty>
<Name>EanUpcSupplementSeparation</Name>
<Value>0.15in</Value>
</CustomProperty>
<CustomProperty>
<Name>EanUpcSupplementTopMargin</Name>
<Value>0.15in</Value>
</CustomProperty>
<CustomProperty>
<Name>UpcESystem</Name>
<Value>System0</Value>
</CustomProperty>
<CustomProperty>
<Name>Pdf417Columns</Name>
<Value>5</Value>
</CustomProperty>
<CustomProperty>
<Name>Pdf417Rows</Name>
<Value>0</Value>
</CustomProperty>
<CustomProperty>
<Name>Pdf417CompactionType</Name>
<Value>Binary</Value>
</CustomProperty>
<CustomProperty>
<Name>Pdf417ErrorCorrectionLevel</Name>
<Value>Level4</Value>
</CustomProperty>
<CustomProperty>
<Name>Code</Name>
<Value>="BarcodeVersion:1.0|Type:3|Category:Invoice|ID:" & Fields!EmployerID.Value &"|FileName:" & Fields!InvoiceGroup.Value</Value>
</CustomProperty>
<CustomProperty>
<Name>AntiAlias</Name>
<Value>True</Value>
</CustomProperty>
<CustomProperty>
<Name>Text</Name>
<Value />
</CustomProperty>
<CustomProperty>
<Name>DisplayChecksum</Name>
<Value>True</Value>
</CustomProperty>
<CustomProperty>
<Name>Pdf417Truncated</Name>
<Value>False</Value>
</CustomProperty>
<CustomProperty>
<Name>DataMatrixProcessTilde</Name>
<Value>False</Value>
</CustomProperty>
<CustomProperty>
<Name>ImageFormat</Name>
<Value>Png</Value>
</CustomProperty>
<CustomProperty>
<Name>FitBarsAreaToSizeWidth</Name>
<Value>3in</Value>
</CustomProperty>
<CustomProperty>
<Name>FitBarsAreaToSizeHeight</Name>
<Value>0.3in</Value>
</CustomProperty>
<CustomProperty>
<Name>BearerBarStyle</Name>
<Value>None</Value>
</CustomProperty>
<CustomProperty>
<Name>BearerBarWidth</Name>
<Value>0.05in</Value>
</CustomProperty>
<CustomProperty>
<Name>DisplayLightMarginIndicator</Name>
<Value>False</Value>
</CustomProperty>
<CustomProperty>
<Name>Dpi</Name>
<Value>300</Value>
</CustomProperty>
<CustomProperty>
<Name>Monochrome</Name>
<Value>False</Value>
</CustomProperty>
<CustomProperty>
<Name>Postal4StateAddStartStopChar</Name>
<Value>True</Value>
</CustomProperty>
<CustomProperty>
<Name>Postal4StateBarsSpacing</Name>
<Value>0.03in</Value>
</CustomProperty>
<CustomProperty>
<Name>Postal4StateTrackerBarHeight</Name>
<Value>0.08in</Value>
</CustomProperty>
<CustomProperty>
<Name>Postal4StateTrackerBarWidth</Name>
<Value>0.02in</Value>
</CustomProperty>
<CustomProperty>
<Name>QRCodeModuleSize</Name>
<Value>0.02in</Value>
</CustomProperty>
<CustomProperty>
<Name>QRCodeErrorCorrectionLevel</Name>
<Value>M</Value>
</CustomProperty>
<CustomProperty>
<Name>QRCodeEncoding</Name>
<Value>Auto</Value>
</CustomProperty>
<CustomProperty>
<Name>QRCodeVersion</Name>
<Value>Auto</Value>
</CustomProperty>
<CustomProperty>
<Name>UspsFimPattern</Name>
<Value>A</Value>
</CustomProperty>
<CustomProperty>
<Name>UspsHorizontalBarsCount</Name>
<Value>10</Value>
</CustomProperty>
<CustomProperty>
<Name>TelepenEncoding</Name>
<Value>Ascii</Value>
</CustomProperty>
<CustomProperty>
<Name>PharmacodeBarsSpacing</Name>
<Value>0.04in</Value>
</CustomProperty>
<CustomProperty>
<Name>PharmacodeThickBarWidth</Name>
<Value>0.06in</Value>
</CustomProperty>
<CustomProperty>
<Name>PharmacodeThinBarWidth</Name>
<Value>0.02in</Value>
</CustomProperty>
<CustomProperty>
<Name>BarColor</Name>
<Value>Black</Value>
</CustomProperty>
<CustomProperty>
<Name>CodeVerticalAlign</Name>
<Value>Bottom</Value>
</CustomProperty>
<CustomProperty>
<Name>CodeAlign</Name>
<Value>Center</Value>
</CustomProperty>
</CustomProperties>
<Type>NeodynamicBarcodeControl</Type>
<Left>4.48437in</Left>
<Width>2.72916in</Width>
</CustomReportItem>
<Rectangle Name="rectangle5">
<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>
<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>2.80209in</Top>
<ZIndex>1</ZIndex>
<Width>7.30208in</Width>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Rectangle>
<Textbox Name="textbox13">
<Left>3.43541in</Left>
<Top>0.90559in</Top>
<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</Value>
</Textbox>
</ReportItems>
<Top>7.83333in</Top>
<ZIndex>4</ZIndex>
<Visibility>
<Hidden>=iif(countrows("Body_MainGroup_Details_Group")> 20,false,true)</Hidden>
</Visibility>
<Width>7.32291in</Width>
<Height>6.15626in</Height>
</Rectangle>
<Rectangle Name="rectangle6">
<Left>0.16146in</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>4</ZI
I am using the DTS wizard to import tables from an AS/400. Some of the tables in the job are quite large and Sql Server either hangs up or completely crashes. My current configuration is WIN NT, SP4.0 SQL Server 7.0 no Service pack. Any suggestions?
View 1 Replies View RelatedHi Folks,
I've jumped over from the sister site xtremevbtalk.com to ask the question:
Has anyone ever seen an issue where when installing MSDE, during the installation the pc reboots of its own accord?
After the MDAC is installed as part of the installation the pc reboots and upon boot up, MSDE is not in the program files directory. Instead it's sitting in the C: root. This occurs for a straight MSDE install or with an Instancename install.
There does exist a Microsoft SQL Server folder in the Program Files but it is incomplete. It's missing the Binn folder. Also, there is no reference to MSDE in the Add/Remove programs tool but ther MSDE service does show up in the Services. However I cannot start these as they are pointing to the correct location.
To date, I have tried removing the instance and installation from the registry. I have turned off all AntiVirus software. I have ensured I am using an Admin user profile. I have tried a blank sa passowrd for the installation. all of this is to no avail.
I am seriously stuck with this now and I am in dire need of a resolution so if anybody has any ideas or has seen this one before, I love some help.
Thanks,
Gb :)
I can open a single connection to the database engine successfully but if I try to open another connection ('New Query' or 'query with current connection') Management Studio just goes away without any errors.
I am utilizing a remote desktop connection to the server but if I open a connection from my desktop through Management Studio I can establish multiple connections (database engine, query, etc...) with no problems. There are no errors in the sql logs, event viewer or windows log.
Has anyone seen this? Any suggestions would be appreciated.
My application uses sqldmo to retrieve the list of sql servers in thenetwork, it works fine in some machines, but it is crashing theapplication in others, no error and no exception, it shuts down theapplication. It fails in the following line:SQLDMO.NameList sqlServers = sqlApp.ListAvailableSQLServers();any ideas?thanksmusachy
View 2 Replies View RelatedI was looking to improve the performance of an ASP.NET application bycreating the an indexed view that could be used instead of some of theroot tables.What I didn't realize is that it would affect any future conenctionsto the root tables.This of course crashed the application on any type of insert, update,or delte from the root tables.Funny thing is when I removed the indexed view -- it didn't help.I tried flipping the offending options to the opposite of way theywere set on the database and the errors wouldn't go away.I ended up restoring the database from before my mess up to fix it.I was hoping that the SQL experts out there might shed some light onmy problem before I try again.
View 1 Replies View RelatedCurrently we have SQL Server running on a single RAID5 array.The data and the logs are all written to this array. We don'thave huge volume of activity, but it is growing. Most activityis from our website that interacts a lot with the database.We have read that it is a good idea to separate the data filesfrom the log files, having each on separate disks (or in thecase of RAID, separate arrays). So, we are considering addinga separate SCSI hard drive, or maybe a RAID 1 system, and havesql server log to that instead.My question is, what happens if that secondary drive or arraycompletely fails. Let's say it melts. Assuming the OS doesn'tcrash (Windows 2003 Server), what will SQL Server 2000 do whenthe drive stops working and it is trying to write its datalogging to it? Will it continue to function and write alertevents? Will it shutdown? If it shuts down, how do we alter itsconfiguration to tell it to use another drive for the logs?Also, what kind of throughput would we need to be doing to seeany kind of benefit to making this change? It is easier tojustify the expense of another disk or RAID setup if it isactually going to matter. ;-)Thanks all!Thomas
View 3 Replies View Related