Report parameter

I have a stored procedure that works fine in reporting services. It grabs the total of Yes's and No's by dates . But then i went ahead and added 2 more parameters to the proc, and now the totals are all wrong. I dont understand how that can mess everything up. Here is the previous stored proc, that gives the correct sum. I just want to know what im doing wrong, that the totals are completely off now. Did i set up the parameter wrong in reporting services. I have the 3 parameters list in the report parameter section, and even have them cascading off of each other. That seems to work fine. but for the first matrix in my report, but the second matrix with this stored proc, is way off. Please help!!.

Code Snippet

ALTER PROCEDURE [dbo].[Testing_Questions_ALL_YESOrNO]

@.Question char(80)

AS

BEGIN

SELECT

Qry_Questions.Question

, Qry_Questions.Date

, Qry_Questions.response

, B.Total

FROM Qry_Questions

INNER JOIN Qry_Sales_Group

ON dbo.Qry_Questions.sales_person_code COLLATE SQL_Latin1_General_CP1_CI_AS = dbo.Qry_Sales_Group.SalesPerson_Purchaser_Code

INNER JOIN

( Select COUNT(qq.response)as Total, Question, Date, response

FROM Qry_Questions qq

Where qq.response in ('Yes','No')

GROUP by qq.[Question] , qq.Date,qq.response ) B

ON Qry_Questions.Date = B.Date AND

Qry_Questions.Question =B.Question and

Qry_Questions.response=B.response

WHERE Qry_Questions.[Response Type]='YesNo' and Qry_Questions.Question=@.Question

GROUP BY Qry_Questions.question,Qry_Questions.Date,Qry_questions.Response,B.Total

ORDER BY Qry_Questions.Question, Qry_Questions.Date

END

SET NOCOUNT OFF

Here is the edited version which only has two new parameters added to the proc. The edits are highlighted.

Code Snippet

ALTER PROCEDURE [dbo].[Testing_Questions_ALL_YESOrNO_Totals]

(@.Region_Key int=null,@.QuestionCode char(5),@.Question char(80))

AS

BEGIN

SELECT

Qry_Questions.Question

, Qry_Questions.Date

, Qry_Questions.response

, B.Total

FROM Qry_Questions

INNER JOIN Qry_Sales_Group

ON dbo.Qry_Questions.sales_person_code COLLATE SQL_Latin1_General_CP1_CI_AS = dbo.Qry_Sales_Group.SalesPerson_Purchaser_Code

INNER JOIN

( Select COUNT(qq.response)as Total, Question, Date, response

FROM Qry_Questions qq

Where qq.response in ('Yes','No')

GROUP by qq.[Question] , qq.Date,qq.response ) B

ON Qry_Questions.Date = B.Date AND

Qry_Questions.Question =B.Question and

Qry_Questions.response=B.response

WHERE Qry_Questions.[Response Type]='YesNo'

AND REGION_KEY=@.Region_Key

AND LEFT(Qry_Questions.[Question Code],2)IN (@.QuestionCode)

AND Qry_Questions.Question=@.Question

GROUP BY Qry_Questions.question,Qry_Questions.Date,Qry_questions.Response,B.Total

ORDER BY Qry_Questions.Question, Qry_Questions.Date

END

SET NOCOUNT OFF

Try this:

AND (@.Region_Key is null or REGION_KEY=@.Region_Key)

BobP

Report Manager Home page is incomplete

First off, forgive the ignorance that I'm sure to display in this post. I'm a total newbie with SRSS and have been using it to follow along with the tutorials offered via the SQL Express website. I'm using it strictly for learning on my local machine for the time being.

All had been working well with Reporting Services until I upgraded Vista Ultimate 64-bit (which was running in free 30-day trial unactivated Evaluation mode) sideways to Vista Ultimate Upgrade Edition 64-bit Edition. (Sounds confusing, I know.) I also subsequently installed a SQL Server 2k5 critical update which was recommended by Windows Update.

Now when I attempt to access Report Manager via localhost the "Home page" is incomplete, showing only the SSRS "Home" page header. There are no properites, data sources, config options, etc. outside of links for "Home|Help". I am running IE as an Admin and all the Reporting Services Configuration settings are green.

Also, when I attempt to deploy from VS 2005 I now receive the error: "Permissions granted to user 'NT Authority\Network Service' are insufficient ..."

Some of the settings inside the Report Sever Config are as follows:

Windows Service Identity:

Service Acct: NT Authority\Network Service; Built-in Account: Network Service

Web Service Identity:

Asp.net Service Account; NT Authority\Network Service; Report Server and Manager are both using Classic.Net AppPool

I've attempted for hours to weed through Google and this forum but have repeatedly wound up back where I started and more confused than when I started. I would deeply appreciate any help in resolving this matter.

I just spent two weeks figuring it out. I have a thread on here somewhere called "Vista & SSRS". It's not like one would expect Microsoft to be able to install their own software properly onto their own OS.....

I had to add both Report Mgr & Reporting Services to the Classic .net pool (whatever that is...it's in SSRS config)

I had to turn off that annoying thingie MS added to Vista to make it impossible to do anything - the thing Apple makes fun of in their commercials.

I had to add my user account and adin acct to the IIS user group

I had to install every IIS option, basic install leaves some out.

I think that was all.....good luck

|||

Thanks for the tips, JohnSLG. I had already done all but adding my user and admin accounts to the IIS User group. Unfortunately, my problem is still not resolved.

Just going to have to keep trolling here and Google in the hopes to find an answer. What twists my noodle more than anything is that I went through a helluva long and frustrating effort to get SRSS working before I had to upgrade Vista.

|||

I'm now just so flippin' lost ... Was finally able to access Report Manager after I created a new application pools from the RS Config Manager but then was unable to deploy reports from VS2005 and receive error message that "Report Server Web Service is unable to access secure ... verify WebServiceAccount is specified correctly in report server config file". Then I implusively hit "apply default settings" checkbox and then Apply and now I'm back where I started.

The simple fact is that I can no longer keep track of all the various settings I've changed from IIS Manager to RSConfig Manager to rsreportsever.config, user security settings, new app pools, etc. I'd like to start from scratch. removing every app pool every report server etc but that does not work because that stuff shows up again in RS Config Manager even after uninstall/reinstall. I simply don't know how to remove every last scrap and start the whole damn thing from scratch with the defaults. In short, I'm just in over my head and confused.

Think I'm going back to Access databases where I at least know what in the heck I'm doing. Right now, I'm just simply compounding problems by willy-nilly following every seemingly related tip I find on this board. It's my ignorance, but MS really could have done a much better job in making Reporting Services much less complicated with a simple to follow step by step install and configure instructions for those with my specific setup. I've got Vista Ultimate 64-bit edition with SQL Server 2005 Express SP2 and VS Studio 2005 and all I want to do is run the dam thing on my local machine so I can learn how it works. I want to be able to access the Report Manager via localhost\reports and be able to deploy reports from VS2005. Having to mess around with all these relatively arcane configuration and network settings is a royal pain in the rump.

/frustrated whining and moaning

|||

I hear you....I'm not sure exactly what I did to finally get it to work for me, but I think it was adding the admin user account to the IIS group. I've since dumped Vista 64 - it's ***, no drivers, buggy and went back to Vista - probably should have gone back to XP....I had to go through the same gyrations to get report manager to work again.....fortunately it worked for me after following my 4 step program.

I don't know why Microsoft cannot install their own software on their own operating systems.

Report Manager Home page is incomplete

First off, forgive the ignorance that I'm sure to display in this post. I'm a total newbie with SRSS and have been using it to follow along with the tutorials offered via the SQL Express website. I'm using it strictly for learning on my local machine for the time being.

All had been working well with Reporting Services until I upgraded Vista Ultimate 64-bit (which was running in free 30-day trial unactivated Evaluation mode) sideways to Vista Ultimate Upgrade Edition 64-bit Edition. (Sounds confusing, I know.) I also subsequently installed a SQL Server 2k5 critical update which was recommended by Windows Update.

Now when I attempt to access Report Manager via localhost the "Home page" is incomplete, showing only the SSRS "Home" page header. There are no properites, data sources, config options, etc. outside of links for "Home|Help". I am running IE as an Admin and all the Reporting Services Configuration settings are green.

Also, when I attempt to deploy from VS 2005 I now receive the error: "Permissions granted to user 'NT Authority\Network Service' are insufficient ..."

Some of the settings inside the Report Sever Config are as follows:

Windows Service Identity:

Service Acct: NT Authority\Network Service; Built-in Account: Network Service

Web Service Identity:

Asp.net Service Account; NT Authority\Network Service; Report Server and Manager are both using Classic.Net AppPool

I've attempted for hours to weed through Google and this forum but have repeatedly wound up back where I started and more confused than when I started. I would deeply appreciate any help in resolving this matter.

I just spent two weeks figuring it out. I have a thread on here somewhere called "Vista & SSRS". It's not like one would expect Microsoft to be able to install their own software properly onto their own OS.....

I had to add both Report Mgr & Reporting Services to the Classic .net pool (whatever that is...it's in SSRS config)

I had to turn off that annoying thingie MS added to Vista to make it impossible to do anything - the thing Apple makes fun of in their commercials.

I had to add my user account and adin acct to the IIS user group

I had to install every IIS option, basic install leaves some out.

I think that was all.....good luck

|||

Thanks for the tips, JohnSLG. I had already done all but adding my user and admin accounts to the IIS User group. Unfortunately, my problem is still not resolved.

Just going to have to keep trolling here and Google in the hopes to find an answer. What twists my noodle more than anything is that I went through a helluva long and frustrating effort to get SRSS working before I had to upgrade Vista.

|||

I'm now just so flippin' lost ... Was finally able to access Report Manager after I created a new application pools from the RS Config Manager but then was unable to deploy reports from VS2005 and receive error message that "Report Server Web Service is unable to access secure ... verify WebServiceAccount is specified correctly in report server config file". Then I implusively hit "apply default settings" checkbox and then Apply and now I'm back where I started.

The simple fact is that I can no longer keep track of all the various settings I've changed from IIS Manager to RSConfig Manager to rsreportsever.config, user security settings, new app pools, etc. I'd like to start from scratch. removing every app pool every report server etc but that does not work because that stuff shows up again in RS Config Manager even after uninstall/reinstall. I simply don't know how to remove every last scrap and start the whole damn thing from scratch with the defaults. In short, I'm just in over my head and confused.

Think I'm going back to Access databases where I at least know what in the heck I'm doing. Right now, I'm just simply compounding problems by willy-nilly following every seemingly related tip I find on this board. It's my ignorance, but MS really could have done a much better job in making Reporting Services much less complicated with a simple to follow step by step install and configure instructions for those with my specific setup. I've got Vista Ultimate 64-bit edition with SQL Server 2005 Express SP2 and VS Studio 2005 and all I want to do is run the dam thing on my local machine so I can learn how it works. I want to be able to access the Report Manager via localhost\reports and be able to deploy reports from VS2005. Having to mess around with all these relatively arcane configuration and network settings is a royal pain in the rump.

/frustrated whining and moaning

|||

I hear you....I'm not sure exactly what I did to finally get it to work for me, but I think it was adding the admin user account to the IIS group. I've since dumped Vista 64 - it's ***, no drivers, buggy and went back to Vista - probably should have gone back to XP....I had to go through the same gyrations to get report manager to work again.....fortunately it worked for me after following my 4 step program.

I don't know why Microsoft cannot install their own software on their own operating systems.

Report Group Header and Footer

Hi,
I know group header has to be below table header. But my report output
is like this:
DA: 111 Wolfson
Store Num ABC
23 Y
24 Y
25 W
26 W
Total restaurants with ABC systems: 2
Total restaurants with No ABC systems: 0
Total restaurants with waivers for ABC systems: 2
DA: 121 Von
Store Num ABC
33 Y
34 N
35 W
Total restaurants with ABC systems: 1
Total restaurants with No ABC systems: 1
Total restaurants with waivers for ABC systems: 1
My questions are:
1. Is there anyway to show group information(in this case is DA
information) before table header?
2. Should I use the group footer or text box for the summary part?
3. How can I populate the values for the summary?
Thanks in advance.
DanniThe report at the end of this posting should demonstrate how to accomplish
how to do conditional summations in a table group footer. The key expression
is
=Count(iif(Fields!ABC.Value = "<Place Y, N, or W here",
Fields!ABC.Value, Nothing), "DistrictGroup").
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Danni Liao" <danniliao@.yahoo.com> wrote in message
news:9d716b4a.0408200942.1a399384@.posting.google.com...
> Hi,
> I know group header has to be below table header. But my report output
> is like this:
> DA: 111 Wolfson
> Store Num ABC
> 23 Y
> 24 Y
> 25 W
> 26 W
> Total restaurants with ABC systems: 2
> Total restaurants with No ABC systems: 0
> Total restaurants with waivers for ABC systems: 2
> DA: 121 Von
> Store Num ABC
> 33 Y
> 34 N
> 35 W
> Total restaurants with ABC systems: 1
> Total restaurants with No ABC systems: 1
> Total restaurants with waivers for ABC systems: 1
>
> My questions are:
> 1. Is there anyway to show group information(in this case is DA
> information) before table header?
> 2. Should I use the group footer or text box for the summary part?
> 3. How can I populate the values for the summary?
> Thanks in advance.
> Danni
ConditionalSummaryValues.rdl
----
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
tion"
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<PageHeader>
<PrintOnLastPage>true</PrintOnLastPage>
<PrintOnFirstPage>true</PrintOnFirstPage>
<Style />
<Height>0.375in</Height>
</PageHeader>
<RightMargin>1in</RightMargin>
<Body>
<ReportItems>
<Table Name="table1">
<Style />
<Header>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox31">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>29</ZIndex>
<rd:DefaultName>textbox31</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox4">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>28</ZIndex>
<rd:DefaultName>textbox4</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox3">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>27</ZIndex>
<rd:DefaultName>textbox3</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Header>
<Details>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="StoreNumber">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<TextAlign>Right</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>2</ZIndex>
<rd:DefaultName>StoreNumber</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!StoreNumber.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="ABC">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>1</ZIndex>
<rd:DefaultName>ABC</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!ABC.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox21">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<rd:DefaultName>textbox21</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Details>
<DataSetName>ABCSystems</DataSetName>
<Width>6.50001in</Width>
<TableGroups>
<TableGroup>
<Header>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox2">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>26</ZIndex>
<rd:DefaultName>textbox2</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>="DA: " & Fields!DistrictNumber.Value
& " " & Fields!DistrictName.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox11">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>25</ZIndex>
<rd:DefaultName>textbox11</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox12">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>24</ZIndex>
<rd:DefaultName>textbox12</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox16">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>23</ZIndex>
<rd:DefaultName>textbox16</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>Store Number</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox17">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>22</ZIndex>
<rd:DefaultName>textbox17</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>ABC</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox18">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>21</ZIndex>
<rd:DefaultName>textbox18</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Header>
<Grouping Name="DistrictGroup">
<GroupExpressions>
<GroupExpression>=Fields!DistrictNumber.Value</GroupExpression>
</GroupExpressions>
</Grouping>
<Footer>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox13">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>5</ZIndex>
<rd:DefaultName>textbox13</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox14">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>4</ZIndex>
<rd:DefaultName>textbox14</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox15">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>3</ZIndex>
<rd:DefaultName>textbox15</rd:DefaultName>
<Value />
<CanGrow>true</CanGrow>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox1">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>8</ZIndex>
<rd:DefaultName>textbox1</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>ABC System Summary</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox5">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>7</ZIndex>
<rd:DefaultName>textbox5</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox28">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>6</ZIndex>
<rd:DefaultName>textbox28</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox20">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>11</ZIndex>
<rd:DefaultName>textbox20</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>Total restaurants with</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox19">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>10</ZIndex>
<CanGrow>true</CanGrow>
<Value>=Count(iif(Fields!ABC.Value = "Y",
Fields!ABC.Value, Nothing), "DistrictGroup")</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox6">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>9</ZIndex>
<rd:DefaultName>textbox6</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox26">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>14</ZIndex>
<CanGrow>true</CanGrow>
<Value>Total restaurants without</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox27">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>13</ZIndex>
<CanGrow>true</CanGrow>
<Value>=Count(iif(Fields!ABC.Value = "N",
Fields!ABC.Value, Nothing), "DistrictGroup")</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox22">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>12</ZIndex>
<rd:DefaultName>textbox22</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox23">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>17</ZIndex>
<rd:DefaultName>textbox23</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>Total restaurants with waviers</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox29">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>16</ZIndex>
<CanGrow>true</CanGrow>
<Value>=Count(iif(Fields!ABC.Value = "W",
Fields!ABC.Value, Nothing), "DistrictGroup")</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox25">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>15</ZIndex>
<rd:DefaultName>textbox25</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Footer>
</TableGroup>
</TableGroups>
<Footer>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox7">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>20</ZIndex>
<rd:DefaultName>textbox7</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox8">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>19</ZIndex>
<rd:DefaultName>textbox8</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox9">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>18</ZIndex>
<rd:DefaultName>textbox9</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Footer>
<TableColumns>
<TableColumn>
<Width>2.16667in</Width>
</TableColumn>
<TableColumn>
<Width>2.16667in</Width>
</TableColumn>
<TableColumn>
<Width>2.16667in</Width>
</TableColumn>
</TableColumns>
</Table>
</ReportItems>
<Style />
<Height>2.5in</Height>
</Body>
<TopMargin>1in</TopMargin>
<DataSources>
<DataSource Name="TestData">
<rd:DataSourceID>125b03ad-d78e-4a50-ba57-e4d162f02d59</rd:DataSourceID>
<ConnectionProperties>
<DataProvider>SQL</DataProvider>
<ConnectString>data source=Localhost;initial
catalog=TestData</ConnectString>
<IntegratedSecurity>true</IntegratedSecurity>
</ConnectionProperties>
</DataSource>
</DataSources>
<Width>7.25001in</Width>
<DataSets>
<DataSet Name="ABCSystems">
<Fields>
<Field Name="DistrictName">
<DataField>DistrictName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="DistrictNumber">
<DataField>DistrictNumber</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="StoreNumber">
<DataField>StoreNumber</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="ABC">
<DataField>ABC</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>TestData</DataSourceName>
<CommandText>SELECT DistrictName, DistrictNumber, StoreNumber,
ABC
FROM ABCSystems</CommandText>
</Query>
</DataSet>
</DataSets>
<LeftMargin>1in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<rd:DrawGrid>true</rd:DrawGrid>
<rd:ReportID>fff9cc12-b0c8-4f96-81dc-db45f51fd131</rd:ReportID>
<BottomMargin>1in</BottomMargin>
<Language>en-US</Language>
</Report>|||Bruce,
Thanks very much. It works like a charm.
Danni