Stack Exchange Network

Stack Exchange network consists of 174 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.

0
votes
1answer
13 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
28 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
45 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
35 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
42 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
40 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
38 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
113 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 ...
0
votes
0answers
84 views

Count() used in sql query giving #Error in SSRS report after report deployment on report server

I am newbie to SSRS and I am trying to display basic reports in SSRS. I have create a simple table with 1 column named "TotalNumber", whereTotalNumber display the count of total number of user in the ...
-1
votes
2answers
59 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
28 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
30 views

In 2018, what are the available ways of getting “materialized views” out of a mySQL DB? [duplicate]

I got a MySQL DB i'm using as data warehouse to store normalized data. For report building out of it, I think I should de-normalize my data, and then cache it somewhere with sort of a refresh tool (...
0
votes
0answers
41 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
177 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
0answers
71 views

SSRS Subscriptions are not sent to the users

I have an SSRS report, in which Subscriptions are configured. There are multiple Subscriptions. Some times the users subscribed are not getting the reports. No error in the Subscriptions tables in ...
0
votes
1answer
62 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
74 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
748 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
1k 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
712 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
93 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
0answers
21 views

MS SQL 2016 Standard Reporting / querying large table with high number of WRITES without affecting WRITE performance [closed]

I have a couple large tables (15 million rows) that record things like views/conversions on a webpage and they are optimized for WRITE access and perform well. But once I start querying these tables ...
0
votes
0answers
56 views

Need to collect Microsoft SQL server login with permission from multiple server and insert to a database

I am using below T-sql to view permissions but I would like collect the permissions from multiple server and insert them into a database so I can run a report on the data. What is the best way to do ...
1
vote
1answer
604 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
70 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
542 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
66 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
44 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
168 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
358 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
410 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
230 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
293 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: ...
2
votes
0answers
31 views

Auto-generated query tools [closed]

I was wondering if it exists, somewhere, a project / tool / library that can generate automatically an interface for users to browse data. Let me explain, with an existing project. The Panda Project ...
0
votes
2answers
1k 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
63 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
588 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
121 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
79 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
288 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
29 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 ...
0
votes
0answers
44 views

Adhoc Reporting

I am new to this forum and I am not sure if this is the right place to ask so my apologies if not and please guide me to the right place. I work for a manufacturing company and we collect data with ...
1
vote
0answers
134 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
69 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
755 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
239 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 ...
1
vote
0answers
546 views

SQl query to create a report based on multiple relational tables

I have an e-commerce website and I'm in the process of creating a sales report. These reports need to be divided by year and month. Each sale made on the website will generate a relational link ...
0
votes
1answer
78 views

SSRS trying to deploy to wrong server

I added a report project to my existing solution in VS2015, built some reports and now I am trying to deploy the project to a report server. I have gotten the URL from the config manager ( http://...