Stack Overflow
Stack Overflow

Questions tagged [azure-sql-reporting]

Cloud based version of SQL Server Reporting Services for Windows Azure

22 questions
33
votes
8 answers

How to setup SSRS with an Azure SQL Server Database

I have a SQL Server Database on Azure Cloud and I want to get a report server up and runnning using SSRS that would accesses the data on that database. Does anyone have any experience with this scenario, or could provide me some guidance on how to…
PeonProgrammer
  • 1,445
  • 2
  • 15
  • 27
3
votes
2 answers

adding Azure reports to MVC app

I want to embed reports to a MVC application which are hosted on Azure Reporting Server. Do any one have any idea ?
Krrish
  • 135
  • 15
2
votes
1 answer

Unable to download msnodesql-0.2.1-v0.10-x64.msi

I'm trying to write Node.js code to connect to Azure SQL Database and unable to install the "msnodesql" module for my node.js application, it through's an error saying that " Unable to download msnodesql-0.2.1-v0.10-x64.msi". so can any one please…
praveen gogula
  • 599
  • 3
  • 6
  • 22
2
votes
0 answers

Azure SQL Reporting Services - cost and options

At the moment, it costs $119 per month to use Azure SQL Reporting services. We want to make the move to Azure SQL Reporting/SSRS as our reporting capabilities are expected to grow quite dramatically over the next couple of years. Right now, only…
Dave New
  • 38,496
  • 59
  • 215
  • 394
1
vote
1 answer

Is the Azure SQL Reporting Service a complete replacement of SSRS?

I think the question in this thread's title is self-explanatory. Is there still a way to use SSRS or is SQL Azure Reporting Service the way to go? This question may sound a little bit strange but I even have never used SSRS (seems to be server…
ceran
  • 1,392
  • 1
  • 17
  • 43
1
vote
1 answer

How to connect azure analysis services with azure sql db for 250GB table size data?

we have a view which generated around 250GB data and connected with power bi but the performance is bad. Now we are thinking to connect this view via azure analysis services and connect with power bi. But when i see the pricing tiers there is no…
Pradeep Kaja
  • 115
  • 1
  • 16
1
vote
1 answer

Does SSRS in an Azure Virtual VM support Report Server Databases as Azure SQL Database and/or Azure SQL MAnaged Instance?

I installed SSRS into an Azure VM (IaaS). In the ssrs configuration manager, I tried the report server databases point to an Azure SQL Managed Instance database, but the connection didn't work. I would like to know if SSRS in an Azure VM support…
GMVS
  • 11
  • 1
1
vote
1 answer

SSRS in Scale-Out deployment

Has anyone on this forum, deployed SSRS in Scale-Out deployment? Having 2 SSRS instances on different machines connect to one database? I am trying to deploy 2 SSRS server loadbalanced to connect to one database which is hosted on SQL-Always On…
Ssutar
  • 11
  • 2
1
vote
2 answers

Fatal error: Call to undefined function sqlsrv_connect() using wamp php 5.5.12

I am trying to connect to a Azure data base. I have read many other stack overflow answers but they did not work for me: -I have downloaded all the drivers that Azure offers to you. They are in C:\wamp\bin\php\php5.5.12\ext folder: -I have…
Adrián Rodriguez
  • 430
  • 11
  • 26
1
vote
1 answer

Where is the Windows Azure SQL Reporting Portal?

According to the MSDN documentation for Windows Azure SQL Reporting Services, the reporting portal is supposed to be accessible from the main Azure portal: The Windows Azure Management Portal includes portals for Windows Azure SQL Database, SQL…
Paul Keister
  • 12,851
  • 5
  • 46
  • 75
0
votes
1 answer

AZURE | ADF | Logging the pipeline runs (execution details) in sql table

I want to design a feature in ADF pipeline by which I can store the execution details in sql table or CSV files. execution details for example at which activity pipeline failed pipeline name ,how many records got inserted updated in table by running…
Amol Deshmukh
  • 1
  • 1
0
votes
1 answer

Compare data between two Azure SQL DB's

I have a requirement where I have to compare data between two tables from two different Azure SQL DB's. Both the database have same schema so i just need to compare the data. What are all the options i have since i cant do a cross SQL querying in…
Sam
  • 3
  • 1
0
votes
1 answer

Get all dates greater than current date in SSRS

I have two parameters in my Report - Begin and End Dates which are of Date/Time type. When I select the Begin Date from the Calendar, how do I automatically show dates equal to or greater than Begin Date for the End Date calendar? I would like the…
Julaayi
  • 403
  • 2
  • 8
  • 23
0
votes
1 answer

Splitter Function in Azure SQL Data Warehouse

I am trying to build a Function that accepts multi-value parameters by referencing the code here. However, I am getting an error creating it. What is wrong here? CREATE FUNCTION [dbo].[func_CommaDelimitedString] (@val nvarchar(100)) RETURNS…
Julaayi
  • 403
  • 2
  • 8
  • 23
0
votes
1 answer

SSRS adding extra characters when exporting to CSV

I am creating an expression combining multiple fields into a single field in SSRS. However when I am exporting to CSV, some of the records are being appended with additional double quotes. How do I fix this? Original…
Julaayi
  • 403
  • 2
  • 8
  • 23
1
2