Thanks in advance and Im new to RS. I have a simple dataset of date records which can span 1 or more weeks up to a month, I want to break the list up every time a Wed is encountered as this is the end of a reporting week and some totals need to be printed at bottom of the list. I have be...more >>

Has anyone figured out whether RS will work in this configuration? I have gone through all system requirements and ordered SQL Server 2000 Reporting Services for Developer Edition only, from Microsoft. I still get the error message "The edition of the report server database is not supported on...more >>

I am trying to create a matrix report that has several "subtotals". One subtotal presents the SUM. Another the AVG. And another the variance to the prior year. As below: Jan Feb Mar Total Avg Variance Prod1 10 20 15 45 15 -8 Prod2 25...more >>

When using a matrix in Reporting Services to design a report based on a cube, you are presented with a detail column for your measure and a column to the left of that for the description of the measure. My report has several rows of measures that present (for example) both units and dollar...more >>

Hi, We are using Data Driven Subscription to deliver Excel files using SMTP. Everything works fine on our Intranet. However we have problems to put in in Production for some customer sites. We have several VERY STRANGE behavior: 1. the Excel file when read on the customer PC is "nearl...more >>

Hello, After installing SP1, a report failed during export to PDF with the following error from IE: "Internet Explorer cannot download Format=PDF from myserver." "Internet Explorer was not able to open this Internet site. The requested site is either unavailable or canot be found. Please tr...more >>

Are there any tricks to speed up the rendering of a report that is based on a OLAP-cube? When I query my OLAP cube with the MDX Sample Application, it takes about 1 minute to return the results. But when I run the same query through Reporting Services, it uses 4-5 minutes. My report shows w...more >>

Is it possible to add columns to the right-hand side of a matrix? Does anyone have an example of joining a matrix and a table? Our report designs are never as simple as the AdventureWorks examples. Currently, we use Actuate, which allows for practically unlimited possibilities for report layou...more >>

We're using RS Forms Authentication as per the MSDN article. When I try to access our RS site from outside our Intranet, through a Netscreen VPN, I'm getting the sign-on screen ok, then the list of reports from the ReportServer directory ok. But when I want to pull up a report, I only get th...more >>

I have calculated a number of fields with the following method: =SUM(Fields!Asian.Value) / SUM(Fields!Asian.Value + Fields!Alaskan.Value + Fields!Black.Value + Fields!Hispanic.Value + Fields!Caucasian.Value + Fields!AmericanIndian.Value + Fields!NotReported.Value) * 100 & "%" & " Asian" This...more >>

Is there such a thing as a Report Header, which only shows up at the beginning of the report? This is in contrast to a Page Header which shows up at the top of each page. Thanks, Daniel Williams ...more >>

Hi all, I am designing and testing a report using an ODBC connection. The report is short (one or two pages) but the SQL request has many tables and takes several minutes. Being in development phase I don't need the datas to be refreshed from SQL database every time I click on "preview" to s...more >>

I'm trying to import a report from our report server because the rdl file was deleted from my machine. I know this sounds stupid but how do I go about doing it? I thought the files were stored on the server in rdl format but I can't find them for the life of me....more >>

Hi, Have the following sql analyzer query which takes 55 seconds to return data. SELECT i.TRANSACTION_DATE, i.TYPE, i.PART_ID, i.WAREHOUSE_ID, i.TRANSACTION_ID, i.WORKORDER_BASE_ID, i.QTY, i.CLASS FROM VMFG..SYSADM.INVENTORY_TR...more >>

I have built two reports, a master report and a subreport. The report runs fine and all the data I need is displayed. The problem is when I export the report as PDF the subreport does not show up on the first page. The subreport starts from page 2. Any thoughts on why this is happening...more >>

I have enabled Forms Authentication on Reporting Services. Everything is working ok in Report Manager and Report Server. I was trying to script out some administrative tasks using rs Utility. But I could not get connected to the reportserver from rs Utility. The command I was trying was: ...more >>

I need to navigate to a page outside of reporting server without using an absolute URL("http:\\localhost\bla bla bla") I need to go to a relative URL ("\someVirtualDir\bla.htm") on the same web server. This does not work. any ideas? ...more >>

Hi, I have a Matrix Report with on COLUMNS 2 Groups: YEAR BUSINESS UNIT In my SQL data I only have YEARS 2003 & 2004. Whatever Am I doing, RS generates 2 pages and thus 2 sheets in Excel one for 2003 one for 2004. My Report has the SAME structure than the MS Sample ...more >>

1. Is there a way to Expand All nodes or Collapse All Nodes in a drill-down report designed with RS ? I find it annoying to click every + sign to open all nodes. Maybe, there is an easier way that I do not know. 2. When the same drill-down report is partially expanded and I export the report...more >>

Hi All: I'm working on a reporting project using SQL Server Report Services, and struggled with the problem below: After we use the xml data extension for the SQL RS, we are able to generate multiple datasets from a single XML doc returned from a stored procedure. But we cannot mani...more >>

Hi all, I would like to know how can one change the thousand and decimal separator. I tried to change the ReportingServer web.configs <globalization> culture and uiCulture. Regardless of the cultures I am always getting US number formats (e.g. "1,234,567.89"). The format string I use on the ...more >>

I have a report that I want to print. This report is invoked from a windows app. The only thing I have been able to figure out so far is displaying the report in a browser. Is there a way to programmatically send my report to the printer without viewing in browser first. I would like it ...more >>

Hi: I am running SRS on a named instance of SQL. When I attempt to run this DTS package, it fails on the five update steps with the error message "Cannot open database requested in login 'ReportServer'. Login fails." How can I point it to the non-default instance of SQL. Thanks in adv...more >>

I have a report that includes a chart. The Y Axis is hours the X Axis is the date time stamp of the "start Date" of a service request. The SQL data shows it s 11/03/2004 However the chart format adds 12:00 AM to every time entry. Can anyoen assist with this visual format?...more >>

Hi Jump to url giving problem when parameter values having "&" symbol. Requested ULR is not showing. Pl let me know is there any escape method in Reporting services...more >>

I'm running Reporting services with SP1 against Sql Server 2000 & Analysis Services both have SP3a applied. I have two reports running against analysis services using the same Mdx command, one is a table the other is a chart. The table works the chart doesn't. The problem is a login box keeps ...more >>

Hello, I am trying to copy the rendered output from Reporting Services to create a PowerPoint presentation. I understand that it is not possible to directly render to a PPT and I am able to do so by saving the output IMAGE stream to a file, and then loading PPT sildes from that file. Howeve...more >>