DotNetNuke 3.3.x + SQL Reporting Services

[jyjohnson]

Hi folks - I plan to create a DNN module that displays RS reports (passing parameters to RS and returning to the module the rendered report).

I plan to use this article as a base: http://www.codeproject.com/aspnet/SQLRSViewer.asp(modifying per the comments as needed)...

My requirements are:
- never show the RS login/credentials to the DNN user
- control the reports each DNN user may access (multiple DNN RS modules per site, etc.)
- pass parameters (hidden and visible) to the RS server
- allow the DNN user to choose the output format

If anyone has been through this before and has some suggestions please post your comments, etc!!

Many thanks!

[bruce]

Are you using ASP.NET 2.0?

You can display SQL Report file (RDL) without Reporting service in .NET 2.0. VS.NET 2005 comes with a new control, Report Viewer Control that will display reports.

See http://www.gotreportviewer.com/

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

[jyjohnson]

Nope. I'm using DNN 3.3.x which is compiled using 1.1. They say it will run under 2.0 but I don't really want to test/try it.


At some point I'll move to DNN 4.x + 2.0 Framework.


I wish DASP supported the ability to configure the framework version for each Web Application folder, instead of the current global setting. http://community.discountasp.net/emoticons/sad.gif

[bruce]

>I wish DASP supported the ability to configure the framework version for each Web Application folder, instead of the current global setting.

Not really our problem but MS's. You cannot run multiple version of .NET framework under 1 application pool and it is not possible for us to provide customer with multiple appPool.

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)