ssrs-2008-r2 Questions
3
Solved
There is an option to create "Internal" parameters in SSRS:
In what context are they used?
What are the general rules for using internal parameters?
Beera asked 23/3, 2012 at 18:7
1
Solved
I have a table in ssrs 2008 like:
What my problem is, when I execute the report and export the output to the excel, I see that there is a mess for the excel columns, and somehow some of the colu...
Chefoo asked 31/1, 2017 at 18:58
1
Solved
Ok, so I am familiar with formatting the colors of a cell like this
=IIF(SUM(Fields!Dollars.Value) < 0, "Red", "Black")
but, I have inherited a report that has 80 columns and 4 rows of calcul...
Stclair asked 25/1, 2017 at 0:2
4
Solved
I have a field which is like the following 4444-4444-TestingItem1.
Is it possible for me to extract the field up until 4444-4444.
if so how would I do this? What function would I use within SSRS. ...
Finnell asked 1/12, 2016 at 1:36
2
Solved
I have created SSRS report having 3 columns in it. Now, I have to show "NO DATA FOUND" message below report header. How can I achieve it. I cant not use report property "NO ROW" as I have to show R...
Souza asked 3/3, 2014 at 6:49
1
Solved
Used this site for many years but first time posting a question...
I have a parent report which consists of multiple child sub-reports (all being the same report for testing purposes). The child r...
Avatar asked 26/9, 2016 at 22:52
1
Solved
I have a pie chart that has a calculate Result value in percentage (%). I need to sort the % value from highest to lowest. I found the CategoryGroups->Sort Expression from Chart Properties, but it ...
Easternmost asked 12/8, 2016 at 20:44
1
Solved
I cannot find advanced mode in SSRS 2008 R2. I need to freeze the top row in a tablix so it stays there when scrolling on a report. Apparently I can do this in "advanced mode", but when I click the...
Tramline asked 14/4, 2016 at 15:34
1
I am creating an SSRS report where
In Dataset15, I have value Jan - 100 & Feb - 110
in Dataset16, I have value Jan - 80 & Feb - 100
Now I want to calculate same thing in a line cha...
Skylar asked 21/3, 2016 at 13:6
2
Solved
I'm working on SSRS Report.
Recently I have changed my folder location of all SSRS report to different path. Also I need to change Datasource path. (As I have moved the reports again I need to set...
Cargo asked 13/1, 2016 at 6:1
4
Solved
I want to use Globals!PageNumber in Report body part. How can I access inside Report body?
I am using SQL Server Reporting Service 2008 R2.
Transfer asked 21/1, 2011 at 12:29
1
Solved
I'm trying to optimize a report that uses multiple stored procedures on the same table. Unfortunately, each procedure is reading millions of records and aggregating the results. It's a very intense...
Burnejones asked 17/12, 2015 at 20:23
1
Solved
Good morning.
I am trying to solve an issue that is very similar to the post below, but with 1 extra parameter that is tripping me up.
SQL Server Query, running total in view, reset when column A...
Ciborium asked 23/10, 2015 at 8:48
2
Solved
There is RDL report template for SQL Server Reporting Services.
I need to set value for cell in table in the report template which must be calculated from other values in the report.
When the repor...
Webby asked 23/6, 2015 at 10:28
2
Solved
I am having a date example 4/29/2015 . I need to change the format of date like "Wednesday,april 29,2015. How to achieve this using SSRS.?
Steamer asked 29/4, 2015 at 9:54
3
Solved
Is there a way by which I can trigger a SSRS subscription (Time based) whenever there is an event like file created in a shared folder? Can we do it with powershell or C#?
Is there a out of box f...
Acanthocephalan asked 28/5, 2015 at 9:20
1
Solved
I have noticed with one of my reports (SSRS), when I add weekdayname, that tomorrow's value appears.
I tested this by adding a textbox with =WeekdayName(weekday(Today())) in it. I have just run th...
Alfie asked 2/3, 2015 at 8:59
1
Solved
I created a matrix report. The report looks like this:
I want to sort the output so the region with highest sales should come on top.
e.g. From the above report South should show on top then We...
Kemeny asked 6/2, 2015 at 17:4
3
I am trying to access a SSRS report using URL like below
http://MyServerIP/ReportServer?/FolderName/ReportName&Param1=ParamValue&rs:Command=Render&rs:Format=HTML4.0&rc:Toolbar=fals...
Eudy asked 4/4, 2013 at 16:7
1
Solved
I am having a multivalued parameter 'client',i have almost 60 values in the client parameter,my requirement is display the selected client values in the header text box but when i select 'SELECT AL...
Yemen asked 23/9, 2014 at 14:38
1
Solved
I have a Table Report with 70 columns. My requirement is to freeze the First Column as I scroll horizontally.
I have tried checking row headers in Tablix properties, but still it's not working. H...
Outherod asked 1/5, 2014 at 21:20
1
In an existing 2008R2 report, I have a concern about reports being exported to Excel. I have this concern since the result is related to the visibility of tablixes, columns, and rows based upon the...
Giacomo asked 4/12, 2013 at 17:39
1
On a test server, we have a data source using "Credentials stored securely in the report server" and "Use as Windows credentials when connecting to the data source". The account is a domain account...
Holladay asked 18/10, 2013 at 14:36
5
Solved
Whenever I try to access SSRS 2008 R2 through a URL (i.e. after being published on the net), it always shows a login prompt when accessing the report. The problem does not appear in the development...
Burkey asked 4/8, 2010 at 6:34
1
Solved
I'm having problem with SSRS Report Deployment. I've 2 Hundreds of Reports in my SSRS Report Solution. When, I deploy the Report it deploy all reports which is very time consuming.
Now, what I'm l...
Dish asked 12/7, 2013 at 8:19
© 2022 - 2025 — McMap. All rights reserved.