Reports

Choose the delimiter used in a multi-select dropdown
Anyone know if this is possible? I'm passing a field that is fname,lname. If the field doesn't have a comma, then I use a split function in the stored proc to split out values using Where Field In (SELECT Data FROM dbo.Split(@pl_variable,','). However, you can see the problem if the values in the field also c... 12 Jun 2008 13:22

Number of rows in the Excel sheet exceeded the limit of 65536 rows
Can someone please reply to this as it would be helpful to know and would impact our decision to implement 2007. How does something get escalated to MSFT? Thanks, Keith "Bob" wrote: When exporting to Excel, I get the following error Excel Rendering Extension : Number of rows in the Excel sheet e... 10 Jun 2008 16:39

Hiding Cells
Is there a way to hide a cell in a Metrix control (RS2005)? I am using a union of multiple datasets and based on that datset I want to hide a cell (textbox). I have tried defining an express in the Visible property of the textbox but it hides the entire line, not just the one occurrance. Thanks ... 10 Jun 2008 12:32

Subreport Embedded in table
Hi, this may be a typical newbie question, so sorry in advance. I have a table which calls a subreport. I pass the parameters from the table row to the sub report E.g. Customer list in table rows, sub report has a parameter of customer ID and start & end date passed through from the main report. The sub report... 12 Jun 2008 04:09

Side-By-Side Reporting Services 2005
I have a SQL Server 2000 NOT USING RS2000. I installed SQL Server 2005 Database Services and Reporting Services side-by-side with my SLQ200 installation. My SQL2005 is a named instance. I selected the configure manually at the Reporting Services setup. Everything went smoothly. When I go and try to configure RS,... 11 Jun 2008 23:04

upgrading to IIS 6.0
Hello: I want to practice with Report Builder, but I do not have IIS 6.0--just 5.51. How can I upgrade? childofthe1980s ... 11 Jun 2008 10:46

Deep Integration Sharepoint (MOSS) SSRS - timeout issue
When I try running a specific report with a specific set of criteria, I get the [HttpException (0x80004005): Request timed out.] error and the report fails. Running the same report and same criteria even database connection in Native mode works albeit taking 3min 35 seconds to find 3 records I have tri... 13 Jun 2008 05:40

Average calculation for Matrix reports
I am developing a matrix report which requires to calculate the average of the dynamically increasing columns after the subtotals in row wise (subtotals/number of dynamically increased columns). There is 1 column grouping and 4 row groupings. Can anyone guide me on how to achieve this.. Any suggestion would ... 10 Jun 2008 07:24

Access to subtotal value
Hi, I need to access to the subtotal value in a tabla matrix to add a % column that is: Name Value % asdasd 10 SubTotal / 10 asdasd 15 SubTotal / 10 Total 25 SubTotal / SubTotal I set the subtotal for solumn "Name", but, how can i access to th... 10 Jun 2008 03:46

SRS vs. Crystal
Hello: Is there a URL or something that someone could post here that discusses specifics, as to why SRS is better than Crystal? Thanks! childofthe1980s ... 9 Jun 2008 21:40