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

HomeHomeArchived Discus...Archived Discus...Developing Under Previous Versions of .NETDeveloping Under Previous Versions of .NETASP.Net 2.0ASP.Net 2.0Report not showing in ReportViewerReport not showing in ReportViewer
Previous
 
Next
New Post
7/13/2009 12:18 PM
 

Hi!

I am trying to use ReportViewer to view a report from Reporting services.  But for some reason the report isn't showing up.  I am not getting an error or anything so I'm not sure why it isn't.  I know the username and password are correct because I am using it to connect to the same report in a demo module.  Can someone tell me what I am doing wrong? 

Here's my code:

Imports System
Imports DotNetNuke.Entities.Modules
Imports System.Net
Imports Microsoft.Reporting.Webforms

Namespace ReportServicesViewer

Partial Class View
Inherits PortalModuleBase

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
Try
ReportViewer1.ProcessingMode = ProcessingMode.Remote
ReportViewer1.ServerReport.ReportServerCredentials = New MyReportServerCredentials()
ReportViewer1.ServerReport.ReportServerUrl = New Uri("http://ReportUrl/ReportServer/")
ReportViewer1.ServerReport.ReportPath = "/ReportFolder/SAMPLE_REPORT2"

ReportViewer1.ServerReport.Refresh()
Catch ex As Exception
lblMessage.Visible = True
lblMessage.Text = "Error: " & ex.Message
End Try
End Sub
End Class
End Namespace

Public NotInheritable Class MyReportServerCredentials
Implements IReportServerCredentials

Public ReadOnly Property ImpersonationUser() As System.Security.Principal.WindowsIdentity Implements IReportServerCredentials.ImpersonationUser
Get

Return Nothing

End Get
End Property

Public ReadOnly Property NetworkCredentials() As ICredentials Implements IReportServerCredentials.NetworkCredentials
Get

'User name
Dim userName As String = ConfigurationManager.AppSettings("MyReportViewerUser")
If (String.IsNullOrEmpty(userName)) Then
Throw New Exception("Missing user name from web.config file")
End If

'Password
Dim password As String = ConfigurationManager.AppSettings("MyReportViewerPassword")

If (String.IsNullOrEmpty(password)) Then
Throw New Exception("Missing password from web.config file")
End If

'Domain
Dim domain As String = ConfigurationManager.AppSettings("MyReportViewerDomain")

If (String.IsNullOrEmpty(domain)) Then
Throw New Exception("Missing domain from web.config file")
End If

Return New NetworkCredential(userName, password, domain)

End Get
End Property

Public Function GetformsCredentials(ByRef authCookie As Cookie, ByRef userName As String, ByRef password As String, ByRef authority As String) As Boolean Implements IReportServerCredentials.GetformsCredentials

authCookie = Nothing
userName = Nothing
password = Nothing
authority = Nothing

Return False

End Function
End Class

 

Thanks for you help!

Lori
 

 
Previous
 
Next
HomeHomeArchived Discus...Archived Discus...Developing Under Previous Versions of .NETDeveloping Under Previous Versions of .NETASP.Net 2.0ASP.Net 2.0Report not showing in ReportViewerReport not showing in ReportViewer


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