Questions tagged [reporting]
Extracting and presenting data, normally from a database system.
153
questions
0
votes
0
answers
15
views
SSRS 2016 - How to Add Custom Web Portal Connection
We are replacing an old VM which was configured with reporting services 2016. The Web Service and Web Portal URL's were configured for both a "public" URL which looks nicer as well as a URL ...
1
vote
0
answers
28
views
SSRS not using MSA or gMSA account on Domain [duplicate]
I am trying to install SSRS on a new server to report on our new database server and want to use a MSA account on our domain (server is on our domain) but I keep getting errors when trying to start ...
- 11
1
vote
1
answer
913
views
Get the size of all Azure SQL Databases
I need to produce a report showing all our Azure SQL Databases with their size. The databases are split among many resource groups in several subscriptions.
I can get the information for a single ...
- 1,434
0
votes
0
answers
101
views
Is there a built-in field or other way to put the rdl date/time stamp on a SSRS report template?
I've put the built-in fields for the report server and the report name at the bottom of my reports. I want to also put the date/time stamp of the report's .RDL file on it so we can see if the report ...
0
votes
0
answers
202
views
the version of the report server database is either in a format that is not valid or cannot be read
Has anyone come across this message before?
the version of the report server database is either in a format that
is not valid or cannot be read. The found version is 165. The expected
version is 163.
- 1
-2
votes
3
answers
4k
views
Automate SQL Server reports and send them by mail
I work in a large retail business with a decent SQL Server environment.
We have SQL Server replication, Availability Groups, Data warehouse, and some cloud services. In this beautiful environment, we ...
- 45
-3
votes
3
answers
681
views
Does it make sense to use a non-relational database for reporting/BI/visualisation tools?
Relational databases are well used in reporting/visualisation tools such as Power BI, Tableau...
Non-relational databases are getting popular and many reporting tools allow its connection. However I ...
- 17
0
votes
0
answers
28
views
Getting the max ID of integer columns in databases in Postgres 9.6/12
I am looking to get the max ID of each integer column in our databases servers.
The function I currently use:
CREATE OR REPLACE FUNCTION intpkmax() RETURNS
TABLE(schema_name name, table_name name, ...
- 429
0
votes
0
answers
419
views
Report Builder "Select All"
I have SSRS Report that is based on user's decision to bring data from selected Procedure.
I have 5 parameters:
@Country, @StartDate, @EndDate, @MinLenght, MaxLenght
When user Selects Just one value ...
- 1
0
votes
2
answers
206
views
Can I make a short-lived readonly snapshot for reporting in Azure SQL DB?
I have an Azure SQL DB (OLTP), that is under considerable load, let's call it AppDB. AppDB is transactionally consistent, but new rows are written to it constantly. Now I need to populate ReportingDB ...
- 245
0
votes
1
answer
266
views
SSRS migration with Same Name and Moving of Reporting Files
This is will be my first SSRS migration and please bear with me if some points don’t make any sense.
I need to migrate the Reporting server but need to keep the same name so that the reporting URL don’...
- 1,039
0
votes
1
answer
448
views
Will an SSRS report on Azure SQL Database work?
Can we build an SSRS report using Visual Studio 2019 with Azure SQL server as PaaS mode?
We migrated to Azure Database from VM SQL Managed instance.
- 113
1
vote
0
answers
76
views
Span a record on multiple pages in MS Access [closed]
MS Access has a limitation in its Reports functionality that is max Section height is 22.75 in. (57.79 cm). I want to create a report that will use data from a single record to span on 12 pages in a ...
0
votes
2
answers
75
views
SQL Server Reporting Server Migration
I have a separate database server and a separate reporting server. I would like to upgrade and migrate the database server to a separate server and do not to touch the reporting server. Since the ...
- 1,039
4
votes
2
answers
1k
views
what is the best approach to send report by Email?
I've been requested to create some sql server reports ( create a report and send them by email ) for some poeple. I thought it would be like 2 or 3 but now that they know I can do it, every week I ...
- 7,374
0
votes
1
answer
31
views
Can't load reportserver in browser
We are running SQL Server 2016 and cannot view the list of reports in the browser when we go to http://servername/reportserver. When we go to that link in the browser, it asks for credentials. When I'...
- 121
1
vote
0
answers
3k
views
SSRS 2019 with an oracle data source
I am working on migrating a number of reports from an SSRS 2012 install to a SSRS 2019 install. These are all pretty simple and straight forward reports, built in microsoft report builder. A number ...
- 678
1
vote
1
answer
734
views
Reporting Services - Host header and Windows Authentication
SQL 2016 - Enterprise Edition
Windows 2016
Reporting Services runs on domain account (SPN registered for new host header)
Problem:
When adding a host header in Reporting Services Configuration tool, ...
- 425
0
votes
1
answer
638
views
Concatenate in MS Access - how to omit space and comma if first value is missing?
I am concatenating 2 values in a MS Access Report: "Method" and "Experiment" and they are to be separated by a comma (,).
I have figured out how to concatenate succesfully when the second value is ...
- 13
3
votes
2
answers
2k
views
SSRS Report by URL with parameter-value AND retain full top menu
TL;DR: How can I link to an SSRS (2016) report by URL, with a parameter in the query-string, AND retain (show) the FULL MENU bar (the top "SSRS chrome" that has the Favorites, Browse, Settings, ...
- 804
0
votes
1
answer
35
views
SQL 2 Columns of Different Types in Same Table - Working With 'Uknown' Amount
I'm very new to SQL and I've been searching for an answer for a while now, can't seem to find it.
I have 1 table of CustOrders which has 3 columns.
Table CustOrders
Name (varchar)
Number_Orders (...
0
votes
0
answers
31
views
How do I set up a report that shows number of clients by age group when their age is stored by date of birth in Microsoft Access
I am working on setting up a new database in Microsoft Access for a food locker it will be used for client input as well as tracking client visits. One of the monthly reports they need is how many ...
10
votes
4
answers
17k
views
SSRS error "something went wrong please try again later" in web portal
I have a brand new installation of SQL Server Reporting Services 2019 on top of MSSQL 2019 Enterprise CU1.
SSRS has been installed and configured using default settings, apart from the service account ...
- 503
0
votes
1
answer
30
views
Trouble producing a query that groups a selection of groups
In terms of context, I believe that all that is needed is to know that I have a table, t_sale, that logs sales made. It logs a few things, such as day and location of sale in the shop, but what is ...
- 11
1
vote
0
answers
84
views
SQL Server Report how to create multiple groups with hidden details
I have created a report that has multiple rows returned from one query.
I have a chart that is created for all the row and I have it grouped on the server location. the group properties of the ...
1
vote
1
answer
1k
views
Query Editor Connection Error With Unattended Service Account
ERROR:
When editing a report in report builder, opening the query editor gives the following error
You have specified integrated security or
credentials in the connection string for the
data ...
0
votes
0
answers
423
views
SSRS - Install Reporting Server (incl IIS) separate from SQL Server
We have to migrate our existing SSRS database from an old SQL server to our new SQL cluster.
With this opportunity we would like to install de the reporting server on separate machine from the ...
- 33
0
votes
1
answer
109
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 ...
- 1
0
votes
1
answer
417
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
1
answer
566
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.)
...
- 5,472
0
votes
1
answer
90
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 ...
- 1,295
2
votes
1
answer
139
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 ...
- 257
1
vote
1
answer
1k
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, ...
- 45
0
votes
1
answer
123
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/...
2
votes
0
answers
374
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=...
- 804
1
vote
1
answer
99
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 ...
- 36
1
vote
1
answer
1k
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 ...
- 302
2
votes
1
answer
21k
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
1
answer
2k
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
1
answer
364
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,039
1
vote
1
answer
1k
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 ...
- 13
1
vote
3
answers
596
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 ...
- 3,894
0
votes
0
answers
439
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 ...
- 1,295
1
vote
1
answer
2k
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 ...
- 157
0
votes
1
answer
87
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,295
1
vote
0
answers
388
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 ...
- 11
2
votes
2
answers
943
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
2
answers
318
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 ...
- 121
0
votes
1
answer
34
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 ...
- 1,580
0
votes
0
answers
70
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 ...
- 101