Solved

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

Posted on 2011-02-14
5
487 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
ID: 34890826
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
ID: 34891023
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
ID: 34891090
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
ID: 34891573
.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
ID: 34891647
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

932 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

14 Experts available now in Live!

Get 1:1 Help Now