January 3, 2017 at 11:37 am
Hello,
I have recently had a new to me SQL Server upgraded from 2014 to 2016, was running only SSDE, SSIS, and SSAS Tabular, now I have had an SSAS MD instance created as well as had SSRS installed and turned on for the first time. We currently have an Azure Gateway that hosts our on premise SSAS Tab cubes, and access the cubes data source in Power BI Services and have built a number of Dashboard and Reports with that method and format.
Once SSRS was installed and running, I was given a Web URL to the our SSRS Instance. I went through some security and access issues that have been resolved. So I'm seeing SSRS for the first time, and as I poke around, I get the impression that it's basically used to show case a completed report. I don't see any reporting type tools anywhere.
Am I to download/install another tool (Report Builder?) to use on my PC in concert with the SSRS Web link in order to build Dashboards or reports in SSRS so it can host them?
Am I to use Visual Studio to connect to SSRS to design/create the report there, and then someone deploy it and bring the report into SSRS that way? Is that that the way most folks use it?
As far as advise, guidance and direction, my original idea, as we have a lot of complex reports written in freehand SQL that pull from a Teradata data warehouse that go into an Excel file and emailed/share-drive/SharePoint, I thought, I could take that SQL code and place into a SSRS report and source the data warehouse, bring that report output into the SSRS world instead, and from there, use Power BI to read that report, and use the Power BI Services as the main central report/dashboard repository, and this would be good use of having SSRS (and Report Builder?) to get away from freehand SQL, Excel and eMail. I'm open to best practice suggestions that best utilize my current systems and tools.
Thanks,
JPQ
January 3, 2017 at 8:13 pm
What version of SQL Server are you using? If you're using something post-2012(?), you have to download and install SQL Server Data Tools (used to be BIDS)... that enables you to create SSIS packages, SSAS cubes, SSRS reports.
January 4, 2017 at 4:30 am
I'm assuming that the OP is using SQL Server 2016 (as they recently upgraded)?
You'll need to install Visual Studio 2015, and then install SSDT, which you can find here.
Once installed, you can start of VS and create a new project which is a SQL Server Reporting Services Project. From there you will be able to build and deploy your reports to your SSRS Server. SSRS is probably the most user friendly of the BI tools, especially for those not used to the BI tools.
Subscriptions (mailings and fileshares) are done from the web portal, which by default is http://[yoursqlserver]/ReportServer.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply