Reports

Data to display on screen only
I would like to show data on screen but not print it. Is this possible? If so, can you provide a sample? Thanks in advance. For example a text box that has a hyperlink to a webpage, but I do not want to include the text box in my printed report. ... 13 Jun 2008 14:52

How did you find the related job/steps
I have a similar problem. The no-rows option will help - the user base will know we acknowledge an error - but how do you find the related job in Management Studio? ... 13 Jun 2008 14:52

Subscription problem: Is there a max e-mail address size?
I created a subscription with an e-mail address that had 35 characters before the @ sign and then 19 afterwards for a total of 64 characters. It was a distribution list. The subscription will not arrive at its destination unless I change the length of that e-mail address. I have confirmed that its not some ... 13 Jun 2008 13:51

getting value of column header in matrix
could someone kindly post the syntax that will return the value of the current header value for a matrix? I want to pull this information into the row cells to determine background color. i assume it would be something like column.header.value...?? thanks ... 18 Jun 2008 23:06

Report Builder: Views and Named Query's
Hi, I've read that normally I should be able to use views and named query's in SQL Server 2005 Report Builder. The problem is: when I build the model, I don't see any Views in my database, and I don't have a clue how to add named query's. When searching for it on google I found quit a lot of times that I sh... 19 Jun 2008 17:50

RS 2005 and MOSS 2007
I want to show some reports in RS 2005 inside MOSS 2007, but I don't want integrated them in SharePoint. Is it possible using the Report viewer web part for SPPS 2003 in MOSS 2007? Thanks ... 17 Jun 2008 18:48

Displaying rank for a grouping
I have a report that groups transactions on the customer level and then the customers according to some dollar value associated with each customer. I would like to include a ranking for each customer based on that dollar value, i.e. the highest dollar value customer will be 1 and so on. I was thinking it might be p... 19 Jun 2008 16:48

Two Datasets, one matrix
Good Afternoon, I need some help with a seemingly simple report. I have brought in two dataset into my report that has a matrix. the matrix with only one dataset works great. the matrix works when the second dataset is added, but it does not group. A B C ie: C... 12 Jun 2008 15:55

SSIS call to SSRS
Does anyone know how to call an SSRS report inside SSIS? I simply want to automaticlly generate a report at the end of a package. ... 12 Jun 2008 15:55

Failed Subscriptions
I already use the ExecutionLog table to generate reports that illustrate who has run which reports and when but I would really like to build an exception report that shows who's subscriptions have failed. In our configuration, subscriptions run under the NT Authority\System account. So, I can query the Execut... 13 Jun 2008 13:20