Wednesday, April 25, 2012

SQL Server Business Intelligence Development Studio looks like Visual Studio 2008.

But you use it for editing .rdl (reports) and .rds (data sources) files for SSRS. You install BIDS as part of Microsoft SQL Server 2008. Here one may modifty the parameters that get passed to a stored procedure that an .rdl wraps.

<ReportParameters>
   <ReportParameter Name="StartDate">
      <DataType>DateTime</DataType>
      <AllowBlank>true</AllowBlank>
      <Prompt>StartDate</Prompt>
   </ReportParameter>
   <ReportParameter Name="EndDate">
      <DataType>DateTime</DataType>
      <AllowBlank>true</AllowBlank>
      <Prompt>EndDate</Prompt>
   </ReportParameter>
</ReportParameters>

No comments:

Post a Comment