October 18, 2004 at 5:59 pm
I'm doing a POC for my company, we currently have Brio and are looking into Reporting Services and a cheaper/easier solution.
However, after doing some intensive research, I've hit a snag.
In Brio, we can create what we call Pivot Reports, when the end user can select certain fields and have them display differently by drag and drop.
I'm unable to find anything in Reporting Service that offer's this type of function. They make a reference to a Pivot when talking about the Matrix report, but I was unable to make it behave like a real pivot.
Does any one else use a pivot in the Reporting Services tool?
Thanks in advance
Susan
October 20, 2004 at 5:25 am
Sounds like you should be using an analysis services cube for this, instead of reporting services. You have a choice of client interfaces over the cube - you can use a web interface, with an office web component add-in, or even an excel pivot table over it.
Chris
October 21, 2004 at 9:05 am
Hi,
ProClarity (http://www.proclarity.com) as a front-end tool that gives you both the capability of doing analysis, but also to integrate with Reporting Services.
Definitely worth to have a look at it.
Nick
October 25, 2004 at 11:15 am
You should definitly be using Analysis Services. Then you can have a multitude of choices. I use the free thin web client see it at http://www.utcodes.org/queryabledata/cube/analyzer/default.asp - it requires a pop-up so if blocked, enable for this site.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply