reporting-services

Highlight row in report?

I have a SSRS report which displays hundred of rows. I was wondering if there is anyway i can highlight the rows so that i can easily know on which row i am while accessing the report. Any thoughts? ...

Results published with MSTest not appearing in TFS2010 reports

I'm trying to publish test results to TFS2010 using MSTest's /publish parameters. MSTest says that the publish was successful, and looking at the SQLServer tables, data for the test has been uploaded. However, the test results do no appear in the TFS Build reports. If I use TFS to run MSBuild via the default build template, the results...

Hiding Table Rows

I have a table that I'm using to show details from the line items of a quote. I want to hide a particular row depending on the value of the field in it. The expression I've tried is to set the row visibility to: =IIF(isnothing(First(Fields!NEW_PRICEBREAKS.Value, "QuoteDetail")),true,false) When I run the query from the dataset "Null"...

Reporting Services returning value for null or empty cell

Hi. I recently moved Reports that I created in Studio 2005 for SQL Server 2005 to SQL Server 2008 Reporting Services. In one of my reports cells that should be blank because they have no value display the same value. So instead on blank cells I get cells with the value 119. I don't know where the 119 value is coming from. Has anyone e...

About Reporting Server Permissions

I have an ASP.NET application that runs under Classic .NET AppPool. I'm trying to render a report hosted in Reporting Services in another machine, with the correct address and everything. But I keep getting the following error, which I just can't solve: Cannot create a connection to data source 'MYDATASOURCE'. (rsErrorOpeningConnection...

About SQL Server security

I have an ASP.NET application which runs under the Classic .NET AppPool in IIS. I have a report to render from my website. The problem is SQL Server keeps telling me that it failed to create a connection to the datasource, because login failed for user IUSR. After adding that user directly to the databse I could get the report to work...

[SSRS 2k5] Disable History, Properties and Subscription tabs.

Hello all, I am trying to disable history and properties tabs from my report manager for some users. I've been looking for advice on the internet but did not find anything about this. Has anyone any idea on what configuration elements I have to modify so as to achieve this ? Thanks in advance. ...

Creating a standards based ReportViewer Pivot Alternative

I'm interested in recreating some of the ReportViewer functionality - possibly something via regular GridView or something similar. My two main requirements: Pivot functionality - as seen on the ReportViewer matrix Standards based design - maybe adding ids/classes on the backend based on the results Also - I will be pulling data for...

How do I get the last day on the month using SQL Reporting Services

In SQL Server Reporting Services, how would I get calculate the last day of the current month? ...

Dynamic Grand-total with lists and multi-value parameters

Basically I've created a list that subtotals according to the group. I then created a multi-value parameter that allows the user to choose which group is shown in the report. How can I get the grand total to reflect the parameter since its currently outside of the list? ...

In SQL Server Reporting Services, how do I display the hidden columns when printing or downloading as a file (csv, pdf etc)

Hi, I have a situation where I need to hide columns of the report when viewing but when printing or downloading as a file, those hidden columns need to be displayed. Hiding the columns is not an issue, its just that I cannot figure a way to display the hidden columns when printing/downloading. I do not want to create 2 separate reports...

How do you add a listbox as an input parameter UI element in SSRS 2008?

I have to add a listbox/dropdownlist to a report in a Visual Studio Business Intelligence project, allowing users to filter a DataSet by the Id of the entity chosen in the listbox. I heard this was possible, but there is no option to add a listbox in the Toolbox in Visual Studio, and looking at the Report Definition on microsoft.com, the...

RDL file - Reporting Services showing HTML in design view

for some reason the RDL file RDL file - Reporting Services showing HTML in design view in Visual studio any clues as to why only thing i can think of it is that it makes use of Dundas Charts and i dont have that installed. Will i need that???? ...

SSRS & asp.net - passing parameters from .net to ssrs in report viewer

Hello all. I am about to embark in using a report viewer in my .net page. I have a page that will search for a catgory, upon a button click, the category chosen will pass into the parameter of report viewer. Now, given that I am a newbie to both SSRS and .net, I'd just like a bit of advice on how to tackle this. Should I make the repo...

How to do paging in master-detail report(SSRS)?

I want the paging of master-detail report (SSRS) in detail table, i have joined two tables for datasource. I have given the expression in table group like this '=Int((RowNumber("list1_Details_Group")-1)/12)' but it breaks the page after every list instead of rows???? ...

Is there a generic open-source reporting system out there?

I recently started a position at a new company, and one of the first projects they want is an internal reporting system that points at database A, B, C and reports various metrics/statistics/predictions. Basically, the same thing I've done or worked on and every company I've ever been hired by. Since this gets a bit boring after a while...

reporting services 2005 instance

Greetings, I have Reporting Services Installed on my computer. It was installed previously by other developer. However I cannot access reporting services instance on my localhost. When I open Reporting Services Configuration the error returned is: no report servers were found on the specified machine How can I add/restore this instance? ...

SSRS and cached reports

Hi, I'm opening an SSRS2008 report using the http://server/reportserver/... syntax, outputting directly a PDF copy. This report has several parameters. The problem is that, despite making changes to the report, and clearing the browser's temporary files cache.. if I request the same report (i.e. same parameters) - the old report is re...

how to drilldown for some part of data in ssrs reports 2008

Hi I have to put drill down option for some part of Data. My requirement is..I have 50 suppliers and i have to show top 10 suppliers as normal and for remaining 40 suppliers i have to put drill down option in ssrs report 2008 Please help. ...

Reporting services and custom library

Greetings, In my Reporting Services report I've added reference to my custom library. It works fine. I can display the string which is returned from my custom library method as follows: =ClassLibrary1.MyClass.Parse("harry potter") Above code works fine - it should return SQL query based on passed parameters. My question is, how can I...