Defining custom column groups on a matrix report in report builder

I have table called Buildings which has market and sq. ft information.
I want to create a matrix report that has the market as the row group and
sq. ft ranges as the column group and shows the # of buildings in each
market that fall in the sq. ft ranges.
Sq. ft ranges are 0-5000, 5001-10000 etc...
My questions is a) is this something that can be done using report builder
b) how do i define the sq. ft ranges
c) how do I find the count of buildings whose sq. footage falls within the
range.
ThanksOn Nov 14, 1:18 pm, "shikarishambu" <shikarishamb...@.hotmail.com>
wrote:
> I have table called Buildings which has market and sq. ft information.
> I want to create a matrix report that has the market as the row group and
> sq. ft ranges as the column group and shows the # of buildings in each
> market that fall in the sq. ft ranges.
> Sq. ft ranges are 0-5000, 5001-10000 etc...
> My questions is a) is this something that can be done using report builder
> b) how do i define the sq. ft ranges
> c) how do I find the count of buildings whose sq. footage falls within the
> range.
> Thanks
A) Yes
B) In your Datasets window, right-click on the name of the dataset and
Add a new field. Call it "Sq Foot Range" and make it a calculated
field. Use an expression like
= Fields!SqFoot.Value - Fields!SqFoot.Value Mod 5000
Since you are shifting your range to include the evenly divided number
in the lower group, you really want
= CStr( ( (X-1) - (X-1) Mod 5000 ) + 1 ) & " to " & CStr( ( (X-1) -
(X-1) Mod 5000 ) + 5000 )
C) Create a Matrix with a Market in the Row Group, Sq Foot Range in
the Column Group, and Count( Fields!SqFoot.Value ) in the Details.
Hope that helps.
-- Scott

defining background color in matrix

Hi All
In my report there is a dynamic matrix.
two section inside the data region need to be paint in two different
color.
i defined an Expression in the background properties.
the Expression define two ranges(four cordinates) in order to paint one
section
and more two ranges for the other section.
the problem occour while examine the data come from the DB. in those
junction
that there was no data involve the cell was'nt paint although it is in
the
range
of the painting.
i try to solve this by using the " is nothing" function but without any
successes.
one solution i had which is works was declaring temporary table int he
procedure ,addind rows to the temporary table plus the data it self
while
running
and then in the report to blank those cells by filter them.it work's
paint
those cells but damage the subtotal line(because new rows were adding
to the
table source).
if any knows how to solve this conflic i will very much appreciate
this.
thanks in advanced
Amir KrugliakHi
If this is reporting services then you may be better off posting to the
microsoft.public.sqlserver.reportingsvcs newsgroup.
John
"amir.krugliak@.gmail.com" wrote:

> Hi All
> In my report there is a dynamic matrix.
> two section inside the data region need to be paint in two different
> color.
> i defined an Expression in the background properties.
> the Expression define two ranges(four cordinates) in order to paint one
> section
> and more two ranges for the other section.
> the problem occour while examine the data come from the DB. in those
> junction
> that there was no data involve the cell was'nt paint although it is in
> the
> range
> of the painting.
> i try to solve this by using the " is nothing" function but without any
> successes.
> one solution i had which is works was declaring temporary table int he
> procedure ,addind rows to the temporary table plus the data it self
> while
> running
> and then in the report to blank those cells by filter them.it work's
> paint
> those cells but damage the subtotal line(because new rows were adding
> to the
> table source).
> if any knows how to solve this conflic i will very much appreciate
> this.
> thanks in advanced
> Amir Krugliak
>