Hiding

Hi,
I don't know if this is possible.
I have a matrix with one row group and one column group. Within the column group are three static columns.The rowgroup has subtotals enabled. What I want is that one of the three static columns is hidden in the report but shown in the subtotal. Can this be done?
Thanks,
QIf you're just trying to hide it (leaving a blank space/without rearranging
the layout), you can do that easily using the InScope property.
Set the Hidden property of the textbox to: =InScope("myrowgroupname")
(Typically, the row group name would be something like matrix1_fieldname
unless you renamed it)
--
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.
"Qbee" <Qbee@.discussions.microsoft.com> wrote in message
news:450CA2CE-0554-4D11-A295-72877EEC95AE@.microsoft.com...
> Hi,
> I don't know if this is possible.
> I have a matrix with one row group and one column group. Within the column
group are three static columns.The rowgroup has subtotals enabled. What I
want is that one of the three static columns is hidden in the report but
shown in the subtotal. Can this be done?
> Thanks,
> Q|||Hi Chris,
your solution works great but the textbox which is hidden leaves a blank
column in the report which doesn't look nice.
I am currently converting a lot of Business Objects reports and I notice
that there are table structures which are difficult to convert in reporting
services.
Q
"Chris Hays [MSFT]" wrote:
> If you're just trying to hide it (leaving a blank space/without rearranging
> the layout), you can do that easily using the InScope property.
> Set the Hidden property of the textbox to: =InScope("myrowgroupname")
> (Typically, the row group name would be something like matrix1_fieldname
> unless you renamed it)
> --
> 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.
> "Qbee" <Qbee@.discussions.microsoft.com> wrote in message
> news:450CA2CE-0554-4D11-A295-72877EEC95AE@.microsoft.com...
> > Hi,
> >
> > I don't know if this is possible.
> >
> > I have a matrix with one row group and one column group. Within the column
> group are three static columns.The rowgroup has subtotals enabled. What I
> want is that one of the three static columns is hidden in the report but
> shown in the subtotal. Can this be done?
> >
> > Thanks,
> >
> > Q
>
>|||Generally, tables and matrixes are straightforward. It's when you're trying
to hybridize the two (like you're doing) that we run into trouble.
It's a common enough thing to do that it's high on our future features
wishlist (but pretty expensive to do it right, so probably won't make it in
to SQL 2005).
In the mean time, you can simulate some of it (but not all of it, I'm
afraid) via controlling visibility. In your case, you might be able to do
something wherein you have several overlapping textboxes in a rectangle,
some of which are hidden while in the subtotal and the others of which are
hidden when in the details. Tricky, but possible. I think brucejoh posted
an example of this on the newsgroup a while back... You might want to search
for that.
--
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.
"Qbee" <Qbee@.discussions.microsoft.com> wrote in message
news:B97F4CDF-F084-4C91-8429-D893DC6158EE@.microsoft.com...
> Hi Chris,
> your solution works great but the textbox which is hidden leaves a blank
> column in the report which doesn't look nice.
> I am currently converting a lot of Business Objects reports and I notice
> that there are table structures which are difficult to convert in
reporting
> services.
> Q
> "Chris Hays [MSFT]" wrote:
> > If you're just trying to hide it (leaving a blank space/without
rearranging
> > the layout), you can do that easily using the InScope property.
> >
> > Set the Hidden property of the textbox to: =InScope("myrowgroupname")
> >
> > (Typically, the row group name would be something like matrix1_fieldname
> > unless you renamed it)
> >
> > --
> > 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.
> > "Qbee" <Qbee@.discussions.microsoft.com> wrote in message
> > news:450CA2CE-0554-4D11-A295-72877EEC95AE@.microsoft.com...
> > > Hi,
> > >
> > > I don't know if this is possible.
> > >
> > > I have a matrix with one row group and one column group. Within the
column
> > group are three static columns.The rowgroup has subtotals enabled. What
I
> > want is that one of the three static columns is hidden in the report but
> > shown in the subtotal. Can this be done?
> > >
> > > Thanks,
> > >
> > > Q
> >
> >
> >