Hi, We are using the ReportViewer control to display SSRS reports in our ASP.NET application. On pages where we use the ReportViewer control the session does not time out. The reason for this is the ReportViewer control emits a "setTimeOut" javascript function which reads the Session timeout value from the web.config and pings the serve...
Hi, I have two parameters using two different datasets. One is where you select a Sales Rep and one is where you select Account Manager to show their sales. I want to show all records that match the Sales Rep or Account Manager that are selected. Some are Sales Rep are also in the Account Manager list. Is there a way to make sure if...
How do you you display the running GROUP count via SSRS 2005? I have a report that has n groups where the source data must remain anonymous and I want that number in the header of the group... So instead of the name in the group header like such... Employee - John Smith Employee - Mary Swain ... Employee - Ahmad Sal I want... Employee...
We have a report requirement that looks like the following: |=============================| |C1 | C2 | C3 | C4 | C5 | |=============================| | There | 0 | a | a | a | | | |----|----|----| | Is | | b | b | b | | | |----|----|----| | a lot | | c | c | c | | if data |----|----|-...
In SQL Server Reporting Services 2005, how can I filter a nested table within a list? I have 2 datasets. The first, datasetHeader, contains one row per account. The second, datasetDetails contains multiple rows per account. Control: Dataset name List: datasetHeader Table: datasetDetails The table is placed within the list. When I att...
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. ...
Is it possible to have SSRS's Report Manager display a report name that is not the .RDL file name? I.E. I have a Report .RDL named "MyReportAboutSomeImportantStuff.RDL" but I want the Report Manager to display this user friendly as "My Report About Some Important Stuff." ...
Hi, I have a problem with a list in srss 2005. The list is grouping too much information and I dont know how to un-group it. I made a picture to show it. But because I'm new, I can only show it with this link: http://img32.imageshack.us/img32/6058/listproblem.gif So the list is also grouping the weeks, but that is not what I would lik...
I have an asynchronous local SSRS 2005 report that is of variable height and width, but routinely is bigger than the screen. I want to render it full size so that some of the report renders off screen and the only scrollbars the user sees are the ones on the browser window. What is the best way to accomplish this? The only method th...
I am finding a lot of useful help here today, and I really appreciate it. This should be the last one for the day: I have a list of the top 10 keywords per site, sorted by visits, by date. The records need to be sorted as follows (excuse the formatting): 2010-05 2010-04 site1.com keyword1 apples wine keyword1 visits ...
Hi, I am having some trouble with my IIS web server & SQL reporting services. At the current time my site is playing host to both reporting services (/reports & /reportserver) as well as my personal website (domain.com) Only just recently have I implemented a Theme on my site and as such I have placed a statement in my web.config file ...
I have a table1 in a table2 and I need table2 to be anchored to the top-right corner of the containing area in table 1. This would be useful since I need to hide parts of table2 depending of an element in table1. I can't find the anchor property. I originaly intented on using subreports, but since the child cannot return data to the par...
Question: I have created a series of reports that allows you to drill down and/or jump to another report. They work perfectly until... I am now setting up these same reports for specific colleges. The original report had a parameter where you could select what college you wanted to see. I am changing that parameter to have a default ...
Hi, I have a fairly basic SQL Server Reporting Services report that is using nested row groups. Each sub-group depends on expanding its parent to be visible which is all pretty standard. The layout is something like this: { Company { { Car SUM(Price) { { { Part Price My desired result when expanded is something li...
I have two reports built using SSRS 2005. The first report is set to navigate to the second when a specific field is clicked. There is a multi-value parameter on the second report. I need to pass multiple values for this parameter in the "Jump to Report" string when calling this report. Is there a way to pass multiple values? I have tr...
I am unsure which is the best way to go here. I have a third party Excel 2003 spreadsheet that needs to be filled in on a monthly basis and emailed. Currently it is a manual process and I am in the process of automating the generation of the spreadsheet. I have been throwing around different ideas of how to get the data into the spre...
Hi, I have an asp.net web app and I need to launch a pdf report that is developed in SSRS using SQL 2005. The SSRS report query has been created. How can I go about launching the report? ...
In a report a have a cell that contains a System.Decimal type value. I am using the cells format property to format the value to "D2". This works in VS but not when I run the report on the report server or in my application. If I switch the format string to "0.00" then it works. The confusing part is that it seems that sometimes it w...