May 10, 2012 at 4:15 pm
This is a known bug that to my knowledge has not been fixed. I have a table inside of a matrix, and when exporting to excel, the data within the tables are ignored.
I feel like what I'm trying to accomplish is NOT that difficult, but I'm having a hard time working around this without doing what I would consider silly. So I'm looking for some ideas, or someone to point out why I'm being a bit of a bone head 😉
Essentially I'm trying to create a 12 Month Rolling report for a set of metrics, with months across the top, metric labels down the left hand side, and the data inside the matrix. I chose a matrix because the columns need to be dynamic based on whatever month I'm runnin this for. There is no other grouping necessary other than by month.
So what I did was put a table inside the row group and hardcoded the metric lables that I wanted into a set of rows in that table. I then put another table inside the data region, and put my metric values (sum(x)..). It works perfectly, however I'm running into this bug where I can't render it in Excel.
3 month rolling sample made up below of what I'm trying to do..
[font="Courier New"]
__________|Jan 2012|Feb 2012|Mar 2012|
$Sales....|300.....|400.....|500.....|
Unit Sold.|30......|13......|23......|
Turnover..|12%.....|14%.....|20%.....|
[/font]
I realize that what I could do is accomplish this with a table and large set of subqueries to paramaterize what each column would be, but I consider this silly. Suggestions welcome! I'll even take someone sarcastically pointing out why what I did wasn't very smart! (including my ascii table, that was a pain to line up :-P)
May 16, 2012 at 3:34 pm
FYI, I've found that this bug has been fixed at least with BIDS 2012.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply