Groups | Blog | Home
all groups > sql server reporting services > october 2004 >

sql server reporting services : Packaging reports as a product?


Henry Zektser
10/4/2004 6:25:01 PM
I've written an application that generates a couple of stored procs and
views, and installs them into a DB. I also have a series of reports in
Reporting Services that pull data from those views.

Its easy enough for me to distribute the .exe for the app that generates SPs
and views, but how do I distribute the reports without giving the installer
access to them? Basically, I dont want anyone to poke around through the
formulas, etc.

Teo Lachev [MVP]
10/4/2004 10:15:16 PM
Henry,

Even if you secure the installation process the administrator can always see
the report definition in the Report Manager. So, I would rather gravitate
toward moving the sensitive information in an external .NET assembly and
possibly obfuscating it.

--
Hope this helps.

-----------------------------------------------------
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
-----------------------------------------------------

[quoted text, click to view]

Henry Zektser
10/5/2004 9:15:07 AM
Youre suggesting an assembly that spits out a dataset, and reporting on that?

Are there any examples of this around?

[quoted text, click to view]
Teo Lachev [MVP]
10/5/2004 9:32:37 PM
Well, depends on what you want to protect. You mentioned that you want to
protect the formulas so I imagined that you have some sensitive information
embedded in your formulas that you don't want to reveal.

What exactly do you want to protect?

--
Hope this helps.

-----------------------------------------------------
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
-----------------------------------------------------

[quoted text, click to view]

AddThis Social Bookmark Button