Report Parameters

hello
i am building a report which is going to show me list of candidates from
different groups for that i have created a qurey that display group list. and
a qurey display orginal data (candidate list) my problem is i can only select
one group at time for report parameter from group list can i do multi select
from that report pls any one help me out
Adnan AwanOn Oct 4, 10:30 am, Adnan Awan <AdnanA...@.discussions.microsoft.com>
wrote:
> hello
> i am building a report which is going to show me list of candidates from
> different groups for that i have created a qurey that display group list. and
> a qurey display orginal data (candidate list) my problem is i can only select
> one group at time for report parameter from group list can i do multi select
> from that report pls any one help me out
> Adnan Awan
If I'm understanding you correctly, you can create a multi-select
parameter via the Report tab -> Report Parameters... Then in the
stored procedure/query that is sourcing the report, you can create a
while loop to split the multiselect items in the input stored
procedure parameter (normally delimited by commas). You could load a
temp table w/these values and then base your query on ...'where xxxxx
not in (select xxxxx from #SomeTempTable)', etc. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Report not using pagination properly

I have a portrait report that has 1 table with 1 hidden group header (for the Page Header to reference fields from) and 36 detail rows. My problem is that pagination is not working properly. Depending on the length of data in the detail rows, the report tends to push majority of data on the next page(s) which leaves a lot of blank lines or blank page at the beginning of each group of data. I want the data to complete the first page before rolling over to the next page. That's why I have 36 individual detail rows instead of all the data in 1 detail row. I've tried adjusting the page length, but it doesn't seem to work all that well. I either get all the report on one page (which is fine when viewing online, but data is cut off when printing) or inadequate pagination. I do not have any white space at the bottom of the table and the page footer. Anyone have any ideas?

Thanks,

T

Have you tried setting KeepTogether=false on your table? The behavior your describing sounds like it's set to true, which would mean that if the table can't fit completely on the current page, but will fit on the next page, it will move the table to the next page.

You shouldn't need to specify the detail rows individually if you're populating from a data source!|||Yes, KeepTogether is false and yes I am using a shared data source and data is queried using Stored Procedure.|||Well it seems the problem lies within the Group Header row. I removed that row and pagination works properly now, but I lose the ability to call fields in my page header when the report spans more than one page.|||

Ok, I found a solution for showing Field values in Page Header even when the report spans more than one page(but you don't know at what point the report spans to the next page). It's a combination of several solutions:

1) Create hidden textbox(es) with the field value you're wanting on every line where the page might span to the next page.

textbox1

textbox2

textbox3

2) Create a function in code that will reference each hidden textbox(es) by name

Shared Function Header(reportItems as ReportItems) as string
Dim final as string
If ReportItems!textbox1.value <> "" Then
final = ReportItems!textbox1.value
Else If ReportItems!textbox2.value <> "" Then
final = ReportItems!textbox2.value
Else If ReportItems!textbox3.value <> "" Then
final = ReportItems!textbox3.value
End If
Return final
End Function

3) In Page Header call function, pass (ReportItems)

=Code.Header(ReportItems)

The reason for the function is because you can't reference multiple ReportItems in Page Header textbox, so you have to determine which hidden textbox has a value on that page and return that value to the calling Header textbox. Hope this helps....

sql

Report Help..!

Hi All,

I have a set of "VB reports" binded to a wizard, where you can select fields which will appear on the report. Also you can change Group By and Order By Fields.

Initiallly this was designed and used for "A4" size papers. But now I need dynamically adjust the report for selected paper size. Anyone can guide me on this...?

I am hoping to use papers larger than "A4" only....

- Help meHow about designing seperate files for different sizes and display them accordingly?|||Dim Report As New dsrVoucher

Report.SetUserPaperSize 1400, 2200
Report.PaperSize = crPaperUser

then so on...

but.. size u 'll given is in pixel..
not in inches..cms..
well.. as i also suggest.. the better way to do so is to design different report..with different page setup...
crystal report have some very unfortunate and teasing issues.. while printing .. bcoz of printer based reporting system..

but very some time teasing....and always comfortable at any type of reporting...
neways
best of luck

report header and footer missing.

hiye, i'm doing a drill down report (group type) everytime the reoprt loads
the headr and footer is missing untill i click on the plus (+) sign and then
only the headr and footer will be display. any idea?
thanks in advance.Toggle by property of the controls is set in a way that
you can see either the report main area or the header.
Just right click on the control and under properties just
reset the toggle property.
>--Original Message--
>hiye, i'm doing a drill down report (group type)
everytime the reoprt loads
>the headr and footer is missing untill i click on the
plus (+) sign and then
>only the headr and footer will be display. any idea?
>thanks in advance.
>.
>

Report header and footer disappear when exporting

When I export my report to a PDF, everything is fine. However, if I select a group to drill down and then export that drilled down report to a pdf, the reports header and footer disappear. How can I fix this? My report has a few subreports, so that might have something to do with it.
ThanksSee if you find solution here
http://support.businessobjects.com/

Report Header / Group Header repeating on every pages

I'm new on SQL Server Reporting Services.
Now, I have a problem on create a report header / group header which can
repeating on every pages.
However, I can't use the page header because I would like to show data which
retrieved from my passed dataset. Also, I tried to use "Repeat report item
with data region on every page". However, it seems doesn't work.
Using Crystal Report, there are Report Header and Group Header. Thus, I can
set what I want. But, would you suggest how can I do this? Thanks!
MandaHi,
I have been using SQL Server Reporting Services for last 2 motnhs. From
my, knowledge,if you are using a table, then you can give the date in
the table header and make the table header to repeat in all pages by
property settings.
If you want to display data in page header, store the data in a text
box(say, textbox1) in the report, then create another textbox
(textbox2) in the page header. Set the value of textbox2 as
Reportitems!textbox1.value. I believe this should do the trick and you
will get the data in every page.
Manda Ho wrote:
> I'm new on SQL Server Reporting Services.
> Now, I have a problem on create a report header / group header which can
> repeating on every pages.
> However, I can't use the page header because I would like to show data which
> retrieved from my passed dataset. Also, I tried to use "Repeat report item
> with data region on every page". However, it seems doesn't work.
> Using Crystal Report, there are Report Header and Group Header. Thus, I can
> set what I want. But, would you suggest how can I do this? Thanks!
> Manda|||Thanks for your suggestion.
I found there is limitation if using table header, it only allow to use data
from single dataset. And the location of content can't be set flexible even
cells can be merged.
When I tried to use "Reportitems!textbox1.value", "Unrecognized identifier"
is prompted. Do I have something wrong?
"vyshak" <vyshaknr@.gmail.com> wrote in message
news:1139985067.476396.87780@.g14g2000cwa.googlegroups.com...
> Hi,
> I have been using SQL Server Reporting Services for last 2 motnhs. From
> my, knowledge,if you are using a table, then you can give the date in
> the table header and make the table header to repeat in all pages by
> property settings.
> If you want to display data in page header, store the data in a text
> box(say, textbox1) in the report, then create another textbox
> (textbox2) in the page header. Set the value of textbox2 as
> Reportitems!textbox1.value. I believe this should do the trick and you
> will get the data in every page.
> Manda Ho wrote:
> > I'm new on SQL Server Reporting Services.
> >
> > Now, I have a problem on create a report header / group header which can
> > repeating on every pages.
> >
> > However, I can't use the page header because I would like to show data
which
> > retrieved from my passed dataset. Also, I tried to use "Repeat report
item
> > with data region on every page". However, it seems doesn't work.
> >
> > Using Crystal Report, there are Report Header and Group Header. Thus, I
can
> > set what I want. But, would you suggest how can I do this? Thanks!
> >
> > Manda
>|||Yes,
Reporting services only allows one dataset per table, but dont forget,
you can have multiple tables and even/or use that table as a header(by
placing another table aboe the other.)
As to the error that you are getting, did you rename the name for the
text box textbox1?|||Seems it is not possible to show information through another table. If I
show those information under another tables, I couldn't shown it as "Group"
header as they are independent and no linkage can be set for these datasets.
I have created a new textbox (Textbox21) which having value "Testing". And,
I created another new textbox (Textbox27) which make use of the value of
Textbox21 by using
"ReportItem!Textbox21.Value"/"ReportItem!Textbox21.ToString" under its
expression (Because Value is not one of properties for Textbox) . However,
"Unrecognized identifier" found under Expression Dialog. And the following
message found when preview.
----
An error occurred during local report processing.
The definition of the report '/rptLedger' is invalid.
The Value expression for the textbox 'textbox27' contains an error:
[BC30108] 'ReportItem' is a type and cannot be used as an expression.
----
"Sorcerdon" <sorcerdon@.gmail.com> wrote in message
news:1140011658.987628.29720@.g43g2000cwa.googlegroups.com...
> Yes,
> Reporting services only allows one dataset per table, but dont forget,
> you can have multiple tables and even/or use that table as a header(by
> placing another table aboe the other.)
> As to the error that you are getting, did you rename the name for the
> text box textbox1?
>|||the proper term is ReportItems! with an 's' ... I dont know if that gave
you the unrecognized error or if you just put a typo in your posting. I hope
it is that simple as it will work for you then.
"Manda Ho" wrote:
> Seems it is not possible to show information through another table. If I
> show those information under another tables, I couldn't shown it as "Group"
> header as they are independent and no linkage can be set for these datasets.
> I have created a new textbox (Textbox21) which having value "Testing". And,
> I created another new textbox (Textbox27) which make use of the value of
> Textbox21 by using
> "ReportItem!Textbox21.Value"/"ReportItem!Textbox21.ToString" under its
> expression (Because Value is not one of properties for Textbox) . However,
> "Unrecognized identifier" found under Expression Dialog. And the following
> message found when preview.
> ----
> An error occurred during local report processing.
> The definition of the report '/rptLedger' is invalid.
> The Value expression for the textbox 'textbox27' contains an error:
> [BC30108] 'ReportItem' is a type and cannot be used as an expression.
> ----
> "Sorcerdon" <sorcerdon@.gmail.com> wrote in message
> news:1140011658.987628.29720@.g43g2000cwa.googlegroups.com...
> > Yes,
> > Reporting services only allows one dataset per table, but dont forget,
> > you can have multiple tables and even/or use that table as a header(by
> > placing another table aboe the other.)
> >
> > As to the error that you are getting, did you rename the name for the
> > text box textbox1?
> >
>
>

report grouping

I have a report that shows/hides group detail with the + for expanding the
group. When the report first displays the detail is hidden (as it should be)
with the + showing. However ... the cursor will only change to a finger
(pointer ... whatever) when the cursor is placed to the left of the + sign.
The user will want to expand the detail by selecting on the + sign and they
cant. Why is this?
Example:
+ Client A
^ -- user must click to the left of the plus sign on Client A to expand
groupThis is a known bug in the report designer preview tab.
When the report is published to the report server, all should be fine and
good in the world.
Rob.
"MJ Taft" <MJTaft@.discussions.microsoft.com> wrote in message
news:28AF3C35-5277-407E-8646-C42F1D1D441E@.microsoft.com...
>I have a report that shows/hides group detail with the + for expanding the
> group. When the report first displays the detail is hidden (as it should
> be)
> with the + showing. However ... the cursor will only change to a finger
> (pointer ... whatever) when the cursor is placed to the left of the +
> sign.
> The user will want to expand the detail by selecting on the + sign and
> they
> cant. Why is this?
> Example:
> + Client A
> ^ -- user must click to the left of the plus sign on Client A to expand
> group
>|||Thanks Rob, another question has come up ... my use does not like how the
report has to be so wide when you are drilling down. Is there a way to nest
the drill levels so they appear to render slightly indented rather than
spreading across the page? If it involves expressions please elaborate as I
am struggling with that aspect a bit. Thanks in advance!
"Rob Labbe (Lowney)" wrote:
> This is a known bug in the report designer preview tab.
> When the report is published to the report server, all should be fine and
> good in the world.
> Rob.
> "MJ Taft" <MJTaft@.discussions.microsoft.com> wrote in message
> news:28AF3C35-5277-407E-8646-C42F1D1D441E@.microsoft.com...
> >I have a report that shows/hides group detail with the + for expanding the
> > group. When the report first displays the detail is hidden (as it should
> > be)
> > with the + showing. However ... the cursor will only change to a finger
> > (pointer ... whatever) when the cursor is placed to the left of the +
> > sign.
> > The user will want to expand the detail by selecting on the + sign and
> > they
> > cant. Why is this?
> > Example:
> >
> > + Client A
> > ^ -- user must click to the left of the plus sign on Client A to expand
> > group
> >
> >
>
>

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

Report generation time between users and admin

Hi,

When we generate a report with an account that is in the admin group it takes 2-3 seconds but when we do it with another user it takes over 2 minutes... any reason for this?

(The "Report is being generated" thing, by the way)

Not sure if my question is clear, I've been looking and searching for the past 2 hours but can't find anything remotly close to that problem... any help would be appreaciated!

Thanks

Wacky guess:

Are temp files for the two accounts going to different places, for example there is a "home" drive for normal users that is not local?

>L<

Report Format with a Group

Is there a way to have the data rows begin on the same row as the group fields. For example if I have a student with multiple tests/scores, I want the tests/score to begin on the same line as the students name.

You could place everything on a detail row...basically no grouping level. This will display the student name as a repeating element, however.

You can then add some conditional logic to the Hidden property to only display the first occurrence of that student name.

|||Do you have an example of the logic to hide all but the first occurance? The programming side of this is a little new to me.|||

Check out the HideDuplicates feature of TextBox: http://msdn2.microsoft.com/en-us/library/ms152916.aspx.

In ReportDesigner, right click on your textbox and check "Hide duplicates" in the Textbox Properties dialog.

Report Format with a Group

Is there a way to have the data rows begin on the same row as the group fields. For example if I have a student with multiple tests/scores, I want the tests/score to begin on the same line as the students name.

You could place everything on a detail row...basically no grouping level. This will display the student name as a repeating element, however.

You can then add some conditional logic to the Hidden property to only display the first occurrence of that student name.

|||Do you have an example of the logic to hide all but the first occurance? The programming side of this is a little new to me.|||

Check out the HideDuplicates feature of TextBox: http://msdn2.microsoft.com/en-us/library/ms152916.aspx.

In ReportDesigner, right click on your textbox and check "Hide duplicates" in the Textbox Properties dialog.