Questions tagged [ssrs-2008-r2]
Microsoft SQL Server 2008 R2 Reporting Services provides a server-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed.
ssrs-2008-r2
2,314
questions
0
votes
1
answer
18
views
How do I add an additional value to a SLECT DISTINCT
I have a parameter in SSRS that uses a query to retrieve a list of values.
SELECT DISTINCT LTRIM(RTRIM(user_def_fld_5)) AS user_def_fld_5
FROM imitmidx_sql AS IMITMIDX
What I need to do is ...
0
votes
0
answers
13
views
Is there a way to Protect/Lock a range of cells from being edited in an Excel report that was exported from Report Builder 3.0 (v15.0.19914.0)?
Basically, working on a project automating a scorecard in SQL Report Builder, and the end-user has a requirement to lock a certain section of the scorecard once it is exported to Excel. Can that be ...
0
votes
1
answer
91
views
SSRS Report services, title - based on the selection from the parameters
I am tryin got do a title based on what the user select from the parameter -
Example - if user selected-
Purchasing - then title filed should say Purchasing and MFG schedule
Purchasing Review then - ...
0
votes
0
answers
50
views
SSRS Report Server Data Source Hidden
How can be have the shared Data Source folder visible to all on Report Server 2014 which is hidden by particular user?
Thank You,
Dhara
I tried to check clicking Deatiled View on Report Server and ...
0
votes
0
answers
39
views
How to add row group to a specific column in matrix ssrs?
Hello i have a case on ssrs, that i have to add a row group but only on specific column on the matrix,
Currently i have a row group based on column: emp_name & sku_kpi
And i have a column group ...
0
votes
1
answer
60
views
SSRS - Rows are repeating in table
I am creating a report in SSRS and i am having an issue that the table is repeating. In the table 6 records should be presented but insted are shown 12.
Repeating rows on the left and only one row on ...
0
votes
1
answer
49
views
Aligning Two Matrix Tables in SSRS Based on Matching Column Names
I have two matrix tables in SQL Server Reporting Services (SSRS) with identical column names. I want to align these tables one above the other in such a way that the columns match up perfectly. Is ...
0
votes
0
answers
14
views
an expression of non boolean type specified in a context where a condition is expected near in report query
how would i resolve that error. I am sending in multiple values at 1 time which is causing the error. Individual items not cause the error. When i hit select all that is when the error comes in in ...
0
votes
0
answers
36
views
Unable to call a custom dll method in Microsoft SSRS
as soon as I try to call a function from a simple custom DLL in SSRS, I receive an error message that requires me to load .NET DLLs such as system.runtime.dll and system.private.corelib.dll .
I ...
0
votes
1
answer
13
views
SSRS 2008 r2 - How do I repeat a sub-report for each row of data returned in the results set?
I have a main report with multiple sub reports. The 2nd and 3rd sub-report are inside a List item.
The 2nd and 3rd sub reports are forms like this:
When I run the report I am getting a single table ...
0
votes
0
answers
18
views
SSRS puts # in front of field name and scrambles the report columns
I use sql server data tools for visual studio 2013 which has SSRS in it. (please don't laugh)
This query, which I am using for my report, works just fine in Sql Server Management Studio:
select U....
0
votes
0
answers
20
views
Dynamic Header Fields Based on SSRS Grouping in Body
I have an SSRS report where, in the background code, I set various fields to a hashtable, and reference them in the header. I run this code in the first row of the grouping, JobNum, shown below.
...
0
votes
0
answers
56
views
SSRS Subtotals in Filtered Matrix
OUTPUT OF CURRENT REPORT
I have attached an image of my rdlc.The arrows point to the row and column groups I will reference.
There is a field which outputs either a 1 or a 0 based on whether it is a &...
0
votes
1
answer
65
views
In RDLC report's IIF condition's else block always executed and throwing the exception
I am trying to execute the below expression in RDLC report against the column MyColumn,
=IIF(IsNothing(Fields!Incident_Custom_Column_152.Value)=True,
"Nothing",
Fields!...
-1
votes
1
answer
113
views
SQL Server stored procedure causes Visual Studio to hang when added as part of a dataset
I've got a T-SQL stored procedure, which for a given set of parameters returns 34 rows and takes less then a fraction of a second to run.
The SQL has a while loop, a bunch of nested if statements a ...