ssrs-2012 Questions
15
I understand that there is definitely something wrong with my report (e.g. columns missmatcch) and I need to correct it but what I see is the WCF error message that hides actual problem and exactly...
Hardunn asked 23/4, 2014 at 8:50
9
Solved
I want to get a copy of all .rdl files in one server.
I can do the download manually one report at the time, but this is time consuming especially that this server has around 1500 reports.
Is ther...
Novosibirsk asked 17/10, 2017 at 5:34
17
I have a two-page SSRS report. When I exported it to PDF it was taking 4 pages due to its width, where the 2nd and 4th pages were displaying one of my fields from the table. I tried to set the layo...
Failing asked 12/12, 2008 at 14:27
13
Solved
What I want to do is log into report server manager. I have added the user to a job role in SSMS and have equally assigned the user to a specific role in Report Manager (2016). Through a secure hos...
Anagrammatize asked 6/10, 2016 at 8:38
10
Solved
I created some reports in Visual Studio 2015 with all the latest updates. However, when I try to deploy the reports I get this message:
The definition of this report is not valid or supported by...
Maitland asked 11/8, 2016 at 16:48
7
Solved
I have created a ReportProject with Visual Studio data tools 2015. When I create a report.rdl file using the report wizard, the rdl file has schema for 2016. My reporting server is of version 12.0....
Wreckful asked 28/3, 2016 at 22:48
1
I'm running the Powershell commands below from my desktop to deploy the SSRS reports to the on a dev report server. I get the error below:
Commands:
Write-RsFolderContent -ReportServerUri http:/...
Undressed asked 9/7, 2018 at 15:47
3
Is there a way to add in custom http response headers to the response from SSRS?
Something similar to adding the following to an IIS web.config file? I tried adding it in C:\Program Files\Microso...
Wilmer asked 16/5, 2017 at 17:30
3
I have been tasked to look into ways to automate the deployment process for our SSRS 2012 reports. Are there any good tools out there? I'm thinking of something along the lines of press a button an...
Overdraw asked 2/6, 2014 at 19:54
9
Solved
I've one main report with 5 sub reports.
Sub report contains more than 10 parameters. (With 10 Multi valued parameters - So I've used Join method to pass value from Main report to Sub Report)
I'...
Meatman asked 28/10, 2015 at 7:24
3
Is there any chance to do vertical merge of fields in tablix?
I am working few years on SSRS, but only saw horizontal merge of cells, vertical not.
Sparrow asked 26/7, 2013 at 12:0
2
Solved
I have a Visual Studio Project with some reports I created. Each report has its own DataSource, with a defined user and password and a embedded connection, and I use this expression for the string ...
Giraud asked 16/10, 2018 at 14:9
4
Solved
Question
I am attempting to download an SSRS report via its URL into a data buffer (byte array), so therefore I can then save it in a particular folder, with a name of my choosing. I am open to su...
Electret asked 31/10, 2016 at 8:44
4
Solved
For the following Query
SELECT *
FROM (VALUES ('England','London',9787426),
('England','Manchester',2553379),
('Scotland','Edinburgh',452194),
('Scotland','Glasgow',1168270),
('Wales','Cardiff...
Pagan asked 6/6, 2014 at 23:1
2
Solved
I have tabbed my report in SSRS 2012 by having my page breaks based upon grouping classname and it works great. How do I change the tab names when exporting to Excel? I tried having an expression f...
Hemicrania asked 14/7, 2014 at 20:37
3
I installed the SSRS 2012 and tried visit
http://mybox.org/Reports, but get an error saying:
User 'mybox\xxx' does not have required permissions. Verify that
sufficient permissions have been g...
Chobot asked 8/4, 2013 at 3:3
1
Solved
I have many SSRS reports, and all are having same issue while exporting data into CSV files. (Upgraded from VS-2005 to VS-2013)
I have some GROUP data on header while displaying the data based on ...
Kemppe asked 15/3, 2019 at 5:47
1
Solved
Multiple - Backup.rdl files are being created in the project folder which is giving me a huge headache with Source Control with SSDT in VS 2017. Has anyone figured out how to stop these being creat...
Lentissimo asked 12/8, 2018 at 0:56
3
Is it possible to replace 0 with blank in ssrs matrix. The expression
=IIF(IsNothing(Count(Fields!referralNo.Value)),0,Count(Fields!referralNo.Value))
is same as
=Count(Fields!referralNo.Value).
W...
Kenney asked 2/3, 2017 at 17:23
2
Solved
MY database have values like
3302540.8200
748712.9600
584879.2400
20787.5300
1338075.0000
I need the above values like below in my SSRS reports
3,302,540.82
748,712.96
584,879.24
20,787.53
1,338,0...
Sucrose asked 29/9, 2016 at 10:34
3
Solved
I struggled with this issue for too long before finally tracking down how to avoid/fix it. It seems like something that should be on StackOverflow for the benefit of others.
I had an SSRS report w...
Winna asked 29/1, 2014 at 12:14
2
Solved
Part of my query is like so:
SELECT * FROM TableA
WHERE ColumnA >= DATEADD(DAY, - 30, GETDATE())
With the expression at the where clause above, you can pull a rolling 30 days data without h...
Dragnet asked 11/5, 2015 at 9:24
1
Solved
To start with, I am completely new to SSRS reporting. Please excuse me if I miss any basic details here.
I am trying to create a reporting service.
Accidently, I have selected an existing Report Se...
Lowis asked 13/7, 2017 at 6:22
1
Solved
This has been a major headache for the last couple of weeks. I have a largish table (165 columns x 11000+ rows). In this table, there are several comment columns that are set to varchar(max). There...
Crevice asked 28/6, 2017 at 14:8
2
Solved
I have a report that is has a multiple value parameter. It has available values (1, 2, 3, 4, 5, and blank). The blank value isn't NULL it is just an empty cell.
For testing purposes, there should...
Booking asked 20/10, 2015 at 16:32
1 Next >
© 2022 - 2024 — McMap. All rights reserved.