Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [reporting]

Extracting and presenting data, normally from a database system.

2
votes
1answer
11 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
21 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
32 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
7 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
24 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
89 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
955 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
62 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
47 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
67 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
93 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
86 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
94 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
43 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
84 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
248 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
70 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
45 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
460 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
77 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
122 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
901 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
109 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
815 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
71 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
707 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
88 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
45 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
174 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
481 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
2k 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
589 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
271 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
434 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
734 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
173 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
114 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 ...
1
vote
2answers
376 views

Need a parallel database for reporting purpose

As our team is planning to implement BI reporting in our application, they requested a separate but a parallel db for reporting purpose in which data should be as in our production db. I read about ...
1
vote
0answers
32 views

Options for transferring/transforming from one database to another?

We have a hosted instance of intersystems-cache. There is an aggregate log that is near 600 million rows and is rather abstract and complicated. I am planning to parse this log and store more ...
1
vote
0answers
186 views

Teradata backup information query

I'm looking for a way to query the last backup time for each database in Teradata 14.10. I am piecing together something with info from DBQL tables, but am unable to get anything that seems to be ...
1
vote
1answer
75 views

How to use a list in a list in report builder?

I'm currently using Microsoft SQL Report Builder to create a custom report for my data. I have a table of customers, a table of devices and a table of jobs (each customer has a couple of devices, each ...
1
vote
0answers
922 views

Changing row colour based on a group toggle - SSRS 2014

One of the tables in my report looks somewhat like: Row Colour Total grey +Category white +Category white +Category white +Category white It's expandable to Row Colour Total ...
-1
votes
1answer
290 views

Installation/Configuration Error Installing 2012 SSRS Native Mode

I believe I properly installed Reporting Services for SQL Server 2012 Developer edition however I get a HTTP 500 error when attempting to view the report viewer or manager URLs in both IE 10 and ...