HI all, Currently i am running SP1 of reporting service. I have a simple report with a table and chart bith having the same dataset. Then the dataset returns 0 rows, the export to excel link is giving me the following expception like "Exception of type Microsoft.ReportingServices.ReportRend...more >>

When I attempt to browse ReportService.asmx I get HTML instead of WDSL response. My other webservices are working correctly. What can I do to trouble shoot the installation of SQLReporting? I am not able to view or publish reports. Thanks. Dan ...more >>

This may have already been stated and a better solution may also have been found, but I still wanted to share this either way. This article is in reference to adding the global User!UserID in your report and then not being able to schedule the report. If there is a better solution please let m...more >>

Hi All I have an RS Report with two level drill down : Department Details + Accounting - AR - AP - GL + MIS - Services - Licenses - Cust. Support As soon as I expand Accounting or M...more >>

I have never used the MSSQL Reporting Services. I have a couple of general questions I'm hoping somebody could answer. a) Is it possible to create reports with multiple user selectable/input criteria? Example: All customers with a DOB in the month of July, within a date range of 1900-2000. ...more >>

Is there a config file setting in RS for setting cookieless = true? Cookies are blocking display of images in reports. Thanks. Alan ...more >>

I used the report wizard to create an rdl with page groupings. The report wizard created nested lists for each page grouping. At rendering each new item in the list grouping would be listed on a separate page. My question is, how do I remove the page breaks? I looked at the list propertie...more >>

We have a report spec that needs a field value at the top of every page. The documentation we have says fields can't be placed in Page Headers. Is there a workaround? ...more >>

say I have a report with the following entrys Name address City State Joe 122 main st Albany OR Jim 122 main st Albany OR Steve 123 main st Salem OR Pete 222 water ave Salem OR Jay 122 main st...more >>

Every report I export to Excel ignores the page properties I've set on the report and defaults to a landscape view. This behavior has been reproduced on multiple machines with a simple report containing a single 1" wide textbox. Have verified margins and page/header/body orientation as well ...more >>

Hi everyone We are using a subscription service to send by email reports to our customers. Our clients with GMail and hotmail account complain that the PDF attachment is always (0k) in size or corrupted. Outlook users seem to be ok ! My assumption is the enconding is not set with th...more >>

I change password in machine.config and then use rsconfig.exe to change password of report server database. When I try to launch reportmanager, I got Application Server Unavailable. Can anyone help me on this problem. Thanks a lot....more >>

Is there a built-in way to make the rows in the detail portion of a report to automatically alternate in background color? Thanks, Quick ...more >>

I'm new to matrices so please bear with my lack of terminology. I have two columns, each with a different dollar amount (GWP and GC). The dataset returns data for two years selected by the user, so the layout looks like this (run-time): OBU GWP GC Broker Year1 SUM(GW...more >>

Hi, When they export to Excel, many people have been getting: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index I have finally isolated my occurrences to using the ReportItems collection in a table cell expression like this: ...more >>

Hi, I was able to access the Report Manager through http://localhost/Reports, but today suddenly I cant ! We have installed a SCM software called Axosoft Customer portal.. Do you think this could be causing the trouble? Or there are other reasons due to which this could happen too? T...more >>

Hi All, I'm trying to write an RS report against an OLAP data source. Dimension member names get embedded in column names during the flattening process. Specifically, when returning data from a time dimension, the actual date parts (depending on the dimension structure) are returned in th...more >>

Hi! i'm new with SQL Reporting and . . . wow, great product ! My question is simple, can we pass a ReportItems parameter to a subreport and use it within a expression (inside a IIF() for example) of the sub instead of a SQL query ? If yes, how can we address it ? Thx in advance, L...more >>

I have a set of reports that have multiple paramters with multiple available values. In addition the reports are multi-level and users are grouped in Active Directory to see a level of reports and thier sub reports. OK PROBLEM is in the middle level of permissions I have One parameter value ...more >>

Is any changes on the RDL specification for SQLRS 2005? Thanks Jerry http://www.rdlcomponents.com...more >>

Hi All, I am new to SQL report service. I have a question here: is it possible that SQL RS provides the function such as letting end users be able to design the report format themselves while the developers of report RDL file just setup the data fields to them? I have some customers want to...more >>

I am trying to do a chart with number of apps entered for each month for the year to date. at the moment i am setting the criteria as =datepart("m", today) this month =datepart("m", datediff("m", -1, today) last month =datepart("m", datediff("m", -2, today) 2nd to last month in the filters...more >>