Skip to main content

Questions tagged [reporting]

Extracting and presenting data, normally from a database system.

Filter by
Sorted by
Tagged with
0 votes
0 answers
27 views

How to remove a border or box surrounding a text box from a Microsoft Access report?

After adding a "Country" label and textbox to the underlying query, and then to the report, the "Country" label has a box around it. I cannot find the control to remove this box. ...
Nick's user avatar
  • 1
0 votes
1 answer
55 views

Data servers: Do query optimisers re-write queries removing redundant columns during the plan creation?

Although I'm using SQL Server, as this is a question of whether an optimiser will re-write a query to remove redundant columns, I'm pitching this at all data servers: RDBMS, NoSQL, MPP, anything ...
Steve Martin's user avatar
0 votes
0 answers
179 views

How to add logout button IN SSRS web page?

I have such question. Is it possible to add logout functionality for current user IN SSRS web page in browser?
Robert Margaryan's user avatar
0 votes
2 answers
41 views

Can I regularly log ship from a source to a target, while running DML on the target?

I want to have two databases on separate severs. Let's call the databases Source and Target. Target is the reporting server copy of Source. Except for the changes caused by a stored procedure that I ...
J. Mini's user avatar
  • 507
0 votes
1 answer
83 views

SSRS and Power BI report server on same server?

Can we install Power BI and SSRS on Windows Server 2019 without having issues? Does SQL Server 2019 Enterprise Edition with Software Assurance get Power BI?
dba_rs's user avatar
  • 7
0 votes
0 answers
103 views

SSRS 2016 running slow with blocking

SSRS 2016 - Standard Default Settings. Work Horse for Reporting. Some large reports can run 5 hours+. Most reports cannot be optimized/tuned - 3rd party vendor. On occasion noticed procs "...
jay's user avatar
  • 31
0 votes
1 answer
124 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 ...
rickandm00rty's user avatar
1 vote
0 answers
29 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 ...
Nik's user avatar
  • 11
1 vote
1 answer
1k 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 ...
paulH's user avatar
  • 1,444
0 votes
0 answers
320 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.
solomon's user avatar
-2 votes
3 answers
5k 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 ...
magdi's user avatar
  • 45
-2 votes
3 answers
1k 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 ...
greenglas's user avatar
0 votes
0 answers
34 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, ...
rdbmsNoob's user avatar
  • 459
0 votes
0 answers
472 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 ...
Hamza's user avatar
  • 1
0 votes
2 answers
227 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 ...
Ivan Koshelev's user avatar
0 votes
1 answer
361 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’...
SQL_NoExpert's user avatar
  • 1,061
0 votes
1 answer
502 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.
Ramakrishna.p's user avatar
1 vote
0 answers
86 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 ...
Ali Asad Sahu's user avatar
0 votes
2 answers
86 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 ...
SQL_NoExpert's user avatar
  • 1,061
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 ...
Racer SQL's user avatar
  • 7,396
0 votes
1 answer
47 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'...
whatwhatwhat's user avatar
2 votes
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 ...
Patrick's user avatar
  • 688
1 vote
1 answer
832 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, ...
Raadee's user avatar
  • 425
0 votes
1 answer
743 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 ...
Geo_explorer's user avatar
3 votes
2 answers
3k 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, ...
NateJ's user avatar
  • 804
0 votes
1 answer
37 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 (...
Banananas's user avatar
0 votes
0 answers
34 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 ...
Doublejoe87's user avatar
10 votes
4 answers
20k 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 ...
Bartosz X's user avatar
  • 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 ...
Skiddywinks's user avatar
1 vote
0 answers
118 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 ...
KeetsScrimalittle's user avatar
1 vote
1 answer
2k 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 ...
Arun Ramamurthy's user avatar
0 votes
0 answers
468 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 ...
MeMario's user avatar
  • 33
0 votes
1 answer
114 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 ...
CPickler's user avatar
0 votes
1 answer
460 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 ...
Paul-Sebastian Manole's user avatar
0 votes
1 answer
659 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.) ...
Aleksey Vitsko's user avatar
0 votes
1 answer
96 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 ...
user9516827's user avatar
  • 1,315
2 votes
1 answer
147 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 ...
DBA Greg14's user avatar
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, ...
thisSQLlife's user avatar
0 votes
1 answer
133 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/...
BustaRhymes313's user avatar
2 votes
0 answers
409 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=...
NateJ's user avatar
  • 804
1 vote
1 answer
102 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 ...
Jason Ford's user avatar
1 vote
1 answer
2k 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 ...
ChrisF's user avatar
  • 302
2 votes
1 answer
25k 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 ...
alireza azadi's user avatar
0 votes
1 answer
3k 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 ...
alireza azadi's user avatar
0 votes
1 answer
384 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) ...
SQL_NoExpert's user avatar
  • 1,061
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 ...
tutigan's user avatar
  • 13
1 vote
3 answers
690 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 ...
Learning_DBAdmin's user avatar
0 votes
0 answers
473 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 ...
user9516827's user avatar
  • 1,315
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 ...
BGCDC's user avatar
  • 167
0 votes
1 answer
94 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 ...
user9516827's user avatar
  • 1,315