March 26, 2010 at 3:13 am
I'm not sure I've posted in the correct area. Apologies if I have...
I have this code below that when I connect to a database, only looks back 7 days, I have written it to look back 10 days but unsure why it only looks back the 7 days...
How can I make it look back more than the 7 days?
<?xml version="1.0" encoding="utf-8"?>
<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition">
<DataSources>
<DataSource Name="master">
<DataSourceReference>master</DataSourceReference>
<rd:DataSourceID>ff51fa07-a7d3-4da4-8f4b-b117c765456a</rd:DataSourceID>
</DataSource>
</DataSources>
<DataSets>
<DataSet Name="RightPane04">
<Fields>
<Field Name="timestamp">
<DataField>timestamp</DataField>
<rd:TypeName>System.DateTime</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>master</DataSourceName>
<CommandText>begin try
select getdate() as timestamp
end try
begin catch
select null as timestamp
end catch</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
<DataSet Name="RightPane">
<Fields>
<Field Name="difference">
<DataField>difference</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="date">
<DataField>date</DataField>
<rd:TypeName>System.DateTime</rd:TypeName>
</Field>
<Field Name="obj_type_desc">
<DataField>obj_type_desc</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="obj_name">
<DataField>obj_name</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="database_name">
<DataField>database_name</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="start_time">
<DataField>start_time</DataField>
<rd:TypeName>System.DateTime</rd:TypeName>
</Field>
<Field Name="event_class">
<DataField>event_class</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="event_subclass">
<DataField>event_subclass</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="object_type">
<DataField>object_type</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="server_name">
<DataField>server_name</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="login_name">
<DataField>login_name</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="application_name">
<DataField>application_name</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="ddl_operation">
<DataField>ddl_operation</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>master</DataSourceName>
<CommandText>begin try
declare @enable int
select top 1 @enable = convert(int,value_in_use) from sys.configurations where name = 'default trace enabled'
if @enable = 1 --default trace is enabled
begin
declare @d1 datetime;
declare @diff int;
declare @curr_tracefilename varchar(500);
declare @base_tracefilename varchar(500);
declare @indx int ;
declare @temp_trace table (
obj_name nvarchar(256) collate database_default
, database_name nvarchar(256) collate database_default
, start_time datetime
, event_class int
, event_subclass int
, object_type int
, server_name nvarchar(256) collate database_default
, login_name nvarchar(256) collate database_default
, application_name nvarchar(256) collate database_default
, ddl_operation nvarchar(40) collate database_default
);
select @curr_tracefilename = path from sys.traces where is_default = 1 ;
set @curr_tracefilename = reverse(@curr_tracefilename)
select @indx = PATINDEX('%\%', @curr_tracefilename)
set @curr_tracefilename = reverse(@curr_tracefilename)
set @base_tracefilename = LEFT( @curr_tracefilename,len(@curr_tracefilename) - @indx) + '\log.trc';
insert into @temp_trace
select ObjectName
, DatabaseName
, StartTime
, EventClass
, EventSubClass
, ObjectType
, ServerName
, LoginName
, ApplicationName
, 'temp'
from ::fn_trace_gettable( @base_tracefilename, default )
where EventClass in (46,47,164) and EventSubclass = 0 and DatabaseID <> 2
update @temp_trace set ddl_operation = 'CREATE' where event_class = 46
update @temp_trace set ddl_operation = 'DROP' where event_class = 47
update @temp_trace set ddl_operation = 'ALTER' where event_class = 164
select @d1 = min(start_time) from @temp_trace
set @diff= datediff(hh,@d1,getdate())
set @diff=@diff/24;
select @diff as difference
, @d1 as date
, object_type as obj_type_desc
, *
from @temp_trace where object_type not in (21587)
order by start_time desc
end
else
begin
select top 0 1 as difference, 1 as date, 1 as obj_type_desc, 1 as obj_name, 1 as dadabase_name, 1 as start_time, 1 as event_class, 1 as event_subclass, 1 as object_type, 1 as server_name, 1 as login_name, 1 as application_name, 1 as ddl_operation
end
end try
begin catch
select -100 as difference
, ERROR_NUMBER() as date
, ERROR_SEVERITY() as obj_type_desc
, ERROR_STATE() as obj_name
, ERROR_MESSAGE() as database_name
, 1 as start_time, 1 as event_class, 1 as event_subclass, 1 as object_type, 1 as server_name, 1 as login_name, 1 as application_name, 1 as ddl_operation
end catch</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
<DataSet Name="RightPane03">
<Fields>
<Field Name="trace_enabled">
<DataField>trace_enabled</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>master</DataSourceName>
<CommandText>begin try
select top 1 convert(int,value_in_use) trace_enabled from sys.configurations where name = 'default trace enabled'
end try
begin catch
select 0 as trace_enabled
end catch</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
<DataSet Name="RightPane01">
<Fields>
<Field Name="l1">
<DataField>l1</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="db_name">
<DataField>db_name</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="ob_name">
<DataField>ob_name</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="type">
<DataField>type</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="date">
<DataField>date</DataField>
<rd:TypeName>System.DateTime</rd:TypeName>
</Field>
<Field Name="s_name">
<DataField>s_name</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>master</DataSourceName>
<CommandText>begin try
declare @enable int;
select top 1 @enable = convert(int,value_in_use) from sys.configurations where name = 'default trace enabled'
if @enable = 0 --default trace is not enabled
begin
declare @db_name table (
row_no int identity
, name sysname
);
declare @objects table (
db_name sysname
, ob_name sysname
, type nvarchar(60)
, date datetime
, s_name sysname
);
declare @cnt int;
declare @name sysname;
insert into @db_name
select name from sys.databases where database_id <> 2 order by name desc;
select @cnt = count(*) from @db_name;
while @cnt > 0
begin
select @name = name from @db_name where row_no = @cnt;
insert into @objects
exec('use ['+@name+']; SELECT '''+@name+''' as db_name,o.name as object_name,o.type_desc, o.create_date, s.name as schema_name from sys.all_objects o left outer join sys.schemas s
on (o.schema_id = s.schema_id) where create_date > ( GETDATE() -10);')
set @cnt = @cnt-1;
end
select 1 as l1
, *
from @objects
order by date desc, db_name, s_name, ob_name
end
else
begin
select top 0 1 as l1, 1 as db_name,1 as ob_name, 1 as type, -1 as date, 1 as s_name
end
end try
begin catch
select -100 as l1
, ERROR_NUMBER() as db_name
, ERROR_SEVERITY() as ob_name
, ERROR_STATE() as type
, ERROR_MESSAGE() as date
, 1 as s_name
end catch</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
<DataSet Name="RightPane02">
<Fields>
<Field Name="l1">
<DataField>l1</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="db_name">
<DataField>db_name</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="ob_name">
<DataField>ob_name</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="type">
<DataField>type</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="date">
<DataField>date</DataField>
<rd:TypeName>System.DateTime</rd:TypeName>
</Field>
<Field Name="s_name">
<DataField>s_name</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>master</DataSourceName>
<CommandText>begin try
declare @enable int;
select top 1 @enable = convert(int,value_in_use) from sys.configurations where name = 'default trace enabled'
if @enable = 0 --default trace is not enabled
begin
declare @db_name table (
row_no int identity
, name sysname
);
declare @objects table (
db_name sysname
, ob_name sysname
, type nvarchar(60)
, date datetime
, s_name sysname
);
declare @cnt int;
declare @name sysname;
insert into @db_name
select name from sys.databases where database_id <> 2 order by name desc;
select @cnt = count(*) from @db_name;
while @cnt > 0
begin
select @name = name from @db_name where row_no = @cnt;
insert into @objects
exec('use ['+@name+']; SELECT '''+@name+''' as db_name,o.name as object_name,o.type_desc, o.modify_date, s.name as schema_name from sys.all_objects o left outer join sys.schemas s
on (o.schema_id = s.schema_id) where modify_date > ( GETDATE() -10);')
set @cnt = @cnt-1;
end
select 1 as l1
, *
from @objects
order by date desc, db_name, s_name, ob_name
end
else
begin
select top 0 1 as l1, 1 as db_name, 1 as ob_name, -1 as type, 1 as date, 1 as s_name
end
end try
begin catch
select -100 as l1
, ERROR_NUMBER() as db_name
, ERROR_SEVERITY() as ob_name
, ERROR_STATE() as type
, ERROR_MESSAGE() as date
, 1 as s_name
end catch</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
</DataSets>
<Body>
<ReportItems>
<Textbox Name="textbox29">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=First(Fields!date.Value, "RightPane01")</Value>
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
<Color>Red</Color>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Top>1.65in</Top>
<Left>0.3in</Left>
<Height>0.2in</Height>
<Width>7.4in</Width>
<Visibility>
<Hidden>=IIF(First(Fields!trace_enabled.Value, "RightPane03") =1, True,IIF(Count(Fields!db_name.Value, "RightPane01"
) =0 ,True,IIF(First(Fields!l1.Value,"RightPane01") = -100, False, True )))</Hidden>
</Visibility>
<DataElementOutput>NoOutput</DataElementOutput>
<Style>
<BackgroundColor>White</BackgroundColor>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Tablix Name="table2">
<TablixBody>
<TablixColumns>
<TablixColumn>
<Width>1.75in</Width>
</TablixColumn>
<TablixColumn>
<Width>1.75in</Width>
</TablixColumn>
<TablixColumn>
<Width>1.6in</Width>
</TablixColumn>
<TablixColumn>
<Width>1.75in</Width>
</TablixColumn>
</TablixColumns>
<TablixRows>
<TablixRow>
<Height>0.2in</Height>
<TablixCells>
<TablixCell>
<CellContents>
<Textbox Name="textbox13">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Database Name</Value>
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
<FontWeight>Bold</FontWeight>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Left</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<rd:DefaultName>textbox13</rd:DefaultName>
<ZIndex>7</ZIndex>
<Style>
<Border>
<Color>DarkGray</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>LightGrey</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="textbox31">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Object Name</Value>
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
<FontWeight>Bold</FontWeight>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Left</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<rd:DefaultName>textbox31</rd:DefaultName>
<ZIndex>6</ZIndex>
<Style>
<Border>
<Color>DarkGray</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>LightGrey</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="textbox32">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Type</Value>
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
<FontWeight>Bold</FontWeight>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Left</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<rd:DefaultName>textbox32</rd:DefaultName>
<ZIndex>5</ZIndex>
<Style>
<Border>
<Color>DarkGray</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>LightGrey</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="textbox33">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Created</Value>
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
<FontWeight>Bold</FontWeight>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Left</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<rd:DefaultName>textbox33</rd:DefaultName>
<ZIndex>4</ZIndex>
<Style>
<Border>
<Color>DarkGray</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>LightGrey</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
</TablixCells>
</TablixRow>
<TablixRow>
<Height>0.2in</Height>
<TablixCells>
<TablixCell>
<CellContents>
<Textbox Name="textbox39">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!db_name.Value</Value>
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Left</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<ZIndex>3</ZIndex>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>= IIF((RowNumber(Nothing) Mod 2)=0
,"WhiteSmoke","White")</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="name">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value />
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Left</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<rd:DefaultName>name</rd:DefaultName>
<ZIndex>2</ZIndex>
<Style>
<Border>
<Color>#d7dae3</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>= IIF((RowNumber(Nothing) Mod 2)=0
,"WhiteSmoke","White")</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="type_desc">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!type.Value</Value>
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Left</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<rd:DefaultName>type_desc</rd:DefaultName>
<ZIndex>1</ZIndex>
<Style>
<Border>
<Color>#d7dae3</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>= IIF((RowNumber(Nothing) Mod 2)=0
,"WhiteSmoke","White")</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="date">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!date.Value</Value>
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Left</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<rd:DefaultName>date</rd:DefaultName>
<Style>
<Border>
<Color>#d7dae3</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>= IIF((RowNumber(Nothing) Mod 2)=0
,"WhiteSmoke","White")</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
</TablixCells>
</TablixRow>
</TablixRows>
</TablixBody>
<TablixColumnHierarchy>
<TablixMembers>
<TablixMember />
<TablixMember />
<TablixMember />
<TablixMember />
</TablixMembers>
</TablixColumnHierarchy>
<TablixRowHierarchy>
<TablixMembers>
<TablixMember>
<KeepWithGroup>After</KeepWithGroup>
<KeepTogether>true</KeepTogether>
</TablixMember>
<TablixMember>
<Group Name="table2_Details_Group">
<DataElementName>Detail</DataElementName>
</Group>
<TablixMembers>
<TablixMember />
</TablixMembers>
<DataElementName>Detail_Collection</DataElementName>
<DataElementOutput>Output</DataElementOutput>
<KeepTogether>true</KeepTogether>
</TablixMember>
</TablixMembers>
</TablixRowHierarchy>
<DataSetName>RightPane01</DataSetName>
<Top>1.3in</Top>
<Left>0.2in</Left>
<Height>0.4in</Height>
<Width>6.85in</Width>
<ZIndex>1</ZIndex>
<Visibility>
<Hidden>true</Hidden>
<ToggleItem>textbox16</ToggleItem>
</Visibility>
<Style>
<Border>
<Color>DarkGray</Color>
<Style>Solid</Style>
</Border>
</Style>
</Tablix>
<Textbox Name="textbox36">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=First(Fields!type.Value, "RightPane02")</Value>
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
<Color>Red</Color>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Top>2.65in</Top>
<Left>0.3in</Left>
<Height>0.2in</Height>
<Width>7.4in</Width>
<ZIndex>2</ZIndex>
<Visibility>
<Hidden>=IIF(First(Fields!trace_enabled.Value, "RightPane03") =1, True,IIF(Count(Fields!db_name.Value, "RightPane02"
) =0 ,True, IIF(First(Fields!l1.Value, "RightPane02") = -100 , False, True )))</Hidden>
</Visibility>
<DataElementOutput>NoOutput</DataElementOutput>
<Style>
<BackgroundColor>White</BackgroundColor>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox38">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value />
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
<Color>Red</Color>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Top>2.45in</Top>
<Left>0.3in</Left>
<Height>0.2in</Height>
<Width>7.4in</Width>
<ZIndex>3</ZIndex>
<Visibility>
<Hidden>=IIF(First(Fields!trace_enabled.Value, "RightPane03") =1, True,IIF(Count(Fields!db_name.Value, "RightPane02"
) =0 ,True, IIF(First(Fields!l1.Value, "RightPane02") = -100 , False, True )))</Hidden>
</Visibility>
<DataElementOutput>NoOutput</DataElementOutput>
<Style>
<BackgroundColor>White</BackgroundColor>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox12">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>No objects were modified in last 7 days.</Value>
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Top>2.25in</Top>
<Left>0.3in</Left>
<Height>0.19792in</Height>
<Width>6.45in</Width>
<ZIndex>4</ZIndex>
<Visibility>
<Hidden>=IIF(First(Fields!trace_enabled.Value, "RightPane03") =1, True,IIF(Count(Fields!db_name.Value, "RightPane02"
) =0 , False, True))</Hidden>
</Visibility>
<DataElementOutput>NoOutput</DataElementOutput>
<Style>
<BackgroundColor>White</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox42">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Unable to retrieve data for this section of the report. Following error occurred.</Value>
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
<Color>Red</Color>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Top>2.25in</Top>
<Left>0.3in</Left>
<Height>0.2in</Height>
<Width>7.4in</Width>
<ZIndex>5</ZIndex>
<Visibility>
<Hidden>=IIF(First(Fields!trace_enabled.Value, "RightPane03") =1, True,IIF(Count(Fields!db_name.Value, "RightPane02"
) =0 ,True, IIF(First(Fields!l1.Value, "RightPane02") = -100 , False, True )))</Hidden>
</Visibility>
<DataElementOutput>NoOutput</DataElementOutput>
<Style>
<BackgroundColor>White</BackgroundColor>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Tablix Name="table3">
<TablixBody>
<TablixColumns>
<TablixColumn>
<Width>1.75in</Width>
</TablixColumn>
<TablixColumn>
<Width>3in</Width>
</TablixColumn>
<TablixColumn>
<Width>1.6in</Width>
</TablixColumn>
<TablixColumn>
<Width>1.75in</Width>
</TablixColumn>
</TablixColumns>
<TablixRows>
<TablixRow>
<Height>0.2in</Height>
<TablixCells>
<TablixCell>
<CellContents>
<Textbox Name="textbox27">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Database Name</Value>
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
<FontWeight>Bold</FontWeight>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Left</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<ZIndex>7</ZIndex>
<Style>
<Border>
<Color>DarkGray</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>LightGrey</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="textbox7">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Object Name</Value>
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
<FontWeight>Bold</FontWeight>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Left</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<rd:DefaultName>textbox7</rd:DefaultName>
<ZIndex>6</ZIndex>
<Style>
<Border>
<Color>DarkGray</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>LightGrey</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="textbox8">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Type</Value>
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
<FontWeight>Bold</FontWeight>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Left</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<rd:DefaultName>textbox8</rd:DefaultName>
<ZIndex>5</ZIndex>
<Style>
<Border>
<Color>DarkGray</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>LightGrey</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="textbox14">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Modified</Value>
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
<FontWeight>Bold</FontWeight>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Left</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<rd:DefaultName>textbox14</rd:DefaultName>
<ZIndex>4</ZIndex>
<Style>
<Border>
<Color>DarkGray</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>LightGrey</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
</TablixCells>
</TablixRow>
<TablixRow>
<Height>0.2in</Height>
<TablixCells>
<TablixCell>
<CellContents>
<Textbox Name="textbox37">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!db_name.Value</Value>
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Left</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<ZIndex>3</ZIndex>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>= IIF((RowNumber(Nothing) Mod 2)=0
,"WhiteSmoke","White")</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="textbox20">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value />
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Left</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<ZIndex>2</ZIndex>
<Style>
<Border>
<Color>#d7dae3</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>= IIF((RowNumber(Nothing) Mod 2)=0
,"WhiteSmoke","White")</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="textbox21">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!type.Value</Value>
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Left</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<ZIndex>1</ZIndex>
<Style>
<Border>
<Color>#d7dae3</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>= IIF((RowNumber(Nothing) Mod 2)=0
,"WhiteSmoke","White")</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="textbox24">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!date.Value</Value>
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Left</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<Style>
<Border>
<Color>#d7dae3</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>= IIF((RowNumber(Nothing) Mod 2)=0
,"WhiteSmoke","White")</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
</TablixCells>
</TablixRow>
</TablixRows>
</TablixBody>
<TablixColumnHierarchy>
<TablixMembers>
<TablixMember />
<TablixMember />
<TablixMember />
<TablixMember />
</TablixMembers>
</TablixColumnHierarchy>
<TablixRowHierarchy>
<TablixMembers>
<TablixMember>
<KeepWithGroup>After</KeepWithGroup>
<KeepTogether>true</KeepTogether>
</TablixMember>
<TablixMember>
<Group Name="table3_Details_Group">
<DataElementName>Detail</DataElementName>
</Group>
<TablixMembers>
<TablixMember />
</TablixMembers>
<DataElementName>Detail_Collection</DataElementName>
<DataElementOutput>Output</DataElementOutput>
<KeepTogether>true</KeepTogether>
</TablixMember>
</TablixMembers>
</TablixRowHierarchy>
<DataSetName>RightPane02</DataSetName>
<Top>2.25in</Top>
<Left>0.2in</Left>
<Height>0.4in</Height>
<Width>8.1in</Width>
<ZIndex>6</ZIndex>
<Visibility>
<Hidden>true</Hidden>
<ToggleItem>textbox17</ToggleItem>
</Visibility>
<Style>
<Border>
<Color>DarkGray</Color>
<Style>Solid</Style>
</Border>
</Style>
</Tablix>
<Textbox Name="textbox19">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=First(Fields!database_name.Value, "RightPane")</Value>
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
<Color>Red</Color>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Top>1.95in</Top>
<Left>0.35in</Left>
<Height>0.2in</Height>
<Width>7.4in</Width>
<ZIndex>7</ZIndex>
<Visibility>
<Hidden>=IIF(First(Fields!trace_enabled.Value, "RightPane03") =1,IIF(Count( Fields!difference.Value,"RightPane" ) =0, True, IIF(First(Fields!difference.Value, "RightPane" ) = -100, False, True)), True)</Hidden>
</Visibility>
<DataElementOutput>NoOutput</DataElementOutput>
<Style>
<BackgroundColor>White</BackgroundColor>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox17">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Objects Modified In Last 7 Days</Value>
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
<FontWeight>Bold</FontWeight>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Top>2in</Top>
<Left>0.2in</Left>
<Height>0.2in</Height>
<Width>6.85in</Width>
<ZIndex>8</ZIndex>
<Visibility>
<Hidden>=IIF(First(Fields!trace_enabled.Value, "RightPane03") =1, True,IIF(Count(Fields!db_name.Value, "RightPane02"
) =0 ,True, IIF(First(Fields!l1.Value, "RightPane02") = -100 , True, False)))</Hidden>
</Visibility>
<DataElementOutput>NoOutput</DataElementOutput>
<Style>
<BackgroundColor>White</BackgroundColor>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox50">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value />
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
<Color>Red</Color>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Top>1.75in</Top>
<Left>0.35in</Left>
<Height>0.2in</Height>
<Width>7.4in</Width>
<ZIndex>9</ZIndex>
<Visibility>
<Hidden>=IIF(First(Fields!trace_enabled.Value, "RightPane03") =1,IIF(Count( Fields!difference.Value,"RightPane" ) =0, True, IIF(First(Fields!difference.Value, "RightPane" ) = -100, False, True)), True)</Hidden>
</Visibility>
<DataElementOutput>NoOutput</DataElementOutput>
<Style>
<BackgroundColor>White</BackgroundColor>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox41">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Unable to retrieve data for this section of the report. Following error occurred.</Value>
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
<Color>Red</Color>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Top>1.55in</Top>
<Left>0.35in</Left>
<Height>0.2in</Height>
<Width>7.4in</Width>
<ZIndex>10</ZIndex>
<Visibility>
<Hidden>=IIF(First(Fields!trace_enabled.Value, "RightPane03") =1,IIF(Count( Fields!difference.Value,"RightPane" ) =0, True, IIF(First(Fields!difference.Value, "RightPane" ) = -100, False, True)), True)</Hidden>
</Visibility>
<DataElementOutput>NoOutput</DataElementOutput>
<Style>
<BackgroundColor>White</BackgroundColor>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox40">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value />
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
<Color>Red</Color>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Top>1.45in</Top>
<Left>0.3in</Left>
<Height>0.2in</Height>
<Width>7.4in</Width>
<ZIndex>11</ZIndex>
<Visibility>
<Hidden>=IIF(First(Fields!trace_enabled.Value, "RightPane03") =1, True,IIF(Count(Fields!db_name.Value, "RightPane01"
) =0 ,True,IIF(First(Fields!l1.Value,"RightPane01") = -100, False, True )))</Hidden>
</Visibility>
<DataElementOutput>NoOutput</DataElementOutput>
<Style>
<BackgroundColor>White</BackgroundColor>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox1">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Shows changes made in the schema of the objects by DDL operations.</Value>
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Top>1.25in</Top>
<Left>0.2in</Left>
<Height>0.19792in</Height>
<Width>20.574cm</Width>
<ZIndex>12</ZIndex>
<Visibility>
<Hidden>=IIF(First(Fields!trace_enabled.Value, "RightPane03") =1, False, True)</Hidden>
</Visibility>
<DataElementOutput>NoOutput</DataElementOutput>
<Style>
<BackgroundColor>White</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox30">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>No objects were created in last 20 days.</Value>
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Top>1.3in</Top>
<Left>0.3in</Left>
<Height>0.19792in</Height>
<Width>6.45in</Width>
<ZIndex>13</ZIndex>
<Visibility>
<Hidden>=IIF(First(Fields!trace_enabled.Value, "RightPane03") =1, True,IIF(Count(Fields!db_name.Value, "RightPane01"
) =0 ,False, True))</Hidden>
</Visibility>
<DataElementOutput>NoOutput</DataElementOutput>
<Style>
<BackgroundColor>White</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox15">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Note: Currently, this report does not have any data to show, because default trace does not contain relevant information.</Value>
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Top>1.3in</Top>
<Left>0.35in</Left>
<Height>0.19792in</Height>
<Width>6.45in</Width>
<ZIndex>14</ZIndex>
<Visibility>
<Hidden>=IIF(First(Fields!trace_enabled.Value, "RightPane03") =1,IIF(Count( Fields!difference.Value,"RightPane" ) =0, False, True), True)</Hidden>
</Visibility>
<DataElementOutput>NoOutput</DataElementOutput>
<Style>
<BackgroundColor>White</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox35">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Unable to retrieve data for this section of the report. Following error occurred.</Value>
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
<Color>Red</Color>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Top>1.25in</Top>
<Left>0.3in</Left>
<Height>0.2in</Height>
<Width>7.4in</Width>
<ZIndex>15</ZIndex>
<Visibility>
<Hidden>=IIF(First(Fields!trace_enabled.Value, "RightPane03") =1, True,IIF(Count(Fields!db_name.Value, "RightPane01"
) =0 ,True,IIF(First(Fields!l1.Value,"RightPane01") = -100, False, True )))</Hidden>
</Visibility>
<DataElementOutput>NoOutput</DataElementOutput>
<Style>
<BackgroundColor>White</BackgroundColor>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox16">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Objects Created In Last 20 Days</Value>
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
<FontWeight>Bold</FontWeight>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>textbox16</rd:DefaultName>
<Top>1.05in</Top>
<Left>0.2in</Left>
<Height>0.2in</Height>
<Width>7in</Width>
<ZIndex>16</ZIndex>
<Visibility>
<Hidden>=IIF(First(Fields!trace_enabled.Value, "RightPane03") =1, True,IIF(Count(Fields!db_name.Value, "RightPane01"
) =0 ,True,IIF(First(Fields!l1.Value,"RightPane01") = -100, True, False)))</Hidden>
</Visibility>
<DataElementOutput>NoOutput</DataElementOutput>
<Style>
<BackgroundColor>White</BackgroundColor>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox34">
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Schema Change History</Value>
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
<FontWeight>Bold</FontWeight>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Top>1.05in</Top>
<Left>0.2in</Left>
<Height>0.19792in</Height>
<Width>1.6in</Width>
<ZIndex>17</ZIndex>
<Visibility>
<Hidden>=IIF(First(Fields!trace_enabled.Value, "RightPane03") =1, False, True)</Hidden>
</Visibility>
<DataElementOutput>NoOutput</DataElementOutput>
<Style>
<BackgroundColor>White</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox3">
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Schema Changes History</Value>
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>14pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Left</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<Top>0.08125in</Top>
<Left>0.2in</Left>
<Height>0.3in</Height>
<Width>7.6in</Width>
<ZIndex>18</ZIndex>
<Style>
<BackgroundColor>White</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Line Name="line2">
<Top>0.59792in</Top>
<Left>0.2in</Left>
<Height>0in</Height>
<Width>7.65625in</Width>
<ZIndex>19</ZIndex>
<Style>
<Border>
<Color>DarkGray</Color>
<Style>Solid</Style>
</Border>
</Style>
</Line>
<Textbox Name="textbox2">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value />
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Top>0.38958in</Top>
<Left>0.2in</Left>
<Height>0.2in</Height>
<Width>7.63625in</Width>
<ZIndex>20</ZIndex>
<Style>
<BackgroundColor>White</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox11">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Note: Currently, this report is being shown in this format, because default trace is not enabled.</Value>
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Top>2.75in</Top>
<Left>0.2in</Left>
<Height>0.19792in</Height>
<Width>6.45in</Width>
<ZIndex>21</ZIndex>
<Visibility>
<Hidden>=IIF(First(Fields!trace_enabled.Value, "RightPane03") =1, True, False)</Hidden>
</Visibility>
<DataElementOutput>NoOutput</DataElementOutput>
<Style>
<BackgroundColor>White</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Tablix Name="table1">
<TablixBody>
<TablixColumns>
<TablixColumn>
<Width>1.25in</Width>
</TablixColumn>
<TablixColumn>
<Width>2.7in</Width>
</TablixColumn>
<TablixColumn>
<Width>1.2in</Width>
</TablixColumn>
<TablixColumn>
<Width>1in</Width>
</TablixColumn>
<TablixColumn>
<Width>1.4in</Width>
</TablixColumn>
<TablixColumn>
<Width>1.5in</Width>
</TablixColumn>
</TablixColumns>
<TablixRows>
<TablixRow>
<Height>0.2in</Height>
<TablixCells>
<TablixCell>
<CellContents>
<Textbox Name="textbox6">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Database Name</Value>
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
<FontWeight>Bold</FontWeight>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Left</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<ZIndex>11</ZIndex>
<Style>
<Border>
<Color>DarkGray</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>LightGrey</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="textbox23">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Object Name</Value>
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
<FontWeight>Bold</FontWeight>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Left</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<ZIndex>10</ZIndex>
<Style>
<Border>
<Color>DarkGray</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>LightGrey</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="textbox5">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Type</Value>
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
<FontWeight>Bold</FontWeight>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Left</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<rd:DefaultName>textbox5</rd:DefaultName>
<ZIndex>9</ZIndex>
<Style>
<Border>
<Color>DarkGray</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>LightGrey</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="textbox25">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>DDL Operation</Value>
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
<FontWeight>Bold</FontWeight>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Left</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<ZIndex>8</ZIndex>
<Style>
<Border>
<Color>DarkGray</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>LightGrey</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="textbox26">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Time</Value>
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
<FontWeight>Bold</FontWeight>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Left</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<ZIndex>7</ZIndex>
<Style>
<Border>
<Color>DarkGray</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>LightGrey</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="textbox28">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Login Name</Value>
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
<FontWeight>Bold</FontWeight>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Left</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<ZIndex>6</ZIndex>
<Style>
<Border>
<Color>DarkGray</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>LightGrey</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
</TablixCells>
</TablixRow>
<TablixRow>
<Height>0.2in</Height>
<TablixCells>
<TablixCell>
<CellContents>
<Textbox Name="textbox4">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!database_name.Value</Value>
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Left</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<ZIndex>5</ZIndex>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>= IIF((RowNumber(Nothing) Mod 2)=0
,"WhiteSmoke","White")</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="textbox22">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!obj_name.Value</Value>
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Left</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<ZIndex>4</ZIndex>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>= IIF((RowNumber(Nothing) Mod 2)=0
,"WhiteSmoke","White")</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="obj_type_desc">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=IIF(Fields!obj_type_desc.Value = 17985,"Aggregate Function ",
IIF(Fields!obj_type_desc.Value = 20545,"OTYP_APP ",
IIF(Fields!obj_type_desc.Value = 20801,"Adhoc Queries",
IIF(Fields!obj_type_desc.Value = 8259,"Check Constraint ",
IIF(Fields!obj_type_desc.Value = 8260,"Default(Constraint or Standalone) ",
IIF(Fields!obj_type_desc.Value = 20037,"Event Notification ",
IIF(Fields!obj_type_desc.Value = 8262,"Foreign Key Constraint",
IIF(Fields!obj_type_desc.Value = 20038,"Scalar SQL Function ",
IIF(Fields!obj_type_desc.Value = 21318,"Scalar Assembly-Function ",
IIF(Fields!obj_type_desc.Value = 21574,"Table Valued Assembly-Function ",
IIF(Fields!obj_type_desc.Value = 17993,"Inline table-valued SQL Function",
IIF(Fields!obj_type_desc.Value = 21321," Inline scalar SQL Function",
IIF(Fields!obj_type_desc.Value = 21577,"Internal Table ",
IIF(Fields!obj_type_desc.Value = 22601,"Index",
IIF(Fields!obj_type_desc.Value = 16975 ,"Object ",
IIF(Fields!obj_type_desc.Value = 20047,"Object Event Notification",
IIF(Fields!obj_type_desc.Value = 8272,"Stored-Procedure",
IIF(Fields!obj_type_desc.Value = 17232,"Assembly-Stored-Procedure ",
IIF(Fields!obj_type_desc.Value = 19280,"Primary-key ",
IIF(Fields!obj_type_desc.Value = 20816,"Adhoc Queries ",
IIF(Fields!obj_type_desc.Value = 8274,"Rule ",
IIF(Fields!obj_type_desc.Value = 18002,"Replication-filter-procedure ",
IIF(Fields!obj_type_desc.Value = 8275,"System Table ",
IIF(Fields!obj_type_desc.Value = 20051,"Synonym ",
IIF(Fields!obj_type_desc.Value = 20819,"Service Queue ",
IIF(Fields!obj_type_desc.Value = 21587 ," Statistics " ,
IIF(Fields!obj_type_desc.Value = 22611 ,"XMLSchema " ,
IIF(Fields!obj_type_desc.Value = 16724 ,"Assembly/CLR Trigger " ,
IIF(Fields!obj_type_desc.Value = 18004 ,"Table-valued SQL Function" ,
IIF(Fields!obj_type_desc.Value = 21076 ,"T-SQL Trigger" ,
IIF(Fields!obj_type_desc.Value = 8277 ,"User Defined Table " ,
IIF(Fields!obj_type_desc.Value = 20821 ,"Unique constraint" ,
IIF(Fields!obj_type_desc.Value = 8278 ,"View " ,
IIF(Fields!obj_type_desc.Value = 8280 ,"Extended-Stored-Procedure" ,
IIF(Fields!obj_type_desc.Value = 22868,"Type ",
IIF(Fields!obj_type_desc.Value = 19265 ,"Asymmetric Key " ,
IIF(Fields!obj_type_desc.Value = 21057 ,"AppRole" ,
IIF(Fields!obj_type_desc.Value = 21313 ,"Assembly " ,
IIF(Fields!obj_type_desc.Value = 20034 ,"Remote Service Binding " ,
IIF(Fields!obj_type_desc.Value = 21571 ,"Service Contract" ,
IIF(Fields!obj_type_desc.Value = 16964 ,"Database " ,
IIF(Fields!obj_type_desc.Value = 20036 ,"DB Event Notification " ,
IIF(Fields!obj_type_desc.Value = 21572 ,"DB Trigger " ,
IIF(Fields!obj_type_desc.Value = 17222 ,"FullText Catalog " ,
IIF(Fields!obj_type_desc.Value = 19277 ,"Master key " ,
IIF(Fields!obj_type_desc.Value = 21581 ,"Message Type " ,
IIF(Fields!obj_type_desc.Value = 18000 ,"Partition Function " ,
IIF(Fields!obj_type_desc.Value = 21328 ,"Partition Scheme " ,
IIF(Fields!obj_type_desc.Value = 19538 ,"Role " ,
IIF(Fields!obj_type_desc.Value = 21586 ,"Route " ,
IIF(Fields!obj_type_desc.Value = 17235 ,"Schema " ,
IIF(Fields!obj_type_desc.Value = 19283 ,"ObfusKey " ,
IIF(Fields!obj_type_desc.Value = 22099 ,"Service " ,
IIF(Fields!obj_type_desc.Value = 21825 ,"User (AKEYUSER)" ,
IIF(Fields!obj_type_desc.Value = 21827 ,"User (CERTUSER)" ,
IIF(Fields!obj_type_desc.Value = 21843 ,"User (SQLUSER)" ,
IIF(Fields!obj_type_desc.Value = 21333 ,"User " ,
IIF(Fields!obj_type_desc.Value = 21847 ,"User (WINUSER) " ,
IIF(Fields!obj_type_desc.Value = 21831 ,"User (GROUPUSER)" ,
IIF(Fields!obj_type_desc.Value = 19521 ,"Asymmetric Key Login" ,
IIF(Fields!obj_type_desc.Value = 19523 ,"Certificate Login " ,
IIF(Fields!obj_type_desc.Value = 17475 ,"Credential " ,
IIF(Fields!obj_type_desc.Value = 21059 ,"Certificate " ,
IIF(Fields!obj_type_desc.Value = 20549 ,"End Point " ,
IIF(Fields!obj_type_desc.Value = 22604 ,"Certificate Login " ,
IIF(Fields!obj_type_desc.Value = 17741 ,"Management Event " ,
IIF(Fields!obj_type_desc.Value = 17747 ,"Security Event " ,
IIF(Fields!obj_type_desc.Value = 18259 ,"Server Role " ,
IIF(Fields!obj_type_desc.Value = 19539 ,"SQL Login" ,
IIF(Fields!obj_type_desc.Value = 17491 ,"DDL Event" ,
IIF(Fields!obj_type_desc.Value = 21075 ,"Server" ,
IIF(Fields!obj_type_desc.Value = 8276 ,"Server Trigger" ,
IIF(Fields!obj_type_desc.Value = 17749 ,"User Event" ,
IIF(Fields!obj_type_desc.Value = 18263 ,"Windows Group " ,
IIF(Fields!obj_type_desc.Value = 19543 ,"Windows Login " ,
IIF(Fields!obj_type_desc.Value = 0,"Invalid ",
IIF(Fields!obj_type_desc.Value = 1,"Any",
IIF(Fields!obj_type_desc.Value = 2,"All",
IIF(Fields!obj_type_desc.Value = 4,"Not Adhoc Query",
IIF(Fields!obj_type_desc.Value = 65536,"Local",
IIF(Fields!obj_type_desc.Value = 131072 ,"Remote "
,"Unknown Object Type "
)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))</Value>
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>obj_type_desc</rd:DefaultName>
<ZIndex>3</ZIndex>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>= IIF((RowNumber(Nothing) Mod 2)=0
,"WhiteSmoke","White")</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="ddl_operation">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!ddl_operation.Value</Value>
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Left</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<rd:DefaultName>ddl_operation</rd:DefaultName>
<ZIndex>2</ZIndex>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>= IIF((RowNumber(Nothing) Mod 2)=0
,"WhiteSmoke","White")</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="start_time_1">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!start_time.Value</Value>
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Left</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<rd:DefaultName>start_time_1</rd:DefaultName>
<ZIndex>1</ZIndex>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>= IIF((RowNumber(Nothing) Mod 2)=0
,"WhiteSmoke","White")</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<rd:Selected>true</rd:Selected>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="login_name">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!login_name.Value</Value>
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Left</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<rd:DefaultName>login_name</rd:DefaultName>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>= IIF((RowNumber(Nothing) Mod 2)=0
,"WhiteSmoke","White")</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
</TablixCells>
</TablixRow>
</TablixRows>
</TablixBody>
<TablixColumnHierarchy>
<TablixMembers>
<TablixMember />
<TablixMember />
<TablixMember />
<TablixMember />
<TablixMember />
<TablixMember />
</TablixMembers>
</TablixColumnHierarchy>
<TablixRowHierarchy>
<TablixMembers>
<TablixMember>
<KeepWithGroup>After</KeepWithGroup>
<KeepTogether>true</KeepTogether>
</TablixMember>
<TablixMember>
<Group Name="table1_Details_Group">
<DataElementName>Detail</DataElementName>
</Group>
<SortExpressions>
<SortExpression>
<Value>=Fields!start_time.Value</Value>
<Direction>Descending</Direction>
</SortExpression>
</SortExpressions>
<TablixMembers>
<TablixMember />
</TablixMembers>
<DataElementName>Detail_Collection</DataElementName>
<DataElementOutput>Output</DataElementOutput>
<KeepTogether>true</KeepTogether>
</TablixMember>
</TablixMembers>
</TablixRowHierarchy>
<DataSetName>RightPane</DataSetName>
<Top>1.55in</Top>
<Left>0.2in</Left>
<Height>0.4in</Height>
<Width>22.987cm</Width>
<ZIndex>22</ZIndex>
<Visibility>
<Hidden>=IIF(First(Fields!trace_enabled.Value, "RightPane03") =1,IIF(Count( Fields!difference.Value ) =0, True, IIF(First(Fields!difference.Value ) = -100, True, False)), True)</Hidden>
</Visibility>
<DataElementOutput>NoOutput</DataElementOutput>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<VerticalAlign>Middle</VerticalAlign>
</Style>
</Tablix>
<Textbox Name="textbox43">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>This report provides a history of all committed DDL statement executions recorded by the default trace.</Value>
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Top>0.7in</Top>
<Left>0.2in</Left>
<Height>0.19792in</Height>
<Width>6.45in</Width>
<ZIndex>23</ZIndex>
<Style>
<BackgroundColor>White</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Textbox Name="textbox18">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value />
<Style>
<FontFamily>=Parameters!FontName.Value</FontFamily>
<FontSize>8pt</FontSize>
<FontWeight>Bold</FontWeight>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Top>1.05in</Top>
<Left>1.9in</Left>
<Height>0.19792in</Height>
<Width>5.1in</Width>
<ZIndex>24</ZIndex>
<Visibility>
<Hidden>=IIF(First(Fields!trace_enabled.Value, "RightPane03") =1,IIF(Count( Fields!difference.Value,"RightPane" ) =0, True, IIF(First(Fields!difference.Value,"RightPane" ) = -100, True, False)), True)</Hidden>
</Visibility>
<DataElementOutput>NoOutput</DataElementOutput>
<Style>
<BackgroundColor>White</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</ReportItems>
<Height>2.94792in</Height>
<Style />
</Body>
<ReportParameters>
<ReportParameter Name="ObjectName">
<DataType>String</DataType>
<Nullable>true</Nullable>
<DefaultValue>
<Values>
<Value xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>ObjectName</Prompt>
</ReportParameter>
<ReportParameter Name="ObjectTypeName">
<DataType>String</DataType>
<Nullable>true</Nullable>
<DefaultValue>
<Values>
<Value xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>ObjectTypeName</Prompt>
</ReportParameter>
<ReportParameter Name="ErrorText">
<DataType>String</DataType>
<Nullable>true</Nullable>
<DefaultValue>
<Values>
<Value xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>ErrorText</Prompt>
</ReportParameter>
<ReportParameter Name="Filtered">
<DataType>Boolean</DataType>
<Nullable>true</Nullable>
<DefaultValue>
<Values>
<Value xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Filtered</Prompt>
</ReportParameter>
<ReportParameter Name="ServerName">
<DataType>String</DataType>
<Nullable>true</Nullable>
<DefaultValue>
<Values>
<Value xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>ServerName</Prompt>
</ReportParameter>
<ReportParameter Name="FontName">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>Tahoma</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>FontName</Prompt>
</ReportParameter>
<ReportParameter Name="DatabaseName">
<DataType>String</DataType>
<Nullable>true</Nullable>
<DefaultValue>
<Values>
<Value xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>DatabaseName</Prompt>
</ReportParameter>
</ReportParameters>
<Width>23.495cm</Width>
<Page>
<PageHeight>6in</PageHeight>
<PageWidth>8in</PageWidth>
<InteractiveHeight>0in</InteractiveHeight>
<InteractiveWidth>8.5in</InteractiveWidth>
<LeftMargin>1in</LeftMargin>
<RightMargin>1in</RightMargin>
<TopMargin>1in</TopMargin>
<BottomMargin>1in</BottomMargin>
<Style>
<BackgroundColor>White</BackgroundColor>
</Style>
</Page>
<Language>=User!Language</Language>
<ConsumeContainerWhitespace>true</ConsumeContainerWhitespace>
<rd:ReportID>861adc21-c342-4398-bd85-c075dc3d6930</rd:ReportID>
<rd:ReportUnitType>Inch</rd:ReportUnitType>
</Report>
March 28, 2010 at 8:17 am
has anyone any ideas on this as I'm still struggling changing the dates looking back
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply