Reports

Differential backup
Hi All Quick question regarding differential backup. I plan to setup a solution with a monthly cycle, full backup ever first in the month and differential for the rest of the month. The data in the databases do not change that much, but i will of course have to monitor if the diff gets larger than the full b... 12 Jan 2010 08:15

Percentage Calculations Issue
Hi, Using Reporting Services 2008 I have a matrix for which i have inserted a calculated field. Because there are 0 values in some of the fields, i had to use an IIF expression to ensure no "Divide by Zero" or "infinity results in the calculation". The expression looks like this: Field A = text Field B = text ... 8 Jan 2010 08:18

Sending Report with Dynamic Report Name
We are trying to do the same thing - did you figure out how to add the date to a report name? Any help would be appreciated. andy wrote: Sending Report with Dynamic Report Name 04-Feb-09 I want to somehow manipulate the @ReportName (I only see this on the subject line in the subscriptions window) parame... 7 Jan 2010 19:14

Still column space after making row group hidden
In a SSRS 2008 report I have a number of parent level row groups which the previous group set the hidden value of the child group. I have the canshrink set to True of the cells however this still leaves a blank space where the group data was. Is it possible to remove this blank space from the report when that ro... 7 Jan 2010 12:26

65000 Row Limitation from Access to Excel
This question has been asked a couple times, but the answer seems to be unclear so I will ask again. I have query results in Access that I would like to work with in Excel - I like Excel pivot tables better than Access pivot tables. If I highlight the 287K line Access table, right click on copy, then paste into t... 6 Jan 2010 09:52

SQL ID last login report
Is it possible to run a script in SQL 2000 and 2005 to generate a report with the SQL IDs and the last time they were accessed? We need this information for an audit so we can determine which accounts can be disabled. ... 6 Jan 2010 09:52

Can we use ReportServerCredentials without passing domain name
Hi, I am using ReportingService2005 web service through my asp.net application. It is running fine at my machine but when using this web service through remote server it is giving error "An error has occurred during report processing. The data source 'Live_DB_VAR' cannot be found. ". However, I am passing cred... 6 Jan 2010 14:19

error message is sql reporting service 2005
I am new to sql reporting service 2005. I am getting an error message saying the 'command text' property is not 'initialized'. Being a .net programmer, I know the comand text is the sql in text format or a stored procedure is not being accessed. This error occurs after I have setup a report manually and ... 9 Jan 2010 23:59

The report server installation is not initialized
I installed scale-out deployment of SQL Server Reporting Services 2005. Getting this error when i browse to the Reports website http://localhost/Reports/Pages/Folder.aspx The report server installation is not initialized. (rsReportServerNotActivated) (rsRPCError) In the Report Server Status window, under Insta... 23 Dec 2009 15:11

changes to stored procedure not showing up in report builder??
I've had two occurrences of this happening. This last time I realized I forgot a field in my stored procedure so I went and added it into the proc. When I got back to the report builder and execute the proc from the Data tab my new field shows up When I go the the Layout tab it doesn't see my new field. I t... 14 Jan 2010 11:19