SSRS engine
This concerns the SSRS engine. For my project, we are not going to buy SQL server software. Instead of what I just want to know if there is an option to use only the SSRS mechanism. So that I can get the link. (DLL) And then I can use it wherever I want.
Please help us with this.
Unless we cover the technical aspects of running SSRS without SQL Server, you still need SQL Server for the license. SSRS is an integrated part of SQL Server, not a stand-alone component.
So, no, without buying SQL Server licenses, you cannot use SSRS even if you were technically capable of doing so, and I doubt it anyway.
source to share
The SQL Server Reporting Services engine is not just a dll. So it won't be easy like adding a link.
Usually you need to deploy reports to a web server and call reports there though.
I would suggest you take a look here: http://en.wikipedia.org/wiki/SQL_Server_Reporting_Services
source to share
You can create local reports that are not stored in the database, if that's what you mean.
http://msdn.microsoft.com/en-us/library/ms252067(v=vs.80).aspx
source to share
SSRS needs SQL Server because the ReportServer and ReportServerTempDB databases must be hosted on SQL Server. SQL Agent is also used by SSRS: https://msdn.microsoft.com/en-us/library/ms156421.aspx
You can try PowerBI as an alternative solution for your project if you do not intend to purchase SQL Server software licenses: https://powerbi.microsoft.com/en-us/
source to share
You need to create local reports (.RDLC) using BIDS in visual studio. To make these reports, you need to write code to pass parameters and values for datasets. You need to add a Report Viewer link and use LocalReport to call the Render method. It will return you a byte array of the rendered report.
using (Microsoft.Reporting.WebForms.LocalReport report = new LocalReport())
{
string appPath = AppDomain.CurrentDomain.BaseDirectory;
report.ReportPath = System.IO.Path.Combine(appPath, "Reports", RDLName.ToString());
foreach (KeyValuePair<string, object> dataSource in ReportDataSource)
{
report.DataSources.Add(new ReportDataSource(dataSource.Key, dataSource.Value));
}
if (ReportParameters != null)
{
foreach (KeyValuePair<string, object> parameter in ReportParameters)
{
report.SetParameters(new ReportParameter(parameter.Key, (parameter.Value == null ? null : parameter.Value.ToString())));
}
}
result = report.Render(Format);
report.Dispose();
return result;
}
source to share