Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

PortalWebHosting
  Ads  
Active Modules -- Active Forums for DotNetNuke
 


  Sponsors  

Meet Our Sponsors

SourceGear - Tools for Developers
.: CounterSoft :.
telerik
ExactTarget email software solutions
Merak Mail Server
WebSecureStores -- ASP.NET & DotNetNuke Hosting Solutions
 


DotNetNuke Forums
 
  Forum  DotNetNuke® Pro...  Reports Module ...  Report setup
Previous Previous
 
Next Next
New Post 1/1/2007 5:00 AM
User is offline jens hansen
7 posts
www.gaynord.dk
10th Ranked


Report setup 

Have copied the files from  the "Reporting Services" folder in the DesktopModules/Reports/ExtVisualizers folder in my DotNetNuke installation to the DesktopModules/Reports/Visualizers folder, as stated in install.txt

Added the module to a page
First i get an error:
The Report Viewer Web Control HTTP Handler has not been registered in the application's web.config file.  Add <add verb="*" path="Reserved.ReportViewerWebControl.axd" type = "Microsoft.Reporting.Webforms.HttpHandler, Microsoft.ReportViewer.Webforms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" /> to the system.web/httpHandlers section of the web.config file.

Added under httphandler in web.config: add verb="*" path="Reserved.ReportViewerWebControl.axd" type = "Microsoft.Reporting.Webforms.HttpHandler, Microsoft.ReportViewer.Webforms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />

<

Now no errors.
Changed visualizer in settings to (Experimental) Reporting Service Visualizer
Running a win2003 box with sql 2005 where bort my testwebsite and reporting server is installed at the same machine.
Copyed :
Microsoft.ReportViewer.Common.dll
Microsoft.ReportViewer.Webforms.dll
and Microsoft.ReportViewer.ProcessingObjectModel.dll to the bin dir at my testsite.
Tried several combinations in Server Url and Server Report Path
- all i get is: There is no query configured for this report. Please use the Settings page for this module to configure the query to generate the report from - no matter what i tried
Report Type have been tried with both Local Report and Server Report
With Local Report after to have copied a report.rdl to the root of the testsite, and removed the datasource as it is defined in the report.

What am i doing wrong...

 
New Post 1/1/2007 11:14 AM
User is offline Andrew Nurse
366 posts
8th Ranked






Re: Report setup 
After taking a look at the code, this appears to be a bug with the Reporting Services. I am logging it in the bug tracker and should have it fixed for the next version. As a workaround, you need only put a SQL Query (any Query that returns one or more rows, say: "SELECT * FROM {objectQualifier}Portals") in to the "Query" field and set the "Data Source Name" field to empty ("") so that the query results will be ignored by the Reporting Services visualizer. The problem is that if a Report produces no results or an error after executing the query, the visualizer does not get properly run.

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

 
New Post 1/1/2007 1:27 PM
User is offline jens hansen
7 posts
www.gaynord.dk
10th Ranked


Re: Report setup 

So far so good... - Now i get a:
The permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are insufficient for performing this operation. (rsAccessDenied)
I have given Full Control is ISS (permissions) for Network Service to Reports and ReportServer.

Still get the above

 
New Post 1/2/2007 11:33 AM
User is offline Andrew Nurse
366 posts
8th Ranked






Re: Report setup 
I believe you also have to configure the user on the Report Server itself (not just IIS)... The final release of the visualizer will also provide you with the ability to enter a user name and password to use so this is really just an issue with the Alpha. I'm a bit unfamiliar with Reporting Services so this first release was just what I had learned so far, now I've got a bit more experience with it :)

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

 
New Post 2/27/2007 6:42 AM
User is offline Roberto Lo Baido
3 posts
10th Ranked


Re: Report setup 

I've a problem when the reporting services report i'm calling has an image (external and even embedded). The image does not display. Another problem is that when i export the rendered report in excel or pdf it generate a corrupted document. If i put a reportviewer control in a normal asp.net2 website with the same lines of code, it works fine, it displays images and export feature works good. It seems like the problem is when reportviewer has to work in the DotNetNuke context...i really need to make it work under DNN4. If you have any idea please post a reply. Thanks!

 
Previous Previous
 
Next Next
  Forum  DotNetNuke® Pro...  Reports Module ...  Report setup
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, 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 DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.

 


Convert Visitors to Customers
In order to bring value to your users, we must first understand them. VIVIDSITES will help you build a custom web application and interactive marketing tools that your users will thank you for. We marry high-end creative with head banging technology to entertain and convert visitors into paying customers. Call 314.514.0505 or visit us at http://www.vividsites.com to find out how.
- V I V I D S I T E S -
Gearworx Web Hosting
As a premier provider of Web Hosting, Private/White Label hosting, Server Colocation, Dedicated Server, and other Managed Services, Gearworx offers an array of services designed to more effectively manage strategies driving businesses on the Web. Headquartered in Fremont, California our state of the art tier one data centers and distributed managed services environment enables Gearworx to offer your business enterprise level solutions through simplified processes.
Gearworx Web Hosting
Glanton: Enterprise Intranet Specialists Using DNN
Glanton Solutions are a premier provider of sevices for large corporates lloking to outsource Intranet sites.
www.glanton.com

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP