Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I would set the report parameters as Internal but read up on this article <a href="http://msdn.microsoft.com/en-us/library/aa337234.aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/aa337234.aspx</a> for the section Hidden and Internal Parameters and decided for yourself what is appropriate to the problem.</p> <p>Assuming you have a stored proc like</p> <pre><code>CREATE PROCEDURE dbo.RepeatAfterMe ( @inputText varchar(50) , @repeatFactor int = 10 ) AS BEGIN SET NOCOUNT ON DECLARE @count int DECLARE @hack TABLE (inputText varchar(50)) SET @count = 0 WHILE @count &lt; @repeatFactor BEGIN INSERT INTO @hack SELECT @inputText SET @count = @count + 1 END SELECT H.* FROM @hack H END GO </code></pre> <p>Define 2 report parameters in SSRS (InputText as string, RepeatFactor as integer). Then, in your SSRS, your dataset would be defined like</p> <blockquote> <p>EXECUTE dbo.RepeatAfterMe @inputText, @repeatFactor</p> </blockquote> <p>And then on the Parameters tab of the dataset, it would look like</p> <pre><code>@inputText =Parameters!InputText.Value @repeatFactor =Parameters!RepeatFactor.Value </code></pre> <p>For completeness of solution, this is an approximation of the code I use to pass parameters in to a report control with an ID of rvReportViewer</p> <pre><code>Microsoft.Reporting.WebForms.ReportParameter[] reportParameters = null; reportParameters = new Microsoft.Reporting.WebForms.ReportParameter[2]; reportParameters[0] = new Microsoft.Reporting.WebForms.ReportParameter("inputText", txtInput); reportParameters[1] = new Microsoft.Reporting.WebForms.ReportParameter("repeatFactor", 10); try { rvReportViewer.ServerReport.SetParameters(reportParameters); } catch(Microsoft.Reporting.WebForms.ReportServerException ex) { Response.Redirect("~/Error.aspx"); } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POPassing parameters from ReportViewer through to stored procedure data source for SSRS report
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USbillinkc
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POPassing parameters from ReportViewer through to stored procedure data source for SSRS report
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThanks, Bill. I have it working perfectly now.
      singulars
      1. PO
      1. USMark Freeman
 

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