Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsReportsReportsSQL Reporting ServicesSQL Reporting Services
Previous
 
Next
New Post
11/24/2008 4:36 AM
 

 In current version (5.0) of DNN Reports Module, does it support to preview reports from SQL Reporting services Server? I seen in projects description this version already supported integration with SQL Reporting Services but when i want to use it, i cannot find any module's feature items to set it up.

How to do it? I'm using DNN 4.8.4

 
New Post
11/24/2008 10:45 PM
 

The SQL Reporting Services features aren't installed by default because you have to install the SQL Server Reporting Services redistributable on your web server.

There are instructions for installing the Report Viewer Visualizer (which supports SQL Server Reporting Services) in the DotNetNuke Online Help manual: http://www.dotnetnuke.com/Resources/Knowledge/DotNetNukeOnlineHelp/tabid/787/TID/3041/cid/417/Default.aspx

Just a few notes about that documentation:

You MUST be able to install software on your web server to use this Visualizer.  Sorry, but Shared Hosting sites aren't supported since (as far as I know) the only legitimate way to get the Microsoft ReportViewer components on the server is through the installer

Also, you MUST be running in a Full Trust environment.  The documentation mentions this, but there is a minor typo.  Where you see this:

Ensure that the " " element in your web.config file is set to "Full".

it should read

Ensure that the ' <trust level="Medium">' element in your web.config file is set to "Full".


Andrew Nurse
DotNetNuke Core Team Member and Reports Module Project Lead
Microsoft Certified Professional Developer

 
New Post
11/25/2008 9:37 PM
 

Hi Andrew,

I read in FAQ that we need to locate Microsoft.ReportViewer.Common.dll and Microsoft.ReportViewer.Webforms.dll in DNN bin directory. But after i installed

Ms report server redistribute 2005 i couldnot find both files. Any suggestion on this issue? Other threads shown the same problem but there were no solutions.

In my local server, its installed MS SQL Server 2000 and Reporting Server. Is this could be the problem?

 
New Post
11/27/2008 12:03 AM
 

A few google searches turned up these MSDN threads:

http://social.msdn.microsoft.com/forums/en-US/vsreportcontrols/thread/cdf81c32-ac7c-491f-add7-d1c0c6c746eb/

http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/377dff1b-e949-43fd-b551-972fd0e526c6/

Those indicate that the assembly is installed in the GAC.  You can get files out of the GAC using the command prompt:

cd %windir%\assembly
cd GAC_MSIL
cd [assembly name]
dir (there will be folders for each version)
cd [version # you want]
dir (the assemblies will be here)
copy [assembly] C:\

Then you can move it from C:\ using explorer.  If you can't find the assembly in the GAC_MSIL folder, try the other folders within the 'assembly' folder

Hope that works!


Andrew Nurse
DotNetNuke Core Team Member and Reports Module Project Lead
Microsoft Certified Professional Developer

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsReportsReportsSQL Reporting ServicesSQL Reporting Services


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out