Solved

SSRS application can't print SSRS reports

Posted on 2014-09-08
7
103 Views
Last Modified: 2015-02-20
I have been tasked with upgrading from the SQL Server 2005 service to the SQL SERVER 2008 R2 Service which is really tagged as 2010.  I am attempting to print a report using the SSRS web application and I am trying to change to the new 2008 R2 framework but it is not a direct fit, some changes have to be applied in order for the report printing function to work.  At any rate, I attempt to print a report and I get a 401 error where the report does not print.  Does anybody have any experience with this?  If you would like for me to display some code, I will post it.  Thanks!
0
Comment
Question by:VBBRett
  • 4
  • 2
7 Comments
 
LVL 4

Assisted Solution

by:Nuno Rogado
Nuno Rogado earned 250 total points
ID: 40310556
Hi,

401 is Access Denied.

Check access to data layer.

Check and post logs.

Best Regards,
Nuno Rogado
0
 

Author Comment

by:VBBRett
ID: 40310777
How do you check the logs?
0
 
LVL 27

Accepted Solution

by:
planocz earned 250 total points
ID: 40310902
Most of the time the SQl server is not seeing the SSRS side (software) Also it could be the security login problems.
0
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 

Author Comment

by:VBBRett
ID: 40311010
Well my problem is the finditems function for SQL 2010 SSRS.  I'll post code later
0
 
LVL 4

Expert Comment

by:Nuno Rogado
ID: 40311744
OK, please post your code.
0
 

Author Comment

by:VBBRett
ID: 40312987
OK, so the one thing that I am attempting to do is update a function to work in the SSRS 2010 version.  The old 2005 version had the following code:

   Public Function fnListReports() As Boolean
        'Initialize a SearchCondition object to search by item name
        'using the value obtained from TextBox1
        Dim intItemCount As Integer = 0
        Dim mySearchConditions(0) As ReportingServices2005.SearchCondition
        myReportService.Url = System.Configuration.ConfigurationManager.AppSettings("ReportService")
        mySearchConditions(0) = New ReportingServices2005.SearchCondition
        mySearchConditions(0).Name = "Name"

'myCatalogItems = myReportService.FindItems("/", Nothing, mySearchConditions)

        'Clear the ListView to prepare for loading with new values.

        Try
            intItemCount = 0

            Me.cboReports.Items.Add(New ListItem("** Please Make a selection **", "*"))

            If Not (myCatalogItems Is Nothing) Then
                Dim ci As ReportingServices2005.CatalogItem
                For Each ci In myCatalogItems
                    If ci.Type = ReportingServices2005.ItemTypeEnum.Report Then
                        Me.cboReports.Items.Add(New ListItem(ci.Name, ci.Path))
                    End If
                    intItemCount = intItemCount + 1
                Next ci
            End If
        Catch ex As Exception
            'MsgBox(ex.Message)
            Me.lblError.Text = "** " & ex.Message
            Me.lblError.Visible = True
            'For a production environment, you should create
            'specific error-handling routines
            Throw New Exception("Unable to build tree view.")
        End Try
    End Function

Open in new window

0
 

Author Comment

by:VBBRett
ID: 40313067
The problem that I am having is that the 2010 SSRS version requires 4 parameters to complete the statement.  I got the following error when I attempted to run the program.  I need the following line of code to be fixed:

myCatalogItems = myReportService.FindItems("/", Nothing, mySearchConditions)
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error With the introduction of SQL Server 2008 R2 and Vista (Windows 7 as well) came new enhanced security features. One of the features included was User Access Control (UAC) t…
Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
This is a video that shows how the OnPage alerts system integrates into ConnectWise, how a trigger is set, how a page is sent via the trigger, and how the SENT, DELIVERED, READ & REPLIED receipts get entered into the internal tab of the ConnectWise …

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now