16

Unless I'm missing some nuance, you will simply set the Row Visibility based on the value. Right click on the detail line and select Row Visiblity... In the window that pops up, select Show or hide based on an expression Within that expression, you'll use logic like =Fields!Total_Allocation.Value = 0 And Fields!Total_Actual_Cost.Value = 0


10

There are two places you can control this visibility. The first is on the row in the tablix; the second is on the row in the Row Groups*. If you change visibility by right-clicking the row in the tablix then on the final report the row will be invisible, but still there. If you change visibility by right-clicking the Row Groups line then on the final ...


10

You actually just put a SUM around the outside: =Sum(IIF(Fields!Role.Value = "Contractor", Fields!actualwork.Value * 100, Fields!actualwork.Value * 77)) It will evaluate that row by row and will provide the correct sum.


8

Why are you running a log backup job on [ReportServerQA5TempDB]? It should be in simple mode. From MSDN: ReportServerTempdb is created with the primary report server database and is used to store temporary data, session information, and cached reports. and Use the simple recovery model to backup the reportservertempdb database. Now the real question ...


6

I found this article: Working with Dates in Reporting Services I can't test right now, but try this: =Format(Cdate(Parameters!Date.Value),"ddMMMyy")


5

You can use expressions for this type of conditional work. To do this click on the image and select the properties tab in BIDS. Find the expression button (fx) and click it. Enter something like the below to get what you want: =Iif(Fields!Gender.Value = "Female", "Female.jpg", "Male.jpg") This is assuming that you have have set up the images to be ...


5

The correct answer would be to say yes - however, a quick win is to close your solution, then open the .rdl file up with notepad and do a find-and-replace. Then save your .rdl file and re-open your solution - you should find all of your references within the report have been updated. Remember that the .rdl file is essentially an xml file, open it up and have ...


4

The page setup in the print options does not control your report parameters. You will need to use the Height/Width property of the report inside BIDS. Orientation in SSRS is controlled by setting these values. We have a report at our office that is similar to what you describe and there are two ways of (semi) achieving what you want to get done. The first ...


4

TL/DR Yes you are correct, you can prove it by showing the result of ExecutionLog in the SSRS database. Longer Answer I created 2 identical reports based on the Adventureworks database, one with a filter on the dataset for City and one with a parameter in the query for City. Report 1 The query for this report is: SELECT Person.Address.* FROM Person....


3

1) How to create a column to input user data and after that I need to perform some operations on data enter by the user which i need to display in another column SSRS is not creating an application, just a report. It is not advisable to use SSRS to collect user input. A limited amount can be done using parameters but this is on a per report basis not ...


3

SSRS has Execution Logs for this. http://msdn.microsoft.com/en-us/library/ms155836%28v=sql.100%29.aspx


3

What's throwing it off is the XML name spaces in the tags. To get around this you need to use the with XMLNameSpaces clause. Give this query a go. I've tested this on a test instance (2008, not 2008 r2), so you may need to change the actual namespace definition to match your xml data. with xmlnamespaces('http://schemas.microsoft.com/sqlserver/2006/03/15/...


3

The GUID identifies the job in the ReportServer database too. So don't change it. That is, the schedule uses uniqueidentifier datatype in the table: the value matches the job


3

That would be really fancy, but I don't think it's possible. You may be able to constrain the width of your bars of the chart and the width of your columns in your table as well as the placement of both to "fake it" though.


3

Best is to use Reporting Services Scripter Reporting Services Scripter is a .NET Windows Forms application that enables the scripting and transfer of groups of SSRS catalog items from one server to another or from one SSRS folder to another on the same server. Reporting Services Scripter is flexible and lets you transfer catalog item properties, such as ...


3

I work with Roger and the issue turned out to be after a little work that the second server was a cloned image that had been OBEd so it was a "different" server from the server SID and identity. However, the install of SQL 2008R2 SSRS was already on the server. The SSRS install creates a unique InstallationID (GUID) and this is used to identify the SSRS ...


2

Set the image URL to be an expression, based on that field.


2

You're probably looking for Report Builder 3.0 and/or Power Pivot. Microsoft SQL Server 2008 R2 Report Builder 3.0 provides an intuitive report authoring environment for business and power users. It supports the full capabilities of SQL Server 2008 R2 Reporting Services. Your Excel ninja users will likely prefer Power Pivot, your more typical tabular ...


2

I think I found a work around for you. Set up a new dataset to pull back the language value (let's say language_dataset into column language_value). Create a parameter, let's say called language. Set it to internal and set its default value -> Get values from a query and use the dataset and value you just set up. In the Report properties, Language -> ...


2

I'm not 100% sure but you might try and query the execution log tables in the SSRS database. It should tell you everything about the execution of the report and the failure of the subscription I would thin.


2

Try casting it to type double, like this: =SUM(CDbl(Fields!YourField_f.Value))


2

One thing that you are missing in your stored procedure declaration is the DYNAMIC RESULT SETS option. The default value for that option is 0, may be that's what confuses the client software. Whether it (the client software) can even handle cursors returned by a stored procedure is another story.


2

The solution to reporting on iSeries SQL stored procedure in SSRS is to install DB2UDB .Net provider that comes with IBM Client Access into BIDS by adding two XML tags to RSReportDesigner.config. Add the following to <Data> tag in .config: <Extension Name="DB2UDB" Type="IBM.Data.DB2.iSeries.iDB2Connection,IBM.Data.DB2.iSeries, Version=12.0.0.0, ...


2

You sometimes see this error when the report is cancelled due to a timeout. You can check the current timeout setting in Report Manager > Site Settings.


2

There is no specific requirement for Enterprise Edition, though Express will not work either, which leaves Standard as your realistic option. See Features Supported by the Editions of SQL Server 2008 R2. Express Edition does have limitations: Allowed data source SQL Server edition is SQL Server Express only. The is no Remote and non-relational data ...


1

iSeries Navigator did not "return" two statements. It echoed them in the messages tab, NOT the data results tab. SYSIBM.SYSDUMMY1 is an IBM supplied table with 1 column and one row. You got the correct answer for the procedure you wrote. SYSDUMMY1 is generally used in example code as a proxy to evaluate expressions that do not require any table. For ...


1

I think you got it half way there with the grouping on student ID. In your report, the group header should include the student ID and name fields, and the detail should include one row per course. You just need to format the layout/grid to make it look like the student ID/name is part of the detail data. Worst case, just add student name to the grouping.


1

I don't know how your report table is currently being designed, but I would think the report table list all the rows from the query results (with predefined number of columns, in your case, 2 columns). As long as the query is correctly developed to return all required rows e.g. all enrolled courses, the report table designing part should be fairly straight ...


Only top voted, non community-wiki answers of a minimum length are eligible