I think I have Sharepoint and Reporting services correctly installed to use windows trusted accounts, (using domain Active Directory logins, but not Kerberos). While writing my report, I designed the data set to use windows authentication (instead of a SQL Server authentication). From ...more >>

Is there a way to make my drop-down checkbox wider? I have a label that is a concatenation of several fields and I'd like the user to be able to see all of the data in a row. Thanks! Stephanie...more >>

All-- Is it possible, from within the context of a main report that contains several subreports, to write code in the main report that refers to field values within one or more of the contained subreports? (I would like to display totals in the main report that are sums of quantities displ...more >>

Given the following dataset: ="Select * " & "From pat " & "WHERE (pattype IN (@pattype)) " & "AND (facility IN (@facility)) " & IIf(Parameters!fromdate.Value <> "","", "AND fromdate = " & CDate(Parameters!fromdate.Value)) & "Order By pattype,facility" I am trying to dynami...more >>

Is there any way to step through a stored procedure so I can see what is happening? I want to be able to step through like I do in VB so I can see what is happening at each line of code (and where its failing!). Thanks in advance. Michael...more >>

Hello Everyone, I'm running SQL Server Reporting Services on SQL2005 SE. The data for the reports is coming from a SQL 2000 EE database. All running on Server 2003. I've been asked to create a report that shows all sales orders that are past thier due date. I'm having some difficulty in comi...more >>

I've created several reports in VS2005 and have deployed them to my RS. I would like each one of these reports to be a seperate worksheet in an Excel workbook. Is it possible to Export multiple reports as seperate worksheets to one Excel workbook?? Thanks -- Chris...more >>

I have written a series of related reports and subreports that all are geared toward a single "order", i.e. WHERE order_id = @order_id (order_id is an integer in the database). Now I've been asked to make the reports workable for a combined group of orders as well, i.e. WHERE order_id IN (???...more >>

In my current project I have to deal with a multi-language reporting scenario. The same report needs to be available in multiple languages. The report object and the text box object have a very promising property called: language. I hoped this would give me the same unctionality like the l...more >>

I have created a Report which a date parameter. I want to have the dutch format (dd/MM/yyyy). So I set the browser to [nl]. The first time I start the browser the datepicker is in english and in the format is in MM/dd/yyyy. The next time I see the dutch names of the days of the week en the for...more >>

I have a matrix report that has rows grouped by year, by period, and columns grouped by sales office. I would like to conditionally format the b/g colour of the data values so that if for example period 1 sales in 2007 were less than period 1 sales in 2006, the b/g would be red. I have don...more >>