Reports

Row Count in a matrix (countrows () )
I have a matrix created in Microsoft 2003 Reporting Services and need to use the countrows () function. In this matric I have a value for products which are listed but I need a count of the products (to count the number of rows in the matrix.) I use countrows () in my tables but I have never used this in a matri... 9 Jun 2008 16:33

Publishing SQL DB to intranet
I am totally in the dark as to how i go about web-enabling my SQL 2005 DB for use on the internal intranet. No concerns about being reachable from outside. Unless I am framing my searches entirely wrong, I have been unable to turn up straight forward guides on how to do this. Any direction and help would be... 9 Jun 2008 16:02

Setup reporting services to work with SCOM 2007
Hello, I get the following error when I run the prequiste for SCOM 2007: Please install Microsoft SQL Server 2005 Reporting Services ServicePack 1. Please use the provided link for more information: http://go.microsoft.com/fwlink/?LinkId=66955 I am running sql service pack 2! Thanks, Robert ... 9 Jun 2008 15:00

Prompt for person's name
I would like to start my report by having a prompt for the person's last name and then show a list of the names where one could be choosen. I am not sure if this will be through Report Parameters or not. Any suggestions are greatly appreciated. Thank you ... 9 Jun 2008 13:59

Referencing a group in SRS
I have a SRS report that has a table where I have created a group. In one of the columns in that table I want to use an expression to reference that group. How do I do this? ... 9 Jun 2008 12:57

Vista Install
Been battling getting SSRS going on Vista Business SP1 running SQL 2005 SP2 Express Ed. I have installed Reporting Services a couple of times now and I get to the same point... I open http://localhost/reports and I get a blank SQL Server Reporting Services Home Page with Home and Help links in the top right. ... 9 Jun 2008 12:57

Is it possible to attached TimeStamp under File Name when I create Subscription for Report Server File Share?
Hi, I'm trying to create Subscription delivered by "Report Server File Share". I need to attach the TimeStamp into File Name instead of just increment file names as newer versions are added. Is it possible? then How? Thanks ... 9 Jun 2008 11:24

Sum Distinct Rollup
I am trying to figure out how to sum up distinct values in a rollup report. In the data below, when I roll up to District level, the current report sums the inv/research colums. What it needs to do is something like sum(select distinct facilityname ). So the output for the ME/NH/MA would be something like Distr... 9 Jun 2008 10:23

Show Table Style for Style Template
Hello I have created a new style template for use with the Wizard, by editing the StyleTemplate.xml. It works fine, but when I get to the [Report Wizard] --> [Choose The Style Table] screen I have no image displayed for my template, as there is for the other templates, like Slate, Forest etc.. Can I add ... 9 Jun 2008 04:40

rs:Format=PDF not working, instead showing directory listing
Hi, recently i installed SSRS on server and deployed one application which opens reports directly in PDF format. On my old serv rsLFormat=PDF was working perfectly but on this server it shows directory listing insead of oepning report in PDF format. Does anybody has any idea about this? ... 9 Jun 2008 03:39