Software Engineer
asked on
How to Install/Find/Use the Ability to Create and Edit an SSRS Report
Hi:
I really hate that someone has made it very difficult to create or edit a SQL Reporting Services (SSRS) Report. In the old days, when I worked with SSRS everyday, I simply used the Business Intelligence Development Studio (BIDS).
Now, you cannot find anything like BIDS in the newer versions of SSRS. I hate Report Builder and refuse to use it.
Last week, I followed instructions found online and installed Visual Studio Tools. And, I asked the IT department to reboot the SQL box late at night. This was all in an effort to find the latest equivalent of BIDS.
But, I cannot find this.
What in the world do I use and how do I find it?
Please help! I can't believe that this tool has been buried, in the newer version of SSRS.
Thank you! Much appreciated!
John
I really hate that someone has made it very difficult to create or edit a SQL Reporting Services (SSRS) Report. In the old days, when I worked with SSRS everyday, I simply used the Business Intelligence Development Studio (BIDS).
Now, you cannot find anything like BIDS in the newer versions of SSRS. I hate Report Builder and refuse to use it.
Last week, I followed instructions found online and installed Visual Studio Tools. And, I asked the IT department to reboot the SQL box late at night. This was all in an effort to find the latest equivalent of BIDS.
But, I cannot find this.
What in the world do I use and how do I find it?
Please help! I can't believe that this tool has been buried, in the newer version of SSRS.
Thank you! Much appreciated!
John
ASKER
I really don't want to use Report Builder. Thank you, for the suggestion, however.
Well in that case the alternate answer to your question "What in the world do I use and how do I find it?" is... The Report Designer based on Visual Studio with all the goods and bads of having to use such a heavy/overloaded (in my opinion) tool just for SSRS Reports.
"Use Report Designer to create full-featured Reporting Services paginated reports and reporting solutions. Report Designer provides a graphical interface in which you can define data sources, datasets and queries, report layout positions for data regions and fields, and interactive features such as parameters and sets of reports that work together.
Report Designer is a feature of SQL Server Data Tools (SSDT), a Microsoft Visual Studio environment for creating business intelligence solutions. SQL Server Data Tools (SSDT) is not included with SQL Server. Download SQL Server Data Tools.
"
https://docs.microsoft.com/en-us/sql/reporting-services/tools/design-reporting-services-paginated-reports-with-report-designer-ssrs?view=sql-server-2017
"Use Report Designer to create full-featured Reporting Services paginated reports and reporting solutions. Report Designer provides a graphical interface in which you can define data sources, datasets and queries, report layout positions for data regions and fields, and interactive features such as parameters and sets of reports that work together.
Report Designer is a feature of SQL Server Data Tools (SSDT), a Microsoft Visual Studio environment for creating business intelligence solutions. SQL Server Data Tools (SSDT) is not included with SQL Server. Download SQL Server Data Tools.
"
https://docs.microsoft.com/en-us/sql/reporting-services/tools/design-reporting-services-paginated-reports-with-report-designer-ssrs?view=sql-server-2017
ASKER
Thanks, lcohan.
Unfortunately, before posting this case, I had already rifled through that link. It told me to download the tools, which I did last Friday, to no avail. I do not see the Report Designer in any of the Tools' list.
The reason that I need to use the Report Designer is because, not only is that the app that I was trained on, but that app is the only one that I have used to conduct either modifications or creation of SSRS reports.
I don't like Report Builder because it is neither user friendly nor does it offer in any way, shape, or form a simple means of uploading reports once you have conducted modifications.
Thanks!
John
Unfortunately, before posting this case, I had already rifled through that link. It told me to download the tools, which I did last Friday, to no avail. I do not see the Report Designer in any of the Tools' list.
The reason that I need to use the Report Designer is because, not only is that the app that I was trained on, but that app is the only one that I have used to conduct either modifications or creation of SSRS reports.
I don't like Report Builder because it is neither user friendly nor does it offer in any way, shape, or form a simple means of uploading reports once you have conducted modifications.
Thanks!
John
What SQL Server version are you using?
Did your had a look at "Deployment and Version Support in SQL Server Data Tools (SSDT)"
https://docs.microsoft.com/en-us/sql/reporting-services/tools/deployment-and-version-support-in-sql-server-data-tools-ssrs?view=sql-server-2017
"SQL Server Data Tools supports the following scenarios:
Open report definitions (*.rdl) and report server projects (*.rptproj).
Build report definitions.
Preview reports in Report Designer.
Deploy reports to report servers."
Did your had a look at "Deployment and Version Support in SQL Server Data Tools (SSDT)"
https://docs.microsoft.com/en-us/sql/reporting-services/tools/deployment-and-version-support-in-sql-server-data-tools-ssrs?view=sql-server-2017
"SQL Server Data Tools supports the following scenarios:
Open report definitions (*.rdl) and report server projects (*.rptproj).
Build report definitions.
Preview reports in Report Designer.
Deploy reports to report servers."
ASKER
Hi lcohan:
It's SQL Server 2017. Yes, I had already reviewed that document prior to opening this case. It does not explain how to find the Report Designer.
Sure, it lists the steps for finding the Report Designer. But, the steps are wrong.
John
It's SQL Server 2017. Yes, I had already reviewed that document prior to opening this case. It does not explain how to find the Report Designer.
Sure, it lists the steps for finding the Report Designer. But, the steps are wrong.
John
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Microsoft SQL Server 2008 R2 Report Builder 3.0
https://www.microsoft.com/en-ca/download/details.aspx?id=6116
Microsoft® SQL Server® 2016 Report Builder
https://www.microsoft.com/en-us/download/details.aspx?id=53613