Anyone know if this is possible? On WinXP, you can access a WSS or SPS 2.0 site and documents libraries by typing in an UNC path: Web access is http://wss-dev/mydocs You can also use \\wssdev\mydocs to access via Windows Explorer I heard only WinXP and later OSes can do this. Does...more >>

Curious if someone has tried to do a weekly group in a matrix report? If so, would you please assist me by showing how you were able to group weeks (7 days)? I've successfully grouped on Year and Month, but my sticking point is Week 1, Week 2, Week 3, etc.... for year 2005 and april (as an exa...more >>

I am trying to set an alternate shading style for each set of grouped detail rows that I have. I can easily set each row to an alternating shade by creating an expression on the Background color. What I really need is to shade a grouping of rows in alternate style. I tried to create a custo...more >>

Is there a data processing extension for use with an ADO.NET provider? MSDN lists ones for SQL Server, OLEDB, Oracle, and ODBC.. ADO.NET is a glaring omission. The extension interfaces (IDbConnection, etc) are all similar to ADO.NET's. I could write a pretty thin custom extension wrapper ...more >>

The online help states under ther Report Server Execution Log the following description for the Retrieve, Process, Render counters: "Percentage of time spent retrieving the data, processing the report, and rendering the report." Shouldn't the three numbers added together match to 100%? W...more >>

Using SQL Reporting Services with the reporting services databases and web server on the same machine, I have a report that accesses data from a SQL Server that is not the report server. The data source for this report uses NT Integrated Authentication. If I access this report from my workst...more >>

Hello, I just installed SP2, can I freeze header at the top in this version? Thanks, Jim. ...more >>

Does reporting services currently allow me to write my own particular chart that will appear inline int he report as the stock reports do? reports and reports, but I would like to have some specific views that arent in the chart selection. Thanks in advance Weston Weems ...more >>

Hi All, I am creating a report which calls for four input parameters A, B, C, and D. How can I disable D if A, B, and C are selected or disable C if A, B, and D are selected? Thx, Chuck ...more >>

Opening the report in preview is very slow, as if the main query is running without the parameters. Is there a setting to make sure a dataset is not queried until after the report view button is clicked?...more >>

I have a table with US dollar amounts. The user wants to see these amounts by default, but would like the ability to view their original currency amounts. If the original currency amount = the US dollar amount, I don't want the user to be able to make that row viewable. How can I prevent them ...more >>

We are in the process of changing the from one domain to another (upgrade to Active Directory). In the Users table there is a listing of all the users on the old domain. Can I simply update the UserName value of that table to the new Domain - rather than editing/saving all the subscription...more >>

I'd like to make an snapshot of a report programmatically( preferably an class which dose this) and return a referecne to its URL? Thanks ...more >>

When trying to print a report using the ActiveX control in Internet Explorer I get the following error: An error occured during printing. (ox80070006) After some experimenting I found I was able to print (same client computer / same server) to a file using the Generic / Text Only printer dr...more >>

We're running SP2 on our Reporting Services. Does it mean that all SP1 issues are included in SP2? If not, how can I install SP1 fixes over SP2? Thanks Alex...more >>

Hi, I have seen in a beta version of Yukon there exists a separate Report Designer (without using Visual Studio .NET 2003). So my question is: - Is this Report Designer going to be shipped with SQL Server 2005? - If yes, is the Report Designer available in all SQL Server 2005 Editions (or...more >>

Hi All: I have created a report that is based on stored procedure and also has some parameters. Manually after entering proper parameter values, I can run the report properly. My questions are: 1. How can I schedule this report? 2. While scheduling this report, is there anyway I can ...more >>

Hello, In my reports, I have some cells which will contain some HTML code like <div>. This codes are with the data in the database. How can we tell RS to remove this code ? Can we specify that one cell need to be in HTML format ? Thx Gael...more >>

Hi, I have a feeling what I want to do is not possible. I have a reportserver (everything works fine) and I have an asp.net app which allows users to run some reports. I dont use the reportviewer control, I just opent the report in a new IE window by using url access e.g. http://reportser...more >>

Hello, I have a report with 35 columns, meant as a datafeed. The report uses a view on the (separate) SQL server so it only needs to put the values in the table. When ik run the report for medium datasets, everything works fine. However when I run it for more then 20,000 rows the exel-shee...more >>

Hi all Is there any way to include two different styles (bar & lines) i one chart? I know it might sound too "excel" but I really hope there is workaround.. By the way, we can't add totals or subtotal into a bar chart, can' we? are these ideas too crazy or we encounter software limitatio...more >>

We ship an application for use in hotels. Some are big and will us SQL Server 2005, some aren't so big and will use SQL Server Express For the bigger sites it is fine for the users to select reports fro the server But for all sites we would like to present a list of reports an descriptions fr...more >>

I created report using Reporting Services. Usin "SetDataSourceContents" web service I was able to give connectio string at run time. How can I pass SQL Query to my report at run tim using Reporting Service Web Services? I don't want to use parameters ...more >>

Hi we are currently using a schema referring to http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservice for System.Web.Services.Protocol.SoapDocumentMethodAtrribute an referring to http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices/creat for Subs...more >>

Our current VS2003 installed on 2000 Sever sp4 and Reporting Service will not longer interface. When trying to open a report project we recieve the error "Th application for Project XXX.rptproj is not installed" "Make sure th application for project type (.rptproj) is installed". Has anyone e...more >>

H I need to have a report parameter that Allows the user to select o Company name but that has a default value as ALL (i.e. will retur data for ALL companys How can I do this Thanks Darra ...more >>

Is there a way in a report to ensure Columns headers stay in place when scrolling through data? ...more >>

After reading the other post on styletemplates.xml tags, I have been attempting to create my own template (for the wizard). XML is fairly new to me, so I'm trying to learn as I go, but I cannot seem to create a footer. All I've really been able to accomplish is changing the way the textbox ...more >>

Is it possible to parametrise the 'order by' options of a table/group so that a single report could be ordered by users on run time depending of their needs? The alternative is to write/copy the same report once and again and have it repeated (one instance) for each orderable column. Reg...more >>