better method for DTS: 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">

<style>

</style>

</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">
> 
> <style>
> 
> </style>
> 
> </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">

<style>

</style>

</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">
> 
> <style>
> 
> </style>
> 
> </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
>

Monday, March 26, 2012

is this possible in RS?

No comments:

Post a Comment

better method for DTS

Blog Archive

About Me