Questions tagged [reporting]

Extracting and presenting data, normally from a database system.

Filter by
Sorted by
Tagged with
1
vote
2answers
28 views

Power BI Upload to SQL Reporting Services 2016 [on hold]

We have SQL Reporting Services 2016 and create SSRS reports, which are published to the report server. I have started to use Power BI Desktop (free), is it possible to upload the power bi reports to ...
0
votes
0answers
22 views

NoSQL database for analytics

Need NoSQL database for analytics. Given: Large, partitioned Postgres(9.4) tables, with next structure: - device_id: UUID - monitored_date: TIMESTAMP - properties: jsonb (different keys) (...
0
votes
2answers
24 views

Aggregating Multiple COTS Databases into a Data Warehouse or similar for Reporting

I am sure this is a very basic question, so I apologize, but I've read lots of articles and done a lot of google searches and have not found any leads for this particular challenge I am looking to ...
0
votes
1answer
28 views

How to succesfully set up sp_AllNightLog to create a Reporting Server?

I would like to set up a secondary, mirrored SQL Server for reporting purposes. The reporting database doesn't have to be up to date with the primary and can generally lag behind the production ...
0
votes
1answer
63 views

Does read-only activity on synchronous secondary replica slow down primary replica in Availability Group?

Suppose that we have an Availability Group configuration (SQL Server 2017) where primary and synchronous secondary do not share any resources (each replica have dedicated CPU, memory, disk, etc.) ...
0
votes
1answer
24 views

Fail-over or switching the Reporting server database

I have two databases in server, dbs-01.One is a transactional database and a reporting server database.Reporting is minimum,that is why we have it together in the same instance. I have transactional ...
2
votes
1answer
18 views

How many nodes can you install SSRS on when using basic availability groups?

I have migrated a SQL Enterprise standalone SSRS installation to a new SQL Standard 2 node Basic AG recently. I got the expected "scale-out-deployment is not supported error", and I resolved that by ...
1
vote
1answer
22 views

How assigning a value to Variable is working in SSRS

Recently started learning Reporting Services using Microsoft SQL Server 2016 Reporting Services, Fifth Edition, Brian Larson. I am creating this one report which uses UNION to create a dataset, ...
0
votes
1answer
34 views

Transactional Replication data during rebuild

To offload reporting I have transactional replication running between my prod box and my reporting server (top image #1). This works great until the snapshot has to be rebuilt. During this time users/...
0
votes
0answers
18 views

SSRS 2016 / VS 2015 Editing text in tablix's textbox very slow in designer

Same issue as described here: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/f6bf89cd-75de-49f9-8a3a-743419ecd631/ssrs-2016-editing-text-in-a-textbox-very-slow-in-the-designer?forum=...
1
vote
1answer
93 views

SQL Server Metric Report Information For Management [closed]

We have a quarterly metric meeting and I report the metrics for all of our production SQL Servers. The people that are looking at these reports are mostly management (some technical, but others are ...
0
votes
0answers
27 views

Synchronizing for reporting, SSIS job vs Transactional replication or other options?

We're faced with a fun challenge. A server has 60+ databases to segment data due to privacy and security. We have 7 tables in each of these databases that need to be merged into a master dataset for ...
1
vote
1answer
166 views

How can I override the default values for a parameter in a report?

I have a report with a parameter that usually gets its default values by running a query that takes another parameter as it's input. This works fine when the report is run interactively. However, I ...
1
vote
1answer
1k views

Conversion failed when converting from a character string to uniqueidentifier

I am creating a Dynamic CRM 2011 Report in SSRS. I use several joins, And use GUID in joins. For ex : Quote.OpportunityId=Opprtunity.OpportunityId The problem comes from parameters. I have a ...
0
votes
1answer
251 views

SSRS Rectangle visibility based on Parameter Value

I am creating a Report in SSRS. Its a Dynamic 2011 CRM Report. I have created some Tables. And some Rectangles. Each Rectangle contains some Tables. Also there is a Parameter that contains value from ...
0
votes
1answer
61 views

Read only replica part of always on availability group for Reporting

As a DBA I would like to include a read only replica into the always on availability group. XSLT / Crystal Reports will only be used. Please see below 1) Primary Replica (Same Data center) ...
1
vote
1answer
113 views

Dynamically changing tables in datasource in SSRS

I have an SSRS report that I have set up to query two tables, let's call them ABC_Audit and ABC_AuditDetail. I have now added XYZ_Audit and XYZ_AuditDetail to the same database, and want to be able to ...
1
vote
3answers
127 views

Login report of Sysadmin

We have got a requirement to provide login report from SQL Server for Sysadmin only - This would have log-in date and time when anyone logged into SQL server having sysadmin privilege. Is there ...
0
votes
0answers
109 views

SQL Login for SSRS Reports require EXECUTE permissions?

Recently my team did a SSRS report deployment.The reporting server was installed in application server and it was pointed to database server.I don't know why we do like that?Probably to avoid load on ...
0
votes
1answer
129 views

MS Access - Creating a report based on a pass-through query that requires a parameter

I am attempting to make a report in Access that uses parameters as well as a pass-through query. I'm open to using a temporary table but the guides I can find using temporary tables all use an ...
0
votes
1answer
46 views

Reporting on a SQL DB Server with many write operations and few read operations [closed]

I know this is a generic question, but I have to clarify some basic questions. I know that when a write is happening to a SQL Server database table, a read to that table will have to wait. My question ...
1
vote
0answers
116 views

Oracle Apex IR subscription not working

I have configured apex instance to use smtp email, and I can send email with IR when using download option from action menu. But the IR subscription is not sending emails. I have checked there is no ...
0
votes
1answer
279 views

Calculate Total Working Minutes in MySql

I have a design a table for attendance and here are the genral fileds AttendanceMachineLoginId EmpId AttendanceDateTime Whenever user will come to office, he has to make his attendance. The first ...
-1
votes
2answers
76 views

Is there any good way to reduce conditional statements (if … else clause) by SQL (or another technology)?

I work for writing reporting with SQL. But unfortunately, queries are very complicated. I analyzed this issue like following: There is a VIEW and some columns to show customers There are some columns ...
0
votes
1answer
29 views

SSRS 2014 Exec Log gives the Service Account as UserName instead of Actual User name

I am using the below query for accessing the Users who are using the Application Reports. SSRS 2014 gives the Service Account(IIS Account used for Application) as User Name instead of Actual User ...
0
votes
0answers
50 views

Multi Tenancy Report Solution

I have a separate database per a client although data structure is same for all databases. Only difference is all clients have their own data on their on databases. Now problem is when I need a report ...
0
votes
1answer
580 views

Report Server Reports Hanging

I'm working on a issue with heavily fragmented indexes on a large production DB. I've pretty much identified the indexes that are heavily fragmented, including those that are not really being used. I ...
0
votes
1answer
91 views

How to easily show very long “canonical” name for each column in all reports?

Related: Does the length of a table name affect performance? For query writing purposes I want to have nice short actual column names. However, from my actual data source, I have an extremely long "...
0
votes
2answers
145 views

Unpredictable performance of queries against snapshot

I've got a basic reporting solution working where we have a collection of views that get exported to CSV files on a daily basis. For numerous reasons, we don't run the reports against the ...
0
votes
1answer
1k views

“Cannot open database version 706. Upgrade the database to the latest version” - when trying to use availability database for read-only access

I have Availability Group with below config: replica-01: SQL Server 2012 (primary) replica-02: SQL Server 2012 (secondary synchronous) replica-03: SQL Server 2016 (secondary asynchronous) replica-01 ...
0
votes
2answers
2k views

How to copy Azure SQL database to on-premises SQL Server daily for reporting?

I have a database as a service SQL instance in Azure, I want to copy this database to a reporting server located in a virtual machine, and this is not SQL as a service, so my COPY statement won't work,...
1
vote
1answer
975 views

SSRS, Limit Fixed number of Columns in Matrix within a Tablix - issue in sorting matrix data

I am converting a crystal report to ssrs report, i am trying to implement "Format With Multiple Columns" feature of crystal report to ssrs. I have a Main tablix that has two Two Groups 1st Group - ...
1
vote
1answer
123 views

Rotate table for year-over-year comparison

I have a road_insp table: create table road_insp ( insp_id int, road_id int, insp_year int, condition number(10,2) ); insert into road_insp (insp_id, road_id, insp_year, condition) ...
1
vote
1answer
32 views

How do I facilitate access to an Azure based SQL View for non-SQL users on Prem? [closed]

Afternoon I'm hoping this one is simple and my general lack of Azure knowledge is the problem, but I need to present data from within a view to some non-SQL end users via some form of application / ...
1
vote
1answer
884 views

Most efficient way to aggregate data to new table

Say I have a large table A around 151 million rows: TableA [Id] [bigint] IDENTITY(1,1) NOT NULL, [MetaDataProp1] [int] NULL, [MetaDataProp2] [int] NULL, [MetaDataProp3] [int] NULL, [MetaDataProp4] [...
2
votes
2answers
72 views

Any existing programs that track the origin of data in your database?

I am doing some integrity work at the moment, investigating cases when something goes wrong with incoming data. The system I am working with involves multiple servers, including Sybase and SQL Sever ...
1
vote
1answer
764 views

Background images in SSRS report resizing on export to PowerPoint

We are experiencing an issue with SSRS 2016, when we export a report with a background image to PowerPoint. The image displays properly in the designer (VS 2015), and in preview as well; it also ...
0
votes
1answer
102 views

Reportviwer matrix show all months/weeks of year

I'm new here, and i have a situation. I need to alter one report that i created a few time ago, that shows the planning of maintenance. But not all months/weeks have plan defined, and i want to show ...
2
votes
1answer
46 views

Sql Server Reporting

I have a report parameter which depends on a query from the Dataset. The query needs one parameter and sql server reporting has no parameter drop down version - Microsoft SQL Server 2016 Report ...
10
votes
3answers
175 views

Looking for advice on how to integrate data from 100+ client DB's into a centralized reporting database

I am a SQL Developer (not DBA or Architect) for a small (~50 employees) SaaS company. I am tasked with figuring out how to: Offload operational reporting from our 100+ OLTP databases Allow those ...
0
votes
1answer
536 views

DNS Alias in SSRS Subscriptions

We have an SSRS instance that is widely used, and we use a DNS alias to access the reports. However, when you create a subscription to a report that sends a link, the server name is given and not the ...
0
votes
4answers
3k views

Finding the first parent (manager) of an employee that makes twice as much in a self-referencing table?

Example you have the following table CREATE TABLE emp (id,name,salary,manager) AS VALUES ( 1 , 'james' , 10000 , null ), ( 2 , 'alex' , 5000 , 1 ), ( 3 , 'Alice' , 4500 , 1 ), ...
0
votes
2answers
669 views

Reporting Services 2016 Multiple Email Accounts

Is there a way to configure SSRS 2016 to be able to send email from more than one email account? I am looking to setup something that is department specific for our organization. Right now its ...
0
votes
2answers
291 views

Should I write to MySQL slave (replica) for reporting?

I intent to put reporting/analytics database on slave and run job scheduler every night to aggregate and insert data from operational database to reporting database. Should I do this or I have to ...
3
votes
0answers
509 views

Weird SSRS reports error while Depolying reports

I have created the reports by using SSRS 2016 and Visual Studio 2015. When I build the reports it shows success, then deploying the report to the Target server URL I get the following error: ...
0
votes
2answers
2k views

Update statement with “case syntax” is unable to update a specific column in temp table

With reviewing a stored procedure for a current SSRS migration. I noticed the case syntax listed below for the temp table (#tempShip) is not taking affect for the column "ord_status" in the temp table....
0
votes
1answer
68 views

How can we restrict content by user role in Tableau dashboard without using Cross Join?

I have a BI admin that created a tool-generated query from Tableau, connecting to a custom database application that tracks issue reports for follow-up action. I can make almost any changes to the ...
1
vote
1answer
842 views

How to run SQL Profiler to monitor 1 specific stored procedure? [duplicate]

I have an issue where a stored procedure will run properly when executed from SQL Management Studio, but when the stored procedure is called from an application, it doesn't return the results to the ...
0
votes
2answers
193 views

SSRS: textbox format hide complete row (group header)

I get a weird behavior formating a textbox in a group header. If the textbox is set to default shows the data, but so soon how set the format to percentage (or anything else) the complete row (group ...
1
vote
0answers
123 views

SSRS - Embed Rich Text (including images) in report

An application my organization is developing includes a rich text editor. The content from this editor (text, tables, images, etc.) is HTML5 and is saved to the database. I'd like to find a way of ...