Matrix SubTotal

Hi,
Brief Explanation:
I need 2 fields (say, A and B) in the Matrix Data Region with their SubTotals shown (sum(A), sum(B)). Now, in the matrix Data Region, values for only A should be displayed but both for subtotals both (sum(A), sum(B)) should be displayed.
Detail Explanation, If required:
I am working with a matrix and require 2 fields to be shown in the Data Region against 1 row and 1 column groups. To display 2 fields in the Data Region, i kept a rectangle in the Data Region and placed 2 textboxes inside it with each displaying it's own respective field values.
Now when i add a subtotal to the report, it displays 2 rows for subtotals for each of the Data fields. So far so good.
My requirement is to suppress One of the Data Fields in the Data Region section and LET only it's the Subtotal get displayed. To achieve this, when i keep one of the textboxes hidden, the subtotal also gets hidden.
How can i achieve this ? Even a workwround suggested would be appreciated.
Crystal does this by allowing to access subtotals fields seperately than the data section fields which RS does not.
ThanksYou could conditionally hide the textbox based on the InScope function (e.g.
<Hidden>=InScope("RowGroup") and InScope("ColumnGroup")</Hidden>)
However, that won't collapse out the space occupied by the hidden textbox.
The size of the subtotal cell (in the current version) must be the same as
the size of a detail cell. If you're willing to let your subtotals be a
little cramped, you could do a variation of this with three textboxes. Two
small textboxes (one for A and one for B) which take up half of the
rectangle each and one large textbox (for just A) which takes up the entire
rectangle (overlapping with the other textboxes). You could then hide the
small textboxes when in the detail cell and hide the large textbox when in a
subtotal cell.
--
My employer's lawyers require me to say:
"This posting is provided 'AS IS' with no warranties, and confers no
rights."
"push" <push@.discussions.microsoft.com> wrote in message
news:E185ABCD-EE32-4E81-A735-BCBA236262C8@.microsoft.com...
> Hi,
> Brief Explanation:
> I need 2 fields (say, A and B) in the Matrix Data Region with their
SubTotals shown (sum(A), sum(B)). Now, in the matrix Data Region, values for
only A should be displayed but both for subtotals both (sum(A), sum(B))
should be displayed.
> Detail Explanation, If required:
> I am working with a matrix and require 2 fields to be shown in the Data
Region against 1 row and 1 column groups. To display 2 fields in the Data
Region, i kept a rectangle in the Data Region and placed 2 textboxes inside
it with each displaying it's own respective field values.
> Now when i add a subtotal to the report, it displays 2 rows for subtotals
for each of the Data fields. So far so good.
> My requirement is to suppress One of the Data Fields in the Data Region
section and LET only it's the Subtotal get displayed. To achieve this, when
i keep one of the textboxes hidden, the subtotal also gets hidden.
> How can i achieve this ? Even a workwround suggested would be appreciated.
> Crystal does this by allowing to access subtotals fields seperately than
the data section fields which RS does not.
> Thanks
>|||This worked in the preview. Thanks. Now there is another issue. When i give a border for the Subtotals fields (A, B) (from Right Clink of that green corner), while previewing it says "Object Reference not set to an instance of an Object".
How can i place a border on the subtotals as a whole (i.e. for both A and B) ? Also, if, possible, how can i conditionally place the border for only one of the subtotals (i.e. only for subtotal A)?
Thanks,
"Chris Hays [MSFT]" wrote:
> You could conditionally hide the textbox based on the InScope function (e.g.
> <Hidden>=InScope("RowGroup") and InScope("ColumnGroup")</Hidden>)
> However, that won't collapse out the space occupied by the hidden textbox.
> The size of the subtotal cell (in the current version) must be the same as
> the size of a detail cell. If you're willing to let your subtotals be a
> little cramped, you could do a variation of this with three textboxes. Two
> small textboxes (one for A and one for B) which take up half of the
> rectangle each and one large textbox (for just A) which takes up the entire
> rectangle (overlapping with the other textboxes). You could then hide the
> small textboxes when in the detail cell and hide the large textbox when in a
> subtotal cell.
> --
> My employer's lawyers require me to say:
> "This posting is provided 'AS IS' with no warranties, and confers no
> rights."
> "push" <push@.discussions.microsoft.com> wrote in message
> news:E185ABCD-EE32-4E81-A735-BCBA236262C8@.microsoft.com...
> > Hi,
> >
> > Brief Explanation:
> > I need 2 fields (say, A and B) in the Matrix Data Region with their
> SubTotals shown (sum(A), sum(B)). Now, in the matrix Data Region, values for
> only A should be displayed but both for subtotals both (sum(A), sum(B))
> should be displayed.
> >
> > Detail Explanation, If required:
> >
> > I am working with a matrix and require 2 fields to be shown in the Data
> Region against 1 row and 1 column groups. To display 2 fields in the Data
> Region, i kept a rectangle in the Data Region and placed 2 textboxes inside
> it with each displaying it's own respective field values.
> > Now when i add a subtotal to the report, it displays 2 rows for subtotals
> for each of the Data fields. So far so good.
> > My requirement is to suppress One of the Data Fields in the Data Region
> section and LET only it's the Subtotal get displayed. To achieve this, when
> i keep one of the textboxes hidden, the subtotal also gets hidden.
> > How can i achieve this ? Even a workwround suggested would be appreciated.
> > Crystal does this by allowing to access subtotals fields seperately than
> the data section fields which RS does not.
> >
> > Thanks
> >
>
>|||You're setting the border properties the right way. I don't know why you're
getting that error. (I tried the same thing here and it works, so I'd need
your report and the associated data file to try to reproduce the problem
here). A workaround in the mean time: Just set the borders on one or both
of the small textboxes directly. Since they'll be hidden unless you're in a
subtotal cell, you don't actually need to use the subtotal-specific style
properties (the green-triangle ones).
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"push" <push@.discussions.microsoft.com> wrote in message
news:027F0F5F-1971-4DEF-B118-7615AF3C988B@.microsoft.com...
> This worked in the preview. Thanks. Now there is another issue. When i
give a border for the Subtotals fields (A, B) (from Right Clink of that
green corner), while previewing it says "Object Reference not set to an
instance of an Object".
> How can i place a border on the subtotals as a whole (i.e. for both A and
B) ? Also, if, possible, how can i conditionally place the border for only
one of the subtotals (i.e. only for subtotal A)?
> Thanks,
>
> "Chris Hays [MSFT]" wrote:
> > You could conditionally hide the textbox based on the InScope function
(e.g.
> > <Hidden>=InScope("RowGroup") and InScope("ColumnGroup")</Hidden>)
> > However, that won't collapse out the space occupied by the hidden
textbox.
> > The size of the subtotal cell (in the current version) must be the same
as
> > the size of a detail cell. If you're willing to let your subtotals be a
> > little cramped, you could do a variation of this with three textboxes.
Two
> > small textboxes (one for A and one for B) which take up half of the
> > rectangle each and one large textbox (for just A) which takes up the
entire
> > rectangle (overlapping with the other textboxes). You could then hide
the
> > small textboxes when in the detail cell and hide the large textbox when
in a
> > subtotal cell.
> >
> > --
> > My employer's lawyers require me to say:
> > "This posting is provided 'AS IS' with no warranties, and confers no
> > rights."
> >
> > "push" <push@.discussions.microsoft.com> wrote in message
> > news:E185ABCD-EE32-4E81-A735-BCBA236262C8@.microsoft.com...
> > > Hi,
> > >
> > > Brief Explanation:
> > > I need 2 fields (say, A and B) in the Matrix Data Region with their
> > SubTotals shown (sum(A), sum(B)). Now, in the matrix Data Region, values
for
> > only A should be displayed but both for subtotals both (sum(A), sum(B))
> > should be displayed.
> > >
> > > Detail Explanation, If required:
> > >
> > > I am working with a matrix and require 2 fields to be shown in the
Data
> > Region against 1 row and 1 column groups. To display 2 fields in the
Data
> > Region, i kept a rectangle in the Data Region and placed 2 textboxes
inside
> > it with each displaying it's own respective field values.
> > > Now when i add a subtotal to the report, it displays 2 rows for
subtotals
> > for each of the Data fields. So far so good.
> > > My requirement is to suppress One of the Data Fields in the Data
Region
> > section and LET only it's the Subtotal get displayed. To achieve this,
when
> > i keep one of the textboxes hidden, the subtotal also gets hidden.
> > > How can i achieve this ? Even a workwround suggested would be
appreciated.
> > > Crystal does this by allowing to access subtotals fields seperately
than
> > the data section fields which RS does not.
> > >
> > > Thanks
> > >
> >
> >
> >