Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>If you're trying to do this in a form in code behind then you need to find the report viewer object and add an event to the RenderingComplete that implements Find, so something like this:</p> <pre><code>public Report() { InitializeComponent(); rpViewer.RenderingComplete += new RenderingCompleteEventHandler(rpViewer_RenderingComplete); } void rpViewer_RenderingComplete(object sender, RenderingCompleteEventArgs e) { int x = rpViewer.Find("0", 1); } </code></pre> <p><strong>EDIT:</strong></p> <p>So, since this in a webpage you can't use the WinForms Controls, however, I was able to wire up a little less hacked version using Javascript that klabranche had used.</p> <p>Here's a code behind class that adds a javascript function to the body of the html to search the report for the search text that you want:</p> <pre><code>private void SearchReport(ReportViewer rv, string SearchText) { TextBox txt = (TextBox)rv.Controls[1].Controls[4].Controls[0]; txt.Text = SearchText; this.Body.Attributes.Add("onload", "javascript:document.getElementById('" + rv.ClientID + "').ClientController.ActionHandler('Search', '" + SearchText + "');"); } </code></pre> <p>If you don't add the search text to the text box, then it won't show the search string in the text box on the report. This also only works for one report, so if you had additional reports you'd need to alter this. Also, for this to work you need to alter the body tag of your html:</p> <pre><code>&lt;body id="Body" runat="server"&gt; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POSql Reporting services - find item in report - on load
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USNoah
    1. USNoah
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COMy report viewer object does not seem to have a 'find' method. Do I need more than the Microsoft.Reporting.WebForms reference?
      singulars
      1. PO
      1. USPraesagus
    2. COThe find method is in Microsoft.Reporting.WinForms, so this may not work for you. How are you displaying the report? Is it on a webpage? What does the code look like?
      singulars
      1. PO
      1. USNoah
    3. COI added code to the question. How can I set up a reference to Microsoft.Reporting.WinForms?
      singulars
      1. PO
      1. USPraesagus
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload