Solved

programmatically position webforms.reportviewer to desired row AFTER report is generated

Posted on 2011-02-14
5
486 Views
Last Modified: 2012-08-13
I'm using SSRS 2005.  In code behind, how do I position webforms.reportviewer to one desired row AFTER report is generated.

And please don't answer "use Find" or "use Search" unless you provide a code sample because I've looked everywhere and can find no samples for accomplishing this in 2005.

Fred
0
Comment
Question by:volking
  • 3
  • 2
5 Comments
 
LVL 5

Accepted Solution

by:
skrga earned 500 total points
Comment Utility
Can this help you : http://www.c-sharpcorner.com/UploadFile/mahesh/SearchReports04252007103246AM/SearchReports.aspx

You can remove text box and put code to be executed automatic when report generates
0
 
LVL 5

Author Comment

by:volking
Comment Utility
skrga - Nope ... no help

when I enter the code line ...
     me.reportviewer1.find("XYZ",1)
I get this error ...
     'Find' is not a member of 'Microsoft.Reporting.WebForms.ReportViewer'

Fred
0
 
LVL 5

Assisted Solution

by:skrga
skrga earned 500 total points
Comment Utility
Hm, are you trying to do this with .net code or on report code ?

This is for report with modified url : http://msdn.microsoft.com/en-us/library/ms153977%28SQL.90%29.aspx
0
 
LVL 5

Author Comment

by:volking
Comment Utility
.net code ... like this ...

    Private Sub RunReport(ByVal WhichReport As String)
        ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote
        ReportViewer1.ServerReport.ReportServerUrl = New Uri("http://??.??.??.??/reportserver")
        ReportViewer1.ServerReport.ReportPath = ""http://??.??.??.??/reportserver/BirthdayRoster"
        Dim paramlist As New Generic.List(Of ReportParameter)
        paramlist.Add(New ReportParameter("UserID", Profile.Operatorid, False))
        ReportViewer1.ServerReport.SetParameters(paramlist)
        ReportViewer1.ShowParameterPrompts = False
        ReportViewer1.ShowPromptAreaButton = False
        DisableUnwantedExportFormats(ReportViewer1)
        ReportViewer1.ServerReport.Refresh()
    End Sub

Not sure how (or even "IF") adding to the URL is possible????
0
 
LVL 5

Author Comment

by:volking
Comment Utility
and ... trying this ...

ReportViewer1.ServerReport.ReportPath = ""http://??.??.??.??/reportserver/BirthdayRoster?rc:FindString=Tomberlin""

generates an error ...

An exception of type 'Microsoft.Reporting.WebForms.ReportServerException' occurred in Microsoft.ReportViewer.WebForms.dll but was not handled in user code
Additional information: The path of the item '/RsMainDevRe/BirthdayRoster?rc:FindString=Tomberlin' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash. (rsInvalidItemPath)

0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

743 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