Is this the correct group to post problems about proxy accounts?

I have already posted this but have not received an answer.
Hi there,
I have set the proxy user details using
xp_sqlagent_proxy_account 'set' and the command completes successfully, so
the logon details are correct. I have also logged onto the server using
those details just to make sure and that works OK. However, when I fire a
trigger that is making a call to xp_cmd_shell, I get the message "Logon
failure: unknown user name or bad password" Anyone know what the issue is
here?
This is SQL Server 2000 SP3 on Windows 2000 SP4.Try resetting the proxy account using the user and password
you can log in with - the easiest way to reset is to select
the properties of SQL Server Agent, on the Job Control tab,
click on Reset Proxy Account.
-Sue
On Wed, 27 Jul 2005 15:17:40 +0100, "Waldy"
<waldy@.notmail.com> wrote:

>I have already posted this but have not received an answer.
>Hi there,
> I have set the proxy user details using
>xp_sqlagent_proxy_account 'set' and the command completes successfully, so
>the logon details are correct. I have also logged onto the server using
>those details just to make sure and that works OK. However, when I fire a
>trigger that is making a call to xp_cmd_shell, I get the message "Logon
>failure: unknown user name or bad password" Anyone know what the issue is
>here?
>This is SQL Server 2000 SP3 on Windows 2000 SP4.
>

is this possible in RS?

Using SS2000, VS2003, RS2000.
The report lists branches and the companies they have mailed to. The company
mailed to could have received one of three offers. I need to get a count of
how many companies were mailed to by each branch and how many of each offer
was mailed for each branch. The client wants to show the report.like this:
Branch # Company Mailed Offer
25 Company A Offer 1
25 Company B Offer 2
25 Company C Offer 2
25 Company D Offer 3
25 Company E Offer 2
25 Company F Offer 1
Companies Mailed for Branch 25 6
Offer 1 2
Offer 2 3
Offer 3 1
33 Company G Offer 1
33 Company H Offer 2
33 Company I Offer 2
33 Company J Offer 3
33 Company K Offer 2
33 Company L Offer 1
33 Company M Offer 2
33 Company N Offer 1
Companies Mailed for Branch 33 8
Offer 1 3
Offer 2 4
Offer 3 1
I thought that if I created a group on the Branch # I would be able to count
the number of companies mailed to and that works. But I can't figure out how
to get the count for each kind of mailing. I thought about adding another row
in the design for the same group of Branch # and then count for each kind of
mailing by putting a filter on the group for "offer 1" but that didn't work.
Is it possbile to put a filter on the count (i.e. Count(Fields!Offer.Value)
Where Offer = 'Offer 1')?
Thanks,
--
Dan D.Dan,
This would create a slightly different format, but I don't think they
would be disappointed.
Group by Branch # and then group by Offer. You can enable drill-down if
you want, but either way this will allow you to do summaries at each of
the grouping levels. You can use various combinations of Count and
Countdistinct in the group headers to provide the summary information.
-Josh
Dan D. wrote:
> Using SS2000, VS2003, RS2000.
> The report lists branches and the companies they have mailed to. The company
> mailed to could have received one of three offers. I need to get a count of
> how many companies were mailed to by each branch and how many of each offer
> was mailed for each branch. The client wants to show the report.like this:
> Branch # Company Mailed Offer
> 25 Company A Offer 1
> 25 Company B Offer 2
> 25 Company C Offer 2
> 25 Company D Offer 3
> 25 Company E Offer 2
> 25 Company F Offer 1
> Companies Mailed for Branch 25 6
> Offer 1 2
> Offer 2 3
> Offer 3 1
>
> 33 Company G Offer 1
> 33 Company H Offer 2
> 33 Company I Offer 2
> 33 Company J Offer 3
> 33 Company K Offer 2
> 33 Company L Offer 1
> 33 Company M Offer 2
> 33 Company N Offer 1
> Companies Mailed for Branch 33 8
> Offer 1 3
> Offer 2 4
> Offer 3 1
> I thought that if I created a group on the Branch # I would be able to count
> the number of companies mailed to and that works. But I can't figure out how
> to get the count for each kind of mailing. I thought about adding another row
> in the design for the same group of Branch # and then count for each kind of
> mailing by putting a filter on the group for "offer 1" but that didn't work.
> Is it possbile to put a filter on the count (i.e. Count(Fields!Offer.Value)
> Where Offer = 'Offer 1')?
> Thanks,
> --
> Dan D.|||If I understand what you're suggesting, I tried it and it looks like this:
Branch # Company Mailed Offer
25 Company A Offer 1
25 Company F Offer 1
Offer 1 2
25 Company B Offer 2
25 Company C Offer 2
25 Company E Offer 2
Offer 2 3
25 Company D Offer 3
Offer 3 1
Companies Mailed for Branch 25 6
I actually gave the account rep this report. It will give the client the
data that they need while I try to figure out how to get in the other format.
If that is not what you were talkng about, let me know.
Thanks,
--
Dan D.
"Josh" wrote:
> Dan,
> This would create a slightly different format, but I don't think they
> would be disappointed.
> Group by Branch # and then group by Offer. You can enable drill-down if
> you want, but either way this will allow you to do summaries at each of
> the grouping levels. You can use various combinations of Count and
> Countdistinct in the group headers to provide the summary information.
> -Josh
>
> Dan D. wrote:
> > Using SS2000, VS2003, RS2000.
> > The report lists branches and the companies they have mailed to. The company
> > mailed to could have received one of three offers. I need to get a count of
> > how many companies were mailed to by each branch and how many of each offer
> > was mailed for each branch. The client wants to show the report.like this:
> >
> > Branch # Company Mailed Offer
> > 25 Company A Offer 1
> > 25 Company B Offer 2
> > 25 Company C Offer 2
> > 25 Company D Offer 3
> > 25 Company E Offer 2
> > 25 Company F Offer 1
> > Companies Mailed for Branch 25 6
> > Offer 1 2
> > Offer 2 3
> > Offer 3 1
> >
> >
> > 33 Company G Offer 1
> > 33 Company H Offer 2
> > 33 Company I Offer 2
> > 33 Company J Offer 3
> > 33 Company K Offer 2
> > 33 Company L Offer 1
> > 33 Company M Offer 2
> > 33 Company N Offer 1
> > Companies Mailed for Branch 33 8
> > Offer 1 3
> > Offer 2 4
> > Offer 3 1
> >
> > I thought that if I created a group on the Branch # I would be able to count
> > the number of companies mailed to and that works. But I can't figure out how
> > to get the count for each kind of mailing. I thought about adding another row
> > in the design for the same group of Branch # and then count for each kind of
> > mailing by putting a filter on the group for "offer 1" but that didn't work.
> > Is it possbile to put a filter on the count (i.e. Count(Fields!Offer.Value)
> > Where Offer = 'Offer 1')?
> >
> > Thanks,
> > --
> > Dan D.
>|||Dan,
That is kind of what I was picturing... I guess what I had in mind
would look like this. In fact, to get the full effect, paste this into
an HTML file and open it in Internet Explorer.
I hope that it does truncate it...
<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="">http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html;
charset=windows-1252">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 9">
<link rel=File-List href="http://links.10026.com/?link=./Book1_files/filelist.xml">
<link rel=Edit-Time-Data href="http://links.10026.com/?link=./Book1_files/editdata.mso">
<link rel=OLE-Object-Data href="http://links.10026.com/?link=./Book1_files/oledata.mso">
<!--[if gte mso 9]><xml>
<o:DocumentProperties>
<o:Author>Administrator</o:Author>
<o:LastAuthor>Administrator</o:LastAuthor>
<o:Created>2006-08-11T20:19:33Z</o:Created>
<o:LastSaved>2006-08-11T20:33:17Z</o:LastSaved>
<o:Company>BCBST</o:Company>
<o:Version>9.6926</o:Version>
</o:DocumentProperties>
<o:OfficeDocumentSettings>
<o:DownloadComponents/>
<o:LocationOfComponents href="http://links.10026.com/?link=file:msowc.cab"/>
</o:OfficeDocumentSettings>
</xml><![endif]-->
<style>
<!--table
{mso-displayed-decimal-separator:"\.";
mso-displayed-thousand-separator:"\,";}
@.page
{margin:1.0in .75in 1.0in .75in;
mso-header-margin:.5in;
mso-footer-margin:.5in;}
tr
{mso-height-source:auto;}
col
{mso-width-source:auto;}
br
{mso-data-placement:same-cell;}
.style0
{mso-number-format:General;
text-align:general;
vertical-align:bottom;
white-space:nowrap;
mso-rotate:0;
mso-background-source:auto;
mso-pattern:auto;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
border:none;
mso-protection:locked visible;
mso-style-name:Normal;
mso-style-id:0;}
td
{mso-style-parent:style0;
padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
border:none;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:locked visible;
white-space:nowrap;
mso-rotate:0;}
.xl24
{mso-style-parent:style0;
color:white;
font-family:Arial, sans-serif;
mso-font-charset:0;
text-align:left;
background:gray;
mso-pattern:auto none;}
.xl25
{mso-style-parent:style0;
text-align:left;}
.xl26
{mso-style-parent:style0;
color:white;
font-family:Arial, sans-serif;
mso-font-charset:0;
text-align:left;
border-top:none;
border-right:none;
border-bottom:1.0pt solid windowtext;
border-left:none;
background:#333399;
mso-pattern:auto none;}
.xl27
{mso-style-parent:style0;
text-align:left;
background:#99CCFF;
mso-pattern:auto none;}
-->
</style>
<!--[if gte mso 9]><xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>Sheet1</x:Name>
<x:WorksheetOptions>
<x:Print>
<x:ValidPrinterInfo/>
<x:HorizontalResolution>600</x:HorizontalResolution>
<x:VerticalResolution>600</x:VerticalResolution>
</x:Print>
<x:Selected/>
<x:Panes>
<x:Pane>
<x:Number>3</x:Number>
<x:ActiveRow>27</x:ActiveRow>
</x:Pane>
</x:Panes>
<x:ProtectContents>False</x:ProtectContents>
<x:ProtectObjects>False</x:ProtectObjects>
<x:ProtectScenarios>False</x:ProtectScenarios>
</x:WorksheetOptions>
</x:ExcelWorksheet>
<x:ExcelWorksheet>
<x:Name>Sheet2</x:Name>
<x:WorksheetOptions>
<x:ProtectContents>False</x:ProtectContents>
<x:ProtectObjects>False</x:ProtectObjects>
<x:ProtectScenarios>False</x:ProtectScenarios>
</x:WorksheetOptions>
</x:ExcelWorksheet>
<x:ExcelWorksheet>
<x:Name>Sheet3</x:Name>
<x:WorksheetOptions>
<x:ProtectContents>False</x:ProtectContents>
<x:ProtectObjects>False</x:ProtectObjects>
<x:ProtectScenarios>False</x:ProtectScenarios>
</x:WorksheetOptions>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
<x:WindowHeight>10110</x:WindowHeight>
<x:WindowWidth>17100</x:WindowWidth>
<x:WindowTopX>120</x:WindowTopX>
<x:WindowTopY>15</x:WindowTopY>
<x:ProtectStructure>False</x:ProtectStructure>
<x:ProtectWindows>False</x:ProtectWindows>
</x:ExcelWorkbook>
</xml><![endif]-->
</head>
<body link=blue vlink=purple>
<table x:str border=0 cellpadding=0 cellspacing=0 width=343
style='border-collapse:
collapse;table-layout:fixed;width:257pt'>
<col class=xl25 width=95
style='mso-width-source:userset;mso-width-alt:3474;
width:71pt'>
<col class=xl25 width=119
style='mso-width-source:userset;mso-width-alt:4352;
width:89pt'>
<col class=xl25 width=129
style='mso-width-source:userset;mso-width-alt:4717;
width:97pt'>
<tr height=18 style='height:13.5pt'>
<td height=18 class=xl26 width=95
style='height:13.5pt;width:71pt'>Branch ID</td>
<td class=xl26 width=119 style='width:89pt'>Offer</td>
<td class=xl26 width=129 style='width:97pt'>Company</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl24 style='height:12.75pt' x:num>25</td>
<td class=xl24>( 3 Offer Types )</td>
<td class=xl24>( 6 Companies )</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl25 style='height:12.75pt'></td>
<td class=xl27>Offer 1</td>
<td class=xl27>( 2 Companies )</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=2 class=xl25
style='height:12.75pt;mso-ignore:colspan'></td>
<td class=xl25>Company A</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=2 class=xl25
style='height:12.75pt;mso-ignore:colspan'></td>
<td class=xl25>Company F</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl25 style='height:12.75pt'></td>
<td class=xl27>Offer 2</td>
<td class=xl27>( 3 Companies )</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=2 class=xl25
style='height:12.75pt;mso-ignore:colspan'></td>
<td class=xl25>Company B</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=2 class=xl25
style='height:12.75pt;mso-ignore:colspan'></td>
<td class=xl25>Company C</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=2 class=xl25
style='height:12.75pt;mso-ignore:colspan'></td>
<td class=xl25>Company E</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl25 style='height:12.75pt'></td>
<td class=xl27>Offer 3</td>
<td class=xl27>( 1 Company )</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=2 class=xl25
style='height:12.75pt;mso-ignore:colspan'></td>
<td class=xl25>Company D</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl24 style='height:12.75pt' x:num>33</td>
<td class=xl24>( 3 Offer Types )</td>
<td class=xl24>( 8 Companies )</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl25 style='height:12.75pt'></td>
<td class=xl27>Offer 1</td>
<td class=xl27>( 3 Companies )</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=2 class=xl25
style='height:12.75pt;mso-ignore:colspan'></td>
<td class=xl25>Company G</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=2 class=xl25
style='height:12.75pt;mso-ignore:colspan'></td>
<td class=xl25>Company L</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=2 class=xl25
style='height:12.75pt;mso-ignore:colspan'></td>
<td class=xl25>Company N</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl25 style='height:12.75pt'></td>
<td class=xl27>Offer 2</td>
<td class=xl27>( 4 Companies )</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=2 class=xl25
style='height:12.75pt;mso-ignore:colspan'></td>
<td class=xl25>Company H</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=2 class=xl25
style='height:12.75pt;mso-ignore:colspan'></td>
<td class=xl25>Company I</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=2 class=xl25
style='height:12.75pt;mso-ignore:colspan'></td>
<td class=xl25>Company K</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=2 class=xl25
style='height:12.75pt;mso-ignore:colspan'></td>
<td class=xl25>Company M</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl25 style='height:12.75pt'></td>
<td class=xl27>Offer 3</td>
<td class=xl27>( 1 Company )</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=2 class=xl25
style='height:12.75pt;mso-ignore:colspan'></td>
<td class=xl25>Company J</td>
</tr>
<![if supportMisalignedColumns]>
<tr height=0 style='display:none'>
<td width=95 style='width:71pt'></td>
<td width=119 style='width:89pt'></td>
<td width=129 style='width:97pt'></td>
</tr>
<![endif]>
</table>
</body>
</html>
As you might have noticed, I like having the summary info in the
Headers because that is what most people are looking for. I don't
typically use Footers when I enable drill-down because it gives it a
"cleaner" look. It's like, "here is the summary, and then here is the
data that goes with it."
Hope this helps!
-Josh
Dan D. wrote:
> If I understand what you're suggesting, I tried it and it looks like this:
> Branch # Company Mailed Offer
> 25 Company A Offer 1
> 25 Company F Offer 1
> Offer 1 2
> 25 Company B Offer 2
> 25 Company C Offer 2
> 25 Company E Offer 2
> Offer 2 3
> 25 Company D Offer 3
> Offer 3 1
> Companies Mailed for Branch 25 6
> I actually gave the account rep this report. It will give the client the
> data that they need while I try to figure out how to get in the other format.
> If that is not what you were talkng about, let me know.
> Thanks,
> --
> Dan D.
>
> "Josh" wrote:
> >
> > Dan,
> >
> > This would create a slightly different format, but I don't think they
> > would be disappointed.
> >
> > Group by Branch # and then group by Offer. You can enable drill-down if
> > you want, but either way this will allow you to do summaries at each of
> > the grouping levels. You can use various combinations of Count and
> > Countdistinct in the group headers to provide the summary information.
> >
> > -Josh
> >
> >
> > Dan D. wrote:
> > > Using SS2000, VS2003, RS2000.
> > > The report lists branches and the companies they have mailed to. The company
> > > mailed to could have received one of three offers. I need to get a count of
> > > how many companies were mailed to by each branch and how many of each offer
> > > was mailed for each branch. The client wants to show the report.like this:
> > >
> > > Branch # Company Mailed Offer
> > > 25 Company A Offer 1
> > > 25 Company B Offer 2
> > > 25 Company C Offer 2
> > > 25 Company D Offer 3
> > > 25 Company E Offer 2
> > > 25 Company F Offer 1
> > > Companies Mailed for Branch 25 6
> > > Offer 1 2
> > > Offer 2 3
> > > Offer 3 1
> > >
> > >
> > > 33 Company G Offer 1
> > > 33 Company H Offer 2
> > > 33 Company I Offer 2
> > > 33 Company J Offer 3
> > > 33 Company K Offer 2
> > > 33 Company L Offer 1
> > > 33 Company M Offer 2
> > > 33 Company N Offer 1
> > > Companies Mailed for Branch 33 8
> > > Offer 1 3
> > > Offer 2 4
> > > Offer 3 1
> > >
> > > I thought that if I created a group on the Branch # I would be able to count
> > > the number of companies mailed to and that works. But I can't figure out how
> > > to get the count for each kind of mailing. I thought about adding another row
> > > in the design for the same group of Branch # and then count for each kind of
> > > mailing by putting a filter on the group for "offer 1" but that didn't work.
> > > Is it possbile to put a filter on the count (i.e. Count(Fields!Offer.Value)
> > > Where Offer = 'Offer 1')?
> > >
> > > Thanks,
> > > --
> > > Dan D.
> >
> >|||*I hope that it does NOT truncate it. I mistyped that in the last
message.
-Josh
Josh wrote:
> Dan,
> That is kind of what I was picturing... I guess what I had in mind
> would look like this. In fact, to get the full effect, paste this into
> an HTML file and open it in Internet Explorer.
> I hope that it does truncate it...
> <html xmlns:o="urn:schemas-microsoft-com:office:office"
> xmlns:x="urn:schemas-microsoft-com:office:excel"
> xmlns="">http://www.w3.org/TR/REC-html40">
> <head>
> <meta http-equiv=Content-Type content="text/html;
> charset=windows-1252">
> <meta name=ProgId content=Excel.Sheet>
> <meta name=Generator content="Microsoft Excel 9">
> <link rel=File-List href="http://links.10026.com/?link=./Book1_files/filelist.xml">
> <link rel=Edit-Time-Data href="http://links.10026.com/?link=./Book1_files/editdata.mso">
> <link rel=OLE-Object-Data href="http://links.10026.com/?link=./Book1_files/oledata.mso">
> <!--[if gte mso 9]><xml>
> <o:DocumentProperties>
> <o:Author>Administrator</o:Author>
> <o:LastAuthor>Administrator</o:LastAuthor>
> <o:Created>2006-08-11T20:19:33Z</o:Created>
> <o:LastSaved>2006-08-11T20:33:17Z</o:LastSaved>
> <o:Company>BCBST</o:Company>
> <o:Version>9.6926</o:Version>
> </o:DocumentProperties>
> <o:OfficeDocumentSettings>
> <o:DownloadComponents/>
> <o:LocationOfComponents href="http://links.10026.com/?link=file:msowc.cab"/>
> </o:OfficeDocumentSettings>
> </xml><![endif]-->
> <style>
> <!--table
> {mso-displayed-decimal-separator:"\.";
> mso-displayed-thousand-separator:"\,";}
> @.page
> {margin:1.0in .75in 1.0in .75in;
> mso-header-margin:.5in;
> mso-footer-margin:.5in;}
> tr
> {mso-height-source:auto;}
> col
> {mso-width-source:auto;}
> br
> {mso-data-placement:same-cell;}
> .style0
> {mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> white-space:nowrap;
> mso-rotate:0;
> mso-background-source:auto;
> mso-pattern:auto;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> border:none;
> mso-protection:locked visible;
> mso-style-name:Normal;
> mso-style-id:0;}
> td
> {mso-style-parent:style0;
> padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> border:none;
> mso-background-source:auto;
> mso-pattern:auto;
> mso-protection:locked visible;
> white-space:nowrap;
> mso-rotate:0;}
> .xl24
> {mso-style-parent:style0;
> color:white;
> font-family:Arial, sans-serif;
> mso-font-charset:0;
> text-align:left;
> background:gray;
> mso-pattern:auto none;}
> .xl25
> {mso-style-parent:style0;
> text-align:left;}
> .xl26
> {mso-style-parent:style0;
> color:white;
> font-family:Arial, sans-serif;
> mso-font-charset:0;
> text-align:left;
> border-top:none;
> border-right:none;
> border-bottom:1.0pt solid windowtext;
> border-left:none;
> background:#333399;
> mso-pattern:auto none;}
> .xl27
> {mso-style-parent:style0;
> text-align:left;
> background:#99CCFF;
> mso-pattern:auto none;}
> -->
> </style>
> <!--[if gte mso 9]><xml>
> <x:ExcelWorkbook>
> <x:ExcelWorksheets>
> <x:ExcelWorksheet>
> <x:Name>Sheet1</x:Name>
> <x:WorksheetOptions>
> <x:Print>
> <x:ValidPrinterInfo/>
> <x:HorizontalResolution>600</x:HorizontalResolution>
> <x:VerticalResolution>600</x:VerticalResolution>
> </x:Print>
> <x:Selected/>
> <x:Panes>
> <x:Pane>
> <x:Number>3</x:Number>
> <x:ActiveRow>27</x:ActiveRow>
> </x:Pane>
> </x:Panes>
> <x:ProtectContents>False</x:ProtectContents>
> <x:ProtectObjects>False</x:ProtectObjects>
> <x:ProtectScenarios>False</x:ProtectScenarios>
> </x:WorksheetOptions>
> </x:ExcelWorksheet>
> <x:ExcelWorksheet>
> <x:Name>Sheet2</x:Name>
> <x:WorksheetOptions>
> <x:ProtectContents>False</x:ProtectContents>
> <x:ProtectObjects>False</x:ProtectObjects>
> <x:ProtectScenarios>False</x:ProtectScenarios>
> </x:WorksheetOptions>
> </x:ExcelWorksheet>
> <x:ExcelWorksheet>
> <x:Name>Sheet3</x:Name>
> <x:WorksheetOptions>
> <x:ProtectContents>False</x:ProtectContents>
> <x:ProtectObjects>False</x:ProtectObjects>
> <x:ProtectScenarios>False</x:ProtectScenarios>
> </x:WorksheetOptions>
> </x:ExcelWorksheet>
> </x:ExcelWorksheets>
> <x:WindowHeight>10110</x:WindowHeight>
> <x:WindowWidth>17100</x:WindowWidth>
> <x:WindowTopX>120</x:WindowTopX>
> <x:WindowTopY>15</x:WindowTopY>
> <x:ProtectStructure>False</x:ProtectStructure>
> <x:ProtectWindows>False</x:ProtectWindows>
> </x:ExcelWorkbook>
> </xml><![endif]-->
> </head>
> <body link=blue vlink=purple>
> <table x:str border=0 cellpadding=0 cellspacing=0 width=343
> style='border-collapse:
> collapse;table-layout:fixed;width:257pt'>
> <col class=xl25 width=95
> style='mso-width-source:userset;mso-width-alt:3474;
> width:71pt'>
> <col class=xl25 width=119
> style='mso-width-source:userset;mso-width-alt:4352;
> width:89pt'>
> <col class=xl25 width=129
> style='mso-width-source:userset;mso-width-alt:4717;
> width:97pt'>
> <tr height=18 style='height:13.5pt'>
> <td height=18 class=xl26 width=95
> style='height:13.5pt;width:71pt'>Branch ID</td>
> <td class=xl26 width=119 style='width:89pt'>Offer</td>
> <td class=xl26 width=129 style='width:97pt'>Company</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 class=xl24 style='height:12.75pt' x:num>25</td>
> <td class=xl24>( 3 Offer Types )</td>
> <td class=xl24>( 6 Companies )</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 class=xl25 style='height:12.75pt'></td>
> <td class=xl27>Offer 1</td>
> <td class=xl27>( 2 Companies )</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 colspan=2 class=xl25
> style='height:12.75pt;mso-ignore:colspan'></td>
> <td class=xl25>Company A</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 colspan=2 class=xl25
> style='height:12.75pt;mso-ignore:colspan'></td>
> <td class=xl25>Company F</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 class=xl25 style='height:12.75pt'></td>
> <td class=xl27>Offer 2</td>
> <td class=xl27>( 3 Companies )</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 colspan=2 class=xl25
> style='height:12.75pt;mso-ignore:colspan'></td>
> <td class=xl25>Company B</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 colspan=2 class=xl25
> style='height:12.75pt;mso-ignore:colspan'></td>
> <td class=xl25>Company C</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 colspan=2 class=xl25
> style='height:12.75pt;mso-ignore:colspan'></td>
> <td class=xl25>Company E</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 class=xl25 style='height:12.75pt'></td>
> <td class=xl27>Offer 3</td>
> <td class=xl27>( 1 Company )</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 colspan=2 class=xl25
> style='height:12.75pt;mso-ignore:colspan'></td>
> <td class=xl25>Company D</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 class=xl24 style='height:12.75pt' x:num>33</td>
> <td class=xl24>( 3 Offer Types )</td>
> <td class=xl24>( 8 Companies )</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 class=xl25 style='height:12.75pt'></td>
> <td class=xl27>Offer 1</td>
> <td class=xl27>( 3 Companies )</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 colspan=2 class=xl25
> style='height:12.75pt;mso-ignore:colspan'></td>
> <td class=xl25>Company G</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 colspan=2 class=xl25
> style='height:12.75pt;mso-ignore:colspan'></td>
> <td class=xl25>Company L</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 colspan=2 class=xl25
> style='height:12.75pt;mso-ignore:colspan'></td>
> <td class=xl25>Company N</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 class=xl25 style='height:12.75pt'></td>
> <td class=xl27>Offer 2</td>
> <td class=xl27>( 4 Companies )</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 colspan=2 class=xl25
> style='height:12.75pt;mso-ignore:colspan'></td>
> <td class=xl25>Company H</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 colspan=2 class=xl25
> style='height:12.75pt;mso-ignore:colspan'></td>
> <td class=xl25>Company I</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 colspan=2 class=xl25
> style='height:12.75pt;mso-ignore:colspan'></td>
> <td class=xl25>Company K</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 colspan=2 class=xl25
> style='height:12.75pt;mso-ignore:colspan'></td>
> <td class=xl25>Company M</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 class=xl25 style='height:12.75pt'></td>
> <td class=xl27>Offer 3</td>
> <td class=xl27>( 1 Company )</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 colspan=2 class=xl25
> style='height:12.75pt;mso-ignore:colspan'></td>
> <td class=xl25>Company J</td>
> </tr>
> <![if supportMisalignedColumns]>
> <tr height=0 style='display:none'>
> <td width=95 style='width:71pt'></td>
> <td width=119 style='width:89pt'></td>
> <td width=129 style='width:97pt'></td>
> </tr>
> <![endif]>
> </table>
> </body>
> </html>
> As you might have noticed, I like having the summary info in the
> Headers because that is what most people are looking for. I don't
> typically use Footers when I enable drill-down because it gives it a
> "cleaner" look. It's like, "here is the summary, and then here is the
> data that goes with it."
> Hope this helps!
> -Josh
>
> Dan D. wrote:
> > If I understand what you're suggesting, I tried it and it looks like this:
> > Branch # Company Mailed Offer
> > 25 Company A Offer 1
> > 25 Company F Offer 1
> > Offer 1 2
> >
> > 25 Company B Offer 2
> > 25 Company C Offer 2
> > 25 Company E Offer 2
> > Offer 2 3
> >
> > 25 Company D Offer 3
> > Offer 3 1
> >
> > Companies Mailed for Branch 25 6
> >
> > I actually gave the account rep this report. It will give the client the
> > data that they need while I try to figure out how to get in the other format.
> > If that is not what you were talkng about, let me know.
> >
> > Thanks,
> >
> > --
> > Dan D.
> >
> >
> > "Josh" wrote:
> >
> > >
> > > Dan,
> > >
> > > This would create a slightly different format, but I don't think they
> > > would be disappointed.
> > >
> > > Group by Branch # and then group by Offer. You can enable drill-down if
> > > you want, but either way this will allow you to do summaries at each of
> > > the grouping levels. You can use various combinations of Count and
> > > Countdistinct in the group headers to provide the summary information.
> > >
> > > -Josh
> > >
> > >
> > > Dan D. wrote:
> > > > Using SS2000, VS2003, RS2000.
> > > > The report lists branches and the companies they have mailed to. The company
> > > > mailed to could have received one of three offers. I need to get a count of
> > > > how many companies were mailed to by each branch and how many of each offer
> > > > was mailed for each branch. The client wants to show the report.like this:
> > > >
> > > > Branch # Company Mailed Offer
> > > > 25 Company A Offer 1
> > > > 25 Company B Offer 2
> > > > 25 Company C Offer 2
> > > > 25 Company D Offer 3
> > > > 25 Company E Offer 2
> > > > 25 Company F Offer 1
> > > > Companies Mailed for Branch 25 6
> > > > Offer 1 2
> > > > Offer 2 3
> > > > Offer 3 1
> > > >
> > > >
> > > > 33 Company G Offer 1
> > > > 33 Company H Offer 2
> > > > 33 Company I Offer 2
> > > > 33 Company J Offer 3
> > > > 33 Company K Offer 2
> > > > 33 Company L Offer 1
> > > > 33 Company M Offer 2
> > > > 33 Company N Offer 1
> > > > Companies Mailed for Branch 33 8
> > > > Offer 1 3
> > > > Offer 2 4
> > > > Offer 3 1
> > > >
> > > > I thought that if I created a group on the Branch # I would be able to count
> > > > the number of companies mailed to and that works. But I can't figure out how
> > > > to get the count for each kind of mailing. I thought about adding another row
> > > > in the design for the same group of Branch # and then count for each kind of
> > > > mailing by putting a filter on the group for "offer 1" but that didn't work.
> > > > Is it possbile to put a filter on the count (i.e. Count(Fields!Offer.Value)
> > > > Where Offer = 'Offer 1')?
> > > >
> > > > Thanks,
> > > > --
> > > > Dan D.
> > >
> > >|||Yours didn't truncate. This is what the client wants. I've read a little
about subreports and I'm wondering if that might get me what I need. Thanks.
<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="">http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 10">
<link rel=File-List href="http://links.10026.com/?link=billingtest2_files/filelist.xml">
<link rel=Edit-Time-Data href="http://links.10026.com/?link=billingtest2_files/editdata.mso">
<link rel=OLE-Object-Data href="http://links.10026.com/?link=billingtest2_files/oledata.mso">
<!--[if gte mso 9]><xml>
<o:DocumentProperties>
<o:Author>Administrator</o:Author>
<o:LastAuthor>dan donahue</o:LastAuthor>
<o:Created>2006-08-11T20:19:33Z</o:Created>
<o:LastSaved>2006-08-14T13:24:02Z</o:LastSaved>
<o:Company>BCBST</o:Company>
<o:Version>10.6735</o:Version>
</o:DocumentProperties>
<o:OfficeDocumentSettings>
<o:DownloadComponents/>
<o:LocationOfComponents href="http://links.10026.com/?link=file:///\\msowc.cab"/>
</o:OfficeDocumentSettings>
</xml><![endif]-->
<style>
<!--
..style0
{mso-number-format:General;
text-align:general;
vertical-align:bottom;
white-space:nowrap;
mso-rotate:0;
mso-background-source:auto;
mso-pattern:auto;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
border:none;
mso-protection:locked visible;
mso-style-name:Normal;
mso-style-id:0;}
..xl24
{mso-style-parent:style0;
color:white;
font-family:Arial, sans-serif;
mso-font-charset:0;
text-align:left;
background:gray;
mso-pattern:auto none;}
..xl25
{mso-style-parent:style0;
text-align:left;}
..xl26
{mso-style-parent:style0;
color:white;
font-family:Arial, sans-serif;
mso-font-charset:0;
text-align:left;
border-top:none;
border-right:none;
border-bottom:1.0pt solid windowtext;
border-left:none;
background:#333399;
mso-pattern:auto none;}
..xl27
{mso-style-parent:style0;
text-align:left;
background:#99CCFF;
mso-pattern:auto none;}
table
{mso-displayed-decimal-separator:"\.";
mso-displayed-thousand-separator:"\,";}
@.page
{margin:1.0in .75in 1.0in .75in;
mso-header-margin:.5in;
mso-footer-margin:.5in;}
tr
{mso-height-source:auto;}
col
{mso-width-source:auto;}
br
{mso-data-placement:same-cell;}
.style0
{mso-number-format:General;
text-align:general;
vertical-align:bottom;
white-space:nowrap;
mso-rotate:0;
mso-background-source:auto;
mso-pattern:auto;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
border:none;
mso-protection:locked visible;
mso-style-name:Normal;
mso-style-id:0;}
td
{mso-style-parent:style0;
padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
border:none;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:locked visible;
white-space:nowrap;
mso-rotate:0;}
.xl24
{mso-style-parent:style0;
background:#3366FF;
mso-pattern:auto none;}
.xl25
{mso-style-parent:style0;
background:silver;
mso-pattern:auto none;}
-->
</style>
<!--[if gte mso 9]><xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>Sheet1</x:Name>
<x:WorksheetOptions>
<x:Print>
<x:ValidPrinterInfo/>
<x:HorizontalResolution>600</x:HorizontalResolution>
<x:VerticalResolution>600</x:VerticalResolution>
</x:Print>
<x:Selected/>
<x:Panes>
<x:Pane>
<x:Number>3</x:Number>
<x:ActiveRow>3</x:ActiveRow>
<x:ActiveCol>1</x:ActiveCol>
</x:Pane>
</x:Panes>
<x:ProtectContents>False</x:ProtectContents>
<x:ProtectObjects>False</x:ProtectObjects>
<x:ProtectScenarios>False</x:ProtectScenarios>
</x:WorksheetOptions>
</x:ExcelWorksheet>
<x:ExcelWorksheet>
<x:Name>Sheet2</x:Name>
<x:WorksheetOptions>
<x:ProtectContents>False</x:ProtectContents>
<x:ProtectObjects>False</x:ProtectObjects>
<x:ProtectScenarios>False</x:ProtectScenarios>
</x:WorksheetOptions>
</x:ExcelWorksheet>
<x:ExcelWorksheet>
<x:Name>Sheet3</x:Name>
<x:WorksheetOptions>
<x:ProtectContents>False</x:ProtectContents>
<x:ProtectObjects>False</x:ProtectObjects>
<x:ProtectScenarios>False</x:ProtectScenarios>
</x:WorksheetOptions>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
<x:WindowHeight>10110</x:WindowHeight>
<x:WindowWidth>17100</x:WindowWidth>
<x:WindowTopX>120</x:WindowTopX>
<x:WindowTopY>15</x:WindowTopY>
<x:ProtectStructure>False</x:ProtectStructure>
<x:ProtectWindows>False</x:ProtectWindows>
</x:ExcelWorkbook>
</xml><![endif]-->
</head>
<body link=blue vlink=purple>
<table x:str border=0 cellpadding=0 cellspacing=0 width=343
style='border-collapse:
collapse;table-layout:fixed;width:257pt'>
<col width=95 style='mso-width-source:userset;mso-width-alt:3474;width:71pt'>
<col width=119
style='mso-width-source:userset;mso-width-alt:4352;width:89pt'>
<col width=129
style='mso-width-source:userset;mso-width-alt:4717;width:97pt'>
<tr class=xl24 height=17 style='height:12.75pt'>
<td height=17 class=xl24 width=95 style='height:12.75pt;width:71pt'>Branch
ID</td>
<td class=xl24 width=119 style='width:89pt'>Offer</td>
<td class=xl24 width=129 style='width:97pt'>Company</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=2 style='height:12.75pt;mso-ignore:colspan'></td>
<td>Company A</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=2 style='height:12.75pt;mso-ignore:colspan'></td>
<td>Company F</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=2 style='height:12.75pt;mso-ignore:colspan'></td>
<td>Company B</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=2 style='height:12.75pt;mso-ignore:colspan'></td>
<td>Company C</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=2 style='height:12.75pt;mso-ignore:colspan'></td>
<td>Company E</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=2 style='height:12.75pt;mso-ignore:colspan'></td>
<td>Company D</td>
</tr>
<tr class=xl25 height=17 style='height:12.75pt'>
<td height=17 class=xl25 align=right style='height:12.75pt' x:num>25</td>
<td class=xl25>( 3 Offer Types )</td>
<td class=xl25>( 6 Companies )</td>
</tr>
<tr class=xl25 height=17 style='height:12.75pt'>
<td height=17 class=xl25 style='height:12.75pt'> </td>
<td class=xl25>Offer 1</td>
<td class=xl25>( 2 Companies )</td>
</tr>
<tr class=xl25 height=17 style='height:12.75pt'>
<td height=17 class=xl25 style='height:12.75pt'> </td>
<td class=xl25>Offer 2</td>
<td class=xl25>( 3 Companies )</td>
</tr>
<tr class=xl25 height=17 style='height:12.75pt'>
<td height=17 class=xl25 style='height:12.75pt'> </td>
<td class=xl25>Offer 3</td>
<td class=xl25>( 1 Companies )</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=3 style='height:12.75pt;mso-ignore:colspan'></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=2 style='height:12.75pt;mso-ignore:colspan'></td>
<td>Company G</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=2 style='height:12.75pt;mso-ignore:colspan'></td>
<td>Company L</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=2 style='height:12.75pt;mso-ignore:colspan'></td>
<td>Company N</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=2 style='height:12.75pt;mso-ignore:colspan'></td>
<td>Company H</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=2 style='height:12.75pt;mso-ignore:colspan'></td>
<td>Company I</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=2 style='height:12.75pt;mso-ignore:colspan'></td>
<td>Company K</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=2 style='height:12.75pt;mso-ignore:colspan'></td>
<td>Company M</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=2 style='height:12.75pt;mso-ignore:colspan'></td>
<td>Company J</td>
</tr>
<tr class=xl25 height=17 style='height:12.75pt'>
<td height=17 class=xl25 align=right style='height:12.75pt' x:num>33</td>
<td class=xl25>( 3 Offer Types )</td>
<td class=xl25>( 8 Companies )</td>
</tr>
<tr class=xl25 height=17 style='height:12.75pt'>
<td height=17 class=xl25 style='height:12.75pt'> </td>
<td class=xl25>Offer 1</td>
<td class=xl25>( 3 Companies )</td>
</tr>
<tr class=xl25 height=17 style='height:12.75pt'>
<td height=17 class=xl25 style='height:12.75pt'> </td>
<td class=xl25>Offer 2</td>
<td class=xl25>( 4 Companies )</td>
</tr>
<tr class=xl25 height=17 style='height:12.75pt'>
<td height=17 class=xl25 style='height:12.75pt'> </td>
<td class=xl25>Offer 3</td>
<td class=xl25>( 1 Company )</td>
</tr>
<![if supportMisalignedColumns]>
<tr height=0 style='display:none'>
<td width=95 style='width:71pt'></td>
<td width=119 style='width:89pt'></td>
<td width=129 style='width:97pt'></td>
</tr>
<![endif]>
</table>
</body>
</html>
--
Dan D.
"Josh" wrote:
> Dan,
> That is kind of what I was picturing... I guess what I had in mind
> would look like this. In fact, to get the full effect, paste this into
> an HTML file and open it in Internet Explorer.
> I hope that it does truncate it...
> <html xmlns:o="urn:schemas-microsoft-com:office:office"
> xmlns:x="urn:schemas-microsoft-com:office:excel"
> xmlns="">http://www.w3.org/TR/REC-html40">
> <head>
> <meta http-equiv=Content-Type content="text/html;
> charset=windows-1252">
> <meta name=ProgId content=Excel.Sheet>
> <meta name=Generator content="Microsoft Excel 9">
> <link rel=File-List href="http://links.10026.com/?link=./Book1_files/filelist.xml">
> <link rel=Edit-Time-Data href="http://links.10026.com/?link=./Book1_files/editdata.mso">
> <link rel=OLE-Object-Data href="http://links.10026.com/?link=./Book1_files/oledata.mso">
> <!--[if gte mso 9]><xml>
> <o:DocumentProperties>
> <o:Author>Administrator</o:Author>
> <o:LastAuthor>Administrator</o:LastAuthor>
> <o:Created>2006-08-11T20:19:33Z</o:Created>
> <o:LastSaved>2006-08-11T20:33:17Z</o:LastSaved>
> <o:Company>BCBST</o:Company>
> <o:Version>9.6926</o:Version>
> </o:DocumentProperties>
> <o:OfficeDocumentSettings>
> <o:DownloadComponents/>
> <o:LocationOfComponents href="http://links.10026.com/?link=file:msowc.cab"/>
> </o:OfficeDocumentSettings>
> </xml><![endif]-->
> <style>
> <!--table
> {mso-displayed-decimal-separator:"\.";
> mso-displayed-thousand-separator:"\,";}
> @.page
> {margin:1.0in .75in 1.0in .75in;
> mso-header-margin:.5in;
> mso-footer-margin:.5in;}
> tr
> {mso-height-source:auto;}
> col
> {mso-width-source:auto;}
> br
> {mso-data-placement:same-cell;}
> ..style0
> {mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> white-space:nowrap;
> mso-rotate:0;
> mso-background-source:auto;
> mso-pattern:auto;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> border:none;
> mso-protection:locked visible;
> mso-style-name:Normal;
> mso-style-id:0;}
> td
> {mso-style-parent:style0;
> padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> border:none;
> mso-background-source:auto;
> mso-pattern:auto;
> mso-protection:locked visible;
> white-space:nowrap;
> mso-rotate:0;}
> ..xl24
> {mso-style-parent:style0;
> color:white;
> font-family:Arial, sans-serif;
> mso-font-charset:0;
> text-align:left;
> background:gray;
> mso-pattern:auto none;}
> ..xl25
> {mso-style-parent:style0;
> text-align:left;}
> ..xl26
> {mso-style-parent:style0;
> color:white;
> font-family:Arial, sans-serif;
> mso-font-charset:0;
> text-align:left;
> border-top:none;
> border-right:none;
> border-bottom:1.0pt solid windowtext;
> border-left:none;
> background:#333399;
> mso-pattern:auto none;}
> ..xl27
> {mso-style-parent:style0;
> text-align:left;
> background:#99CCFF;
> mso-pattern:auto none;}
> -->
> </style>
> <!--[if gte mso 9]><xml>
> <x:ExcelWorkbook>
> <x:ExcelWorksheets>
> <x:ExcelWorksheet>
> <x:Name>Sheet1</x:Name>
> <x:WorksheetOptions>
> <x:Print>
> <x:ValidPrinterInfo/>
> <x:HorizontalResolution>600</x:HorizontalResolution>
> <x:VerticalResolution>600</x:VerticalResolution>
> </x:Print>
> <x:Selected/>
> <x:Panes>
> <x:Pane>
> <x:Number>3</x:Number>
> <x:ActiveRow>27</x:ActiveRow>
> </x:Pane>
> </x:Panes>
> <x:ProtectContents>False</x:ProtectContents>
> <x:ProtectObjects>False</x:ProtectObjects>
> <x:ProtectScenarios>False</x:ProtectScenarios>
> </x:WorksheetOptions>
> </x:ExcelWorksheet>
> <x:ExcelWorksheet>
> <x:Name>Sheet2</x:Name>
> <x:WorksheetOptions>
> <x:ProtectContents>False</x:ProtectContents>
> <x:ProtectObjects>False</x:ProtectObjects>
> <x:ProtectScenarios>False</x:ProtectScenarios>
> </x:WorksheetOptions>
> </x:ExcelWorksheet>
> <x:ExcelWorksheet>
> <x:Name>Sheet3</x:Name>
> <x:WorksheetOptions>
> <x:ProtectContents>False</x:ProtectContents>
> <x:ProtectObjects>False</x:ProtectObjects>
> <x:ProtectScenarios>False</x:ProtectScenarios>
> </x:WorksheetOptions>
> </x:ExcelWorksheet>
> </x:ExcelWorksheets>
> <x:WindowHeight>10110</x:WindowHeight>
> <x:WindowWidth>17100</x:WindowWidth>
> <x:WindowTopX>120</x:WindowTopX>
> <x:WindowTopY>15</x:WindowTopY>
> <x:ProtectStructure>False</x:ProtectStructure>
> <x:ProtectWindows>False</x:ProtectWindows>
> </x:ExcelWorkbook>
> </xml><![endif]-->
> </head>
> <body link=blue vlink=purple>
> <table x:str border=0 cellpadding=0 cellspacing=0 width=343
> style='border-collapse:
> collapse;table-layout:fixed;width:257pt'>
> <col class=xl25 width=95
> style='mso-width-source:userset;mso-width-alt:3474;
> width:71pt'>
> <col class=xl25 width=119
> style='mso-width-source:userset;mso-width-alt:4352;
> width:89pt'>
> <col class=xl25 width=129
> style='mso-width-source:userset;mso-width-alt:4717;
> width:97pt'>
> <tr height=18 style='height:13.5pt'>
> <td height=18 class=xl26 width=95
> style='height:13.5pt;width:71pt'>Branch ID</td>
> <td class=xl26 width=119 style='width:89pt'>Offer</td>
> <td class=xl26 width=129 style='width:97pt'>Company</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 class=xl24 style='height:12.75pt' x:num>25</td>
> <td class=xl24>( 3 Offer Types )</td>
> <td class=xl24>( 6 Companies )</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 class=xl25 style='height:12.75pt'></td>
> <td class=xl27>Offer 1</td>
> <td class=xl27>( 2 Companies )</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 colspan=2 class=xl25
> style='height:12.75pt;mso-ignore:colspan'></td>
> <td class=xl25>Company A</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 colspan=2 class=xl25
> style='height:12.75pt;mso-ignore:colspan'></td>
> <td class=xl25>Company F</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 class=xl25 style='height:12.75pt'></td>
> <td class=xl27>Offer 2</td>
> <td class=xl27>( 3 Companies )</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 colspan=2 class=xl25
> style='height:12.75pt;mso-ignore:colspan'></td>
> <td class=xl25>Company B</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 colspan=2 class=xl25
> style='height:12.75pt;mso-ignore:colspan'></td>
> <td class=xl25>Company C</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 colspan=2 class=xl25
> style='height:12.75pt;mso-ignore:colspan'></td>
> <td class=xl25>Company E</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 class=xl25 style='height:12.75pt'></td>
> <td class=xl27>Offer 3</td>
> <td class=xl27>( 1 Company )</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 colspan=2 class=xl25
> style='height:12.75pt;mso-ignore:colspan'></td>
> <td class=xl25>Company D</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 class=xl24 style='height:12.75pt' x:num>33</td>
> <td class=xl24>( 3 Offer Types )</td>
> <td class=xl24>( 8 Companies )</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 class=xl25 style='height:12.75pt'></td>
> <td class=xl27>Offer 1</td>
> <td class=xl27>( 3 Companies )</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 colspan=2 class=xl25
> style='height:12.75pt;mso-ignore:colspan'></td>
> <td class=xl25>Company G</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 colspan=2 class=xl25
> style='height:12.75pt;mso-ignore:colspan'></td>
> <td class=xl25>Company L</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 colspan=2 class=xl25
> style='height:12.75pt;mso-ignore:colspan'></td>
> <td class=xl25>Company N</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 class=xl25 style='height:12.75pt'></td>
> <td class=xl27>Offer 2</td>
> <td class=xl27>( 4 Companies )</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 colspan=2 class=xl25
> style='height:12.75pt;mso-ignore:colspan'></td>
> <td class=xl25>Company H</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 colspan=2 class=xl25
> style='height:12.75pt;mso-ignore:colspan'></td>
> <td class=xl25>Company I</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 colspan=2 class=xl25
> style='height:12.75pt;mso-ignore:colspan'></td>
> <td class=xl25>Company K</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 colspan=2 class=xl25
> style='height:12.75pt;mso-ignore:colspan'></td>
> <td class=xl25>Company M</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 class=xl25 style='height:12.75pt'></td>
> <td class=xl27>Offer 3</td>
> <td class=xl27>( 1 Company )</td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 colspan=2 class=xl25
> style='height:12.75pt;mso-ignore:colspan'></td>
> <td class=xl25>Company J</td>|||Try to use list .Group the List on Branch
1) One table for all the data
2) Second matrix or Matrix for the Count (Hide the Headings)
3)Third table or Matrx for Each offer grouped(row group on
Offer)
Regards
Raj deep.A|||Thanks for the suggestion. I'll give it a try.
--
Dan D.
"RajDeep" wrote:
> Try to use list .Group the List on Branch
> 1) One table for all the data
> 2) Second matrix or Matrix for the Count (Hide the Headings)
> 3)Third table or Matrx for Each offer grouped(row group on
> Offer)
> Regards
> Raj deep.A
>

Is this piece of code dangerous?

I'm building a site, and while stress testing it I received a few exceptions when the SQL Server was under relatively high load. Originally I was opening the connection when required in a particular Sub as follows (and then closing it when I was finished with it):

If Not MyConnection.State = ConnectionState.Open Then MyConnection.Open()

The probelm however was that from time to time the connection state was Opening instead of Closed or Open. So I am considering using the following piece of code instead:

If MyConnection.State = ConnectionState.Connecting Then
Do Until MyConnection.State = ConnectionState.Open

Loop
ElseIf MyConnection.State = ConnectionState.Broken Or MyConnection.State = ConnectionState.Closed Then
MyConnection.Open()
End If

I'm a little worried about the Do...Loop in there, but I don't see how it should be a problem. Any thoughts?

plenderj:

If MyConnection.State = ConnectionState.Connecting Then
Do Until MyConnection.State = ConnectionState.Open

Loop

I'm a little worried about the Do...Loop in there, but I don't see how it should be a problem. Any thoughts?

Yes, it is a problem. While you're waiting, doing nothing, your thread is chewing up CPU, which could be better used by other threads and processes, including the SQL client. A much better solution would be to stick a Thread.Sleep(10) in your loop. It's a small enough interval that it won't hurt, but it won't peg your CPU at 100%.

A better solution yet would be to wait on the StateChange event of the connection, because then you wouldn't use ANY CPU while waiting on the connection, but it would require more code, and if this doesn't happen often, wouldn't buy you much.

|||

mpswaim:

A much better solution would be to stick a Thread.Sleep(10) in your loop. It's a small enough interval that it won't hurt, but it won't peg your CPU at 100%.

DOH! How did I forget about that lol. Thanks for spotting it :D