Showing posts with label intelligent. Show all posts
Showing posts with label intelligent. Show all posts

Friday, March 9, 2012

Intelligent Report Viewer Question

Good Morning,

I have a dumb question. I'm used to working in the VS.NET 2003 environment (C#), and I'm getting into some reporting services stuff for a new client.

Ideally, they'd like to be able to do some code specific stuff with their reports, like only allowing parameters to be changed by certain Active Directory groups, etc...

Ultimately, I'd like to combine C# logic with report viewing capability.

Here's my question: Can I use C# and vanilla web forms with the ReportViewer control to display reports on them?

Thanks in advance for your replies!

Justin

Yes you can. To do what mention you'd want control the parameter rendering manually rather than having RS render the parameter toolbar.

You want to look into displaying the report using URL access to the report server vs rendering the report using the web service API. The API gives you all the information you need about the report to perform your own logic.

Intelligent "bubble up exceptions"

Hi,

I basically understood how to build bubble up exceptions... You i.e. can mark (by changing the background color to red) a region if in one the cities below the sales are dramatically below the targets... That's quite simple MDX...

A customer now asks for "make this pro-active/intelligent" meaning "change the background color to red if something on any level below this value is worth a look"...

This is something the Data Mining Add-Ins for Excel can do... You have a table in Excel and the Add-Ins allow you to find "special values" and mark them...

Did someone already build this into a standard cube? What steps do you have to perform?

THANKS,

I have only seen this with the ProClarity KPI Builder, part of ProClarity Professional. There is a template for "Bubble up exceptions" and I have tried it in a project. It works well.

Regards

Thomas Ivarsson