"Hide Duplicates" within Details Grouping

I'm having problems using the "Hide Duplicates" function within the Details
Grouping of a table in a report (using RS SP2, SQL Server 2000, Visual Studio
2003).
The details grouping has two rows, set out as follows:
| CallFlow Name |
| | Outcome Type | Grammar Type | Meaning | Totals
There are about 10 different "CallFlows", each of which is displayed as
above. There are several possible "Outcome Types"(Success, Fail, Hangup etc),
and I want to prevent duplicates within the scope of the Callflow as shown
below:
| CallFlow Name 1 |
| | Success ...
| | Success ...
| | Success ...
The problem is, when setting "Hide Duplicates" for "Outcome Type", it hides
*ALL* of the duplicated information even in the next Callflow. Is there a
conditional expression or formatting that can be applied to this field so
that duplicates are only hidden for that particular table?
ThanksAll the fields should be in one row of the report layout table.
| CallFlow Name | Outcome Type | Grammar Type | Meaning | Totals
In the table's properties, add a group for the CallFlow field.
In the CallFlow cell's properties, click on the Hide Duplicates dropdown
and select the new group created.
GeoSynch
"Laura-Anne" <Laura-Anne@.discussions.microsoft.com> wrote in message
news:B64F7CCE-F9EB-46C1-9C95-87012913AD82@.microsoft.com...
> I'm having problems using the "Hide Duplicates" function within the Details
> Grouping of a table in a report (using RS SP2, SQL Server 2000, Visual Studio
> 2003).
> The details grouping has two rows, set out as follows:
> | CallFlow Name |
> | | Outcome Type | Grammar Type | Meaning | Totals
> There are about 10 different "CallFlows", each of which is displayed as
> above. There are several possible "Outcome Types"(Success, Fail, Hangup etc),
> and I want to prevent duplicates within the scope of the Callflow as shown
> below:
> | CallFlow Name 1 |
> | | Success ...
> | | Success ...
> | | Success ...
> The problem is, when setting "Hide Duplicates" for "Outcome Type", it hides
> *ALL* of the duplicated information even in the next Callflow. Is there a
> conditional expression or formatting that can be applied to this field so
> that duplicates are only hidden for that particular table?
> Thanks
>|||That worked perfectly - thank you very much!
"GeoSynch" wrote:
> All the fields should be in one row of the report layout table.
> | CallFlow Name | Outcome Type | Grammar Type | Meaning | Totals
> In the table's properties, add a group for the CallFlow field.
> In the CallFlow cell's properties, click on the Hide Duplicates dropdown
> and select the new group created.
>
> GeoSynch
>
> "Laura-Anne" <Laura-Anne@.discussions.microsoft.com> wrote in message
> news:B64F7CCE-F9EB-46C1-9C95-87012913AD82@.microsoft.com...
> > I'm having problems using the "Hide Duplicates" function within the Details
> > Grouping of a table in a report (using RS SP2, SQL Server 2000, Visual Studio
> > 2003).
> >
> > The details grouping has two rows, set out as follows:
> >
> > | CallFlow Name |
> > | | Outcome Type | Grammar Type | Meaning | Totals
> >
> > There are about 10 different "CallFlows", each of which is displayed as
> > above. There are several possible "Outcome Types"(Success, Fail, Hangup etc),
> > and I want to prevent duplicates within the scope of the Callflow as shown
> > below:
> >
> > | CallFlow Name 1 |
> > | | Success ...
> > | | Success ...
> > | | Success ...
> >
> > The problem is, when setting "Hide Duplicates" for "Outcome Type", it hides
> > *ALL* of the duplicated information even in the next Callflow. Is there a
> > conditional expression or formatting that can be applied to this field so
> > that duplicates are only hidden for that particular table?
> >
> > Thanks
> >
>
>

"can grow" option in subreports

Hi

I m using a sub report in one of my reports. In the subreport, I have selected the "Can grow" option.

I have the subreport in the details section of the report. But if the length of the subreport is long then it overlaps on the group footer section.

How can I avoid this ?

Thanking in advanceDid you set "Keep sections together" option?

"Balance Carried Forward" / "Balance Brought Forward"

I have a statement report. There is a table which contains the statement
line details. The printout of this may last several pages. Assume it lasts n
pages.
The bottom of page1 should show the total debits and total credits for page
1 only.
The bottom of page 2 should show the total debits and credits for page 1 and
2 only e.t.c.
I found I cant add Globals!PageNumber as a group to the table.
Neither am I allowed to put the data field in the page footer.
I thought RunningValue function might do it, but this always prints the
grand total for all pages.
Help !
Thanks
Chris BrooksbankPagination and aggregation (I suspect) are in unrelated parts of the RS
code..(I think all of the aggregation stuff is done prior to pagination).
There are no page totals kinds of functions that I am aware of..
Probably the best you can do is to create small groupings, so that a group
will never be larger than a page and total at the group level...
Unless one of the dev guys has a suggestion.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Chris Brooksbank" <NoSpam@.Ta.com> wrote in message
news:OR2sIiBZEHA.2408@.tk2msftngp13.phx.gbl...
> I have a statement report. There is a table which contains the statement
> line details. The printout of this may last several pages. Assume it lasts
n
> pages.
> The bottom of page1 should show the total debits and total credits for
page
> 1 only.
> The bottom of page 2 should show the total debits and credits for page 1
and
> 2 only e.t.c.
> I found I cant add Globals!PageNumber as a group to the table.
> Neither am I allowed to put the data field in the page footer.
> I thought RunningValue function might do it, but this always prints the
> grand total for all pages.
> Help !
> Thanks
> Chris Brooksbank
>