Reports

Totals location changes per number of datarows
I have a subreport that can have anywhere from 1-8 rows (the datasource ensures that it's never more than 8). The report prints onto a pre-printed form, with totals at the bottom having to line up with the location of the totals box. However, the totals are moving down according to how many rows of data there... 9 Jul 2008 18:53

Report Viewer -ONLY works once in a while
I have an asp.net 2.0 application using the report viewer control. I am NOT using windows authentication. In my web.config file, I have a userName and Password for an activeDirectory user that has accces to our reporting services server (actually, I am using my own username and password for testing right now ... 10 Jul 2008 12:23

Graph report
I have two separate reports. I need to combine these into one but only want to show the result as a graph. Any help is greatly appreciated. Here is the SQL query. Thanks REPORT 1 QUERY SELECT COUNT(CITY) AS MEMBERCITY, CITY FROM MR_MEMBER_1 GROUP BY CITY ORDER BY COUNT(CITY) DESC REP... 9 Jul 2008 16:49

Creating a report when data exists on two levels of a data hierarchy
I have a report that I need to create where data exists on a transactional level e.g., timesheet entries against a cost category/ project, and also on a cost category level e.g., budget entries against a project. To be clear, the hierarchy for the data (starting at the bottom) is emplyoee - cost category - project.... 14 Jul 2008 13:42

Dynamic Date Parameters
For a SSRS 2005 report is it possible to have a parameter which has text values of "last month", last two months" and "last year". Is it possible to have date range values for the ranges such as equivalent code for Date - 1 Month, 2 Months which are passed to the dataset? ... 24 Jul 2008 09:48

How to default report language
For SSRS 2005 how can you set the default language for reports so that it is used for new reports? ... 10 Jul 2008 14:28

Report deployment issue from .Net
For a SSRS 2005 report that is using SQL authentication which works correctly. However when called from another web server as a .Net component shows the following error message after prompted to login, which I do with an admin account. The permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are insufficie... 9 Jul 2008 13:43

Shared schedule causes "cannot connect to the report server databa
We have 10 reports with data driven subscriptions which run each day on a shared schedule (to create cached reports). Each report query (all stored procedures) will run several times during this schedule for various parameter combinations, a total of 78 queries. We have experienced problems where this job takes ... 9 Jul 2008 13:43

Using RowNumber to count Table Footers, not to include the Details
Hi there, I have a table that has hidden details and only displays the footer row of the grouping of data and I want to provide row numbers for each footer row to indicate a "Priority" on the report. I used RowNumber, but it's also counting the details, so I'm getting something like this: Priority Group ... 9 Jul 2008 10:37

An existing connection was forcibly closed by the remote host
My environment is different from yours, but I am having this EXACT problem. If a solution turns up I will definitely share what I find. "Mark" wrote: bump... "Mark" wrote: Hi. I have 2x SQl Servers - 1x Development and 1x Production. I have a working SQLRS already deployed to... 7 Aug 2008 11:25