1: <?xml version="1.0" encoding="utf-8"?>
2: <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
3: <DataSources>
4: <DataSource Name="IISLog">
5: <rd:DataSourceID>c04397fa-f432-4983-907e-3533dc2dea9c</rd:DataSourceID>
6: <ConnectionProperties>
7: <DataProvider>SQL</DataProvider>
8: <ConnectString>Data Source=crm4dev;Initial Catalog=IISLog</ConnectString>
9: <IntegratedSecurity>true</IntegratedSecurity>
10: </ConnectionProperties>
11: </DataSource>
12: </DataSources>
13: <InteractiveHeight>11in</InteractiveHeight>
14: <rd:DrawGrid>true</rd:DrawGrid>
15: <InteractiveWidth>8.5in</InteractiveWidth>
16: <rd:GridSpacing>0.25cm</rd:GridSpacing>
17: <rd:SnapToGrid>true</rd:SnapToGrid>
18: <RightMargin>2.5cm</RightMargin>
19: <LeftMargin>2.5cm</LeftMargin>
20: <BottomMargin>2.5cm</BottomMargin>
21: <rd:ReportID>c13a6342-b76c-4be0-8d0f-8598eac7fa80</rd:ReportID>
22: <PageWidth>21cm</PageWidth>
23: <DataSets>
24: <DataSet Name="IISLog">
25: <Fields>
26: <Field Name="username">
27: <DataField>username</DataField>
28: <rd:TypeName>System.String</rd:TypeName>
29: </Field>
30: <Field Name="TimePeriod">
31: <DataField>TimePeriod</DataField>
32: <rd:TypeName>System.String</rd:TypeName>
33: </Field>
34: <Field Name="DateText">
35: <DataField>DateText</DataField>
36: <rd:TypeName>System.String</rd:TypeName>
37: </Field>
38: <Field Name="DateYYYYMMDD">
39: <DataField>DateYYYYMMDD</DataField>
40: <rd:TypeName>System.String</rd:TypeName>
41: </Field>
42: <Field Name="ProcessingTime">
43: <DataField>ProcessingTime</DataField>
44: <rd:TypeName>System.Int32</rd:TypeName>
45: </Field>
46: <Field Name="Requests">
47: <DataField>Requests</DataField>
48: <rd:TypeName>System.Int32</rd:TypeName>
49: </Field>
50: </Fields>
51: <Query>
52: <DataSourceName>IISLog</DataSourceName>
53: <CommandText>select usernameonly as username, TimePeriod, DateText, DateYYYYMMDD
54: , sum(processingtime) as ProcessingTime, count(*) as Requests
55: from IISLogFilteredWithPeriods
56: where logtime > dateadd(d, -7, getdate())
57: group by usernameonly, TimePeriod, DateText, DateYYYYMMDD</CommandText>
58: <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
59: </Query>
60: </DataSet>
61: </DataSets>
62: <Width>16.5cm</Width>
63: <Body>
64: <ColumnSpacing>1cm</ColumnSpacing>
65: <ReportItems>
66: <Textbox Name="textbox1">
67: <rd:DefaultName>textbox1</rd:DefaultName>
68: <Style>
69: <Color>SteelBlue</Color>
70: <FontFamily>Tahoma</FontFamily>
71: <FontSize>20pt</FontSize>
72: <FontWeight>700</FontWeight>
73: <PaddingLeft>2pt</PaddingLeft>
74: <PaddingRight>2pt</PaddingRight>
75: <PaddingTop>2pt</PaddingTop>
76: <PaddingBottom>2pt</PaddingBottom>
77: </Style>
78: <ZIndex>1</ZIndex>
79: <CanGrow>true</CanGrow>
80: <Height>0.91429cm</Height>
81: <Value>Log By Date And User - Last 7 days</Value>
82: </Textbox>
83: <Matrix Name="matrix1">
84: <MatrixColumns>
85: <MatrixColumn>
86: <Width>1.35cm</Width>
87: </MatrixColumn>
88: </MatrixColumns>
89: <DataSetName>IISLog</DataSetName>
90: <RowGroupings>
91: <RowGrouping>
92: <Width>2.53968cm</Width>
93: <DynamicRows>
94: <Grouping Name="matrix1_DateText">
95: <GroupExpressions>
96: <GroupExpression>=Fields!DateText.Value</GroupExpression>
97: </GroupExpressions>
98: </Grouping>
99: <Sorting>
100: <SortBy>
101: <SortExpression>=Fields!DateYYYYMMDD.Value</SortExpression>
102: <Direction>Descending</Direction>
103: </SortBy>
104: </Sorting>
105: <Subtotal>
106: <ReportItems>
107: <Textbox Name="textbox5">
108: <rd:DefaultName>textbox5</rd:DefaultName>
109: <Style>
110: <Color>White</Color>
111: <BackgroundColor>#6e9eca</BackgroundColor>
112: <BorderColor>
113: <Default>LightGrey</Default>
114: </BorderColor>
115: <BorderStyle>
116: <Default>Solid</Default>
117: </BorderStyle>
118: <FontFamily>Tahoma</FontFamily>
119: <FontWeight>700</FontWeight>
120: <PaddingLeft>2pt</PaddingLeft>
121: <PaddingRight>2pt</PaddingRight>
122: <PaddingTop>2pt</PaddingTop>
123: <PaddingBottom>2pt</PaddingBottom>
124: </Style>
125: <CanGrow>true</CanGrow>
126: <Value>Total</Value>
127: </Textbox>
128: </ReportItems>
129: </Subtotal>
130: <ReportItems>
131: <Textbox Name="DateText">
132: <rd:DefaultName>DateText</rd:DefaultName>
133: <Style>
134: <Color>White</Color>
135: <BackgroundColor>#6e9eca</BackgroundColor>
136: <BorderColor>
137: <Default>LightGrey</Default>
138: </BorderColor>
139: <BorderStyle>
140: <Default>Solid</Default>
141: </BorderStyle>
142: <FontFamily>Tahoma</FontFamily>
143: <FontWeight>700</FontWeight>
144: <PaddingLeft>2pt</PaddingLeft>
145: <PaddingRight>2pt</PaddingRight>
146: <PaddingTop>2pt</PaddingTop>
147: <PaddingBottom>2pt</PaddingBottom>
148: </Style>
149: <ZIndex>3</ZIndex>
150: <CanGrow>true</CanGrow>
151: <Value>=Fields!DateText.Value</Value>
152: </Textbox>
153: </ReportItems>
154: </DynamicRows>
155: </RowGrouping>
156: <RowGrouping>
157: <Width>4.5cm</Width>
158: <DynamicRows>
159: <Grouping Name="matrix1_username">
160: <GroupExpressions>
161: <GroupExpression>=Fields!username.Value</GroupExpression>
162: </GroupExpressions>
163: </Grouping>
164: <Sorting>
165: <SortBy>
166: <SortExpression>=Fields!username.Value</SortExpression>
167: <Direction>Ascending</Direction>
168: </SortBy>
169: </Sorting>
170: <ReportItems>
171: <Textbox Name="username">
172: <rd:DefaultName>username</rd:DefaultName>
173: <Style>
174: <Color>White</Color>
175: <BackgroundColor>SlateGray</BackgroundColor>
176: <BorderColor>
177: <Default>LightGrey</Default>
178: </BorderColor>
179: <BorderStyle>
180: <Default>Solid</Default>
181: </BorderStyle>
182: <FontFamily>Tahoma</FontFamily>
183: <FontWeight>700</FontWeight>
184: <PaddingLeft>2pt</PaddingLeft>
185: <PaddingRight>2pt</PaddingRight>
186: <PaddingTop>2pt</PaddingTop>
187: <PaddingBottom>2pt</PaddingBottom>
188: </Style>
189: <ZIndex>2</ZIndex>
190: <CanGrow>true</CanGrow>
191: <Value>=Fields!username.Value</Value>
192: </Textbox>
193: </ReportItems>
194: </DynamicRows>
195: </RowGrouping>
196: </RowGroupings>
197: <Top>0.91429cm</Top>
198: <ColumnGroupings>
199: <ColumnGrouping>
200: <Height>0.53333cm</Height>
201: <DynamicColumns>
202: <Grouping Name="matrix1_TimePeriod">
203: <GroupExpressions>
204: <GroupExpression>=Fields!TimePeriod.Value</GroupExpression>
205: </GroupExpressions>
206: </Grouping>
207: <Sorting>
208: <SortBy>
209: <SortExpression>=Fields!TimePeriod.Value</SortExpression>
210: <Direction>Ascending</Direction>
211: </SortBy>
212: </Sorting>
213: <Subtotal>
214: <ReportItems>
215: <Textbox Name="textbox4">
216: <rd:DefaultName>textbox4</rd:DefaultName>
217: <Style>
218: <Color>White</Color>
219: <BackgroundColor>#6e9eca</BackgroundColor>
220: <BorderColor>
221: <Default>LightGrey</Default>
222: </BorderColor>
223: <BorderStyle>
224: <Default>Solid</Default>
225: </BorderStyle>
226: <FontFamily>Tahoma</FontFamily>
227: <FontWeight>700</FontWeight>
228: <PaddingLeft>2pt</PaddingLeft>
229: <PaddingRight>2pt</PaddingRight>
230: <PaddingTop>2pt</PaddingTop>
231: <PaddingBottom>2pt</PaddingBottom>
232: </Style>
233: <ZIndex>4</ZIndex>
234: <CanGrow>true</CanGrow>
235: <Value>Total</Value>
236: </Textbox>
237: </ReportItems>
238: </Subtotal>
239: <ReportItems>
240: <Textbox Name="TimePeriod">
241: <rd:DefaultName>TimePeriod</rd:DefaultName>
242: <Style>
243: <Color>White</Color>
244: <BackgroundColor>#6e9eca</BackgroundColor>
245: <BorderColor>
246: <Default>LightGrey</Default>
247: </BorderColor>
248: <BorderStyle>
249: <Default>Solid</Default>
250: </BorderStyle>
251: <FontFamily>Tahoma</FontFamily>
252: <FontWeight>700</FontWeight>
253: <PaddingLeft>2pt</PaddingLeft>
254: <PaddingRight>2pt</PaddingRight>
255: <PaddingTop>2pt</PaddingTop>
256: <PaddingBottom>2pt</PaddingBottom>
257: </Style>
258: <ZIndex>5</ZIndex>
259: <CanGrow>true</CanGrow>
260: <Value>=Fields!TimePeriod.Value</Value>
261: </Textbox>
262: </ReportItems>
263: </DynamicColumns>
264: </ColumnGrouping>
265: </ColumnGroupings>
266: <Width>9.73968cm</Width>
267: <Corner>
268: <ReportItems>
269: <Textbox Name="textbox3">
270: <rd:DefaultName>textbox3</rd:DefaultName>
271: <Style>
272: <BorderColor>
273: <Default>LightGrey</Default>
274: </BorderColor>
275: <BorderStyle>
276: <Default>Solid</Default>
277: </BorderStyle>
278: <FontFamily>Tahoma</FontFamily>
279: <PaddingLeft>2pt</PaddingLeft>
280: <PaddingRight>2pt</PaddingRight>
281: <PaddingTop>2pt</PaddingTop>
282: <PaddingBottom>2pt</PaddingBottom>
283: </Style>
284: <ZIndex>6</ZIndex>
285: <CanGrow>true</CanGrow>
286: <Value>
287: </Value>
288: </Textbox>
289: </ReportItems>
290: </Corner>
291: <MatrixRows>
292: <MatrixRow>
293: <Height>0.53333cm</Height>
294: <MatrixCells>
295: <MatrixCell>
296: <ReportItems>
297: <Textbox Name="textbox2">
298: <rd:DefaultName>textbox2</rd:DefaultName>
299: <Style>
300: <BackgroundColor>=iif(Fields!Requests.Value > 5, "LightSteelBlue", iif(Fields!Requests.Value > 0, "AliceBlue", "White"))</BackgroundColor>
301: <BorderColor>
302: <Default>LightGrey</Default>
303: </BorderColor>
304: <BorderStyle>
305: <Default>Solid</Default>
306: </BorderStyle>
307: <FontFamily>Tahoma</FontFamily>
308: <PaddingLeft>2pt</PaddingLeft>
309: <PaddingRight>2pt</PaddingRight>
310: <PaddingTop>2pt</PaddingTop>
311: <PaddingBottom>2pt</PaddingBottom>
312: </Style>
313: <ZIndex>1</ZIndex>
314: <CanGrow>true</CanGrow>
315: <Value>=Sum(Fields!Requests.Value)</Value>
316: </Textbox>
317: </ReportItems>
318: </MatrixCell>
319: </MatrixCells>
320: </MatrixRow>
321: </MatrixRows>
322: </Matrix>
323: </ReportItems>
324: <Height>2.51428cm</Height>
325: </Body>
326: <Language>en-US</Language>
327: <TopMargin>2.5cm</TopMargin>
328: <PageHeight>29.7cm</PageHeight>
329: </Report>