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? ...
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? ...
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...
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"...
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...
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...
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...
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. ...
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...
In SQL Server Reporting Services, how would I get calculate the last day of the current month? ...
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? ...
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...
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...
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???? ...
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...
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???? ...
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...
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? ...
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...
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. ...
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...