<div>
I followed your directions. I have a few questions and I was wondering if you could let me know.<br />
<br />
I was testing a sp using just one parameter, it works fine. But when I try to add a second parameter, it always returns 0 rows.<br />
<br />
SP works fine in SQL. I am not sure when the error occurs. &nbsp;I have confirmed that the values of two parameters did reach &quot;sCommandText&quot; in your code. Any ideas? &nbsp;thanks
</div>


I followed your directions. I have a few questions and I was wondering if you could let me know.

I was testing a sp using just one parameter, it works fine. But when I try to add a second parameter, it always returns 0 rows.

SP works fine in SQL. I am not sure when the error occurs.  I have confirmed that the values of two parameters did reach "sCommandText" in your code. Any ideas?  thanks

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Is there a way to let user build their own report on line? What I want to achieve is to make sure user can only use the pre-defined report template and dataset. They basically can just enter parameters to filter the data they need and generate report.<br />
<br />
Other than that, they can not modify any other settings. Is it possible? &nbsp;thanks
</div>
</div>


Hi,

Is there a way to let user build their own report on line? What I want to achieve is to make sure user can only use the pre-defined report template and dataset. They basically can just enter parameters to filter the data they need and generate report.

Other than that, they can not modify any other settings. Is it possible?  thanks

Report Builder 3.0

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

Power BI is a business analytics tool from Microsoft used for data visualization. It integrates seamlessly with other tools, like Microsoft Excel, and is easily embedded in websites and apps. Power BI offers live dashboards and visual reports to help “bring your data to life.” There are many opportunities for customization, as well as built-in options for your visualizations and analytics. With the Power BI mobile app, you can receive push notifications about important data changes, allowing you to react and plan right away.