dynamic columns: in search of the Tatrix data region

This subject has been much discussed but I haven't found a solution
that really works in my situation.
What we need here is a hybrid table/matrix data region with static
columns on the left and (at least) one dynamic column on the right.
Thus do I reveal my cultural bias and no doubt my ignorance of
Reporting Services as well. Maybe this can be done, but I haven't
figured it out.
Wishlist for this "Tatrix" data region:
1) No corner cell
2) A header row that runs straight across the top like a table
3) Header row repeats on each new page
4) Ability to define n static columns at left or right of region
5) Ability to define at least one dynamic column at right or left of
data region, respectively.
In my case I have an inventory with the usual ItemID, ItemName,
ItemCategory fields in the Dataset. These and other fields are
enterprise-level, common across all business units. An ItemRetailPrice
field is potentially unique to each business unit. Therefore I'd like
to have a Tatrix that would display the enterprise-level fields as
static columns and the business-unit-level field(s) as dynamic columns.
Ideally you could have repeating groups of dynamic columns
growing/shrinking out to the side.
The only kludge so far that looks something like what the customer
wants is a Matrix with an Image in the corner cell, simulating the
headers for the static columns. It's hard to get the Image right since
the dimensions of the corner cell change from format to format. The
corner cell graphic seems to shrink on export to Excel. There's no way
to dynamically change the embedded Image to display the product group
you're looking at in a given report.
Apologies if this has been done and described and I didn't find it,
Highly ObscureHi,
I'm sorry that I could not find a way to do this with Matrix in Reporting
Services. You are welcome to send suggestions for product enhancements that
you would like to see in future versions of Microsoft products to us by
submitting MS Wish to mswish@.microsoft.com. By submitting your concerns,
you can get your voice into the design plans for upcoming versions.
Microsoft takes customer requests and suggestions very seriously. MSWISH is
your voice to the development team. A significant number of the design
change requests come from our customers through the MSWISH alias and the
MSWISH web site. http://www.microsoft.com/mswish. I encourage you to submit
this request.
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>NNTP-Posting-Date: Thu, 10 Mar 2005 08:20:34 -0600
>From: "HighlyObscure" <HighlyObscure@.nospam.nospam>
>Subject: dynamic columns: in search of the Tatrix data region
>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>User-Agent: XanaNews/1.17.1.2
>MIME-Version: 1.0
>Content-Type: text/plain; charset=iso-8859-1
>Message-ID: <-oGdnd2P_48vyq3fRVn-hw@.giganews.com>
>Date: Thu, 10 Mar 2005 08:20:34 -0600
>Lines: 42
>X-Trace:
sv3-AdcAxaYs02709d1QLmyISb8L5LZ1SscpiD0Uxn9maeA2kWFvFAuwfshGnq4q+8NXAFKwvaVH
CDw2zH1!3UOd+sBB1baL2C/VrYQhkqjo1KZExYUfZWDixZF1cqFUrf7vda8YFYzxJeLF9A==>X-Complaints-To: abuse@.giganews.com
>X-DMCA-Notifications: http://www.giganews.com/info/dmca.html
>X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
>X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your
complaint properly
>X-Postfilter: 1.3.32
>Path:
TK2MSFTNGXA02.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTFEED02.phx.gbl!TK2MSFTNGP0
8.phx.gbl!newsfeed00.sul.t-online.de!t-online.de!border2.nntp.dca.giganews.c
om!border1.nntp.dca.giganews.com!nntp.giganews.com!local01.nntp.dca.giganews