as title,is it possible? thanks for help! ...more >>

Hi, I'm a newbie to SRS, so please forgive me if this is simplistic. I have a report that I'm launching within the context of a web application. One of the lists in the report has as it's datasource a stored proc that takes in a parameter. On the data tab, when I execute a particular dataset...more >>

Can sombody tell me how to generate cahrt dynamically in reporting service? I need to generate a number of charts based on the number specified. Thanks -- Wei...more >>

A report that I have run every monday requires 2 parameters. These param's are StartDate and EndDate. Is there a way to generate these fields for the week automatically. For example, if i schedule it to run on Monday, I would like the start date to be Monday 11/29/04 and the EndDate to be F...more >>

Hi, I finished creating my reports and have had an issue with generating the reports on http://localhost/reports. When I login to http://localhost/reports with a user that is part of the Local Administrators Group the reports run perfectly correct. But when I login with a user that is n...more >>

I want to be able to build my solution off-site and then use the following... Locally copy project, only necessary files. Zip-it transfer it, unzip. The problem is that when I load my Reports.aspx page from my app it needs to load the available reports on that report server and display t...more >>

I have a list of parameters, and they are months. This list is dynamic, and is based on a query to an OLAP cube. I want my default parameter to be the last month minus one, so that when the last month is December, I want to have November as default. How can I do this? All help appreciated! ...more >>

I see that this has been asked over-and-over again...don't see that anyone has gotten an answer on it...thought I'd have a go: --------------- I'm developing a web app that interfaces with RS through the web services API. In the custom paging portion of the solution, I need to know how many...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. Does anyone know how I can provide today's date as a subscription's default date parameter? I thought I might be able to just state =Today() or something similar when creating the subscription but it doesn't seem to work out. Thanks in advance. ...more >>

I have the following sql: *********************************************************** SELECT region.region_name, sale.sale_dts, SUM(sale.total_pt_of_sale_amt) AS POS, SUM(sale.total_incr_rev_amt) AS [Incremental Revenue] FROM region INNER JOIN region_terr ON...more >>

Anyone know a way of doing this? Basically in cells where there is no results, I get blanks and I think 0's would be a lot nicer. ...more >>

I am trying to use the SQLReporting WebService but am gettt=ing the error message below. What permissions need to be set for NT Authority\Network Service? The permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are insufficient for performing this operation. --> The permissions grant...more >>

Hi all, I am using the ReportViewer component to display reports. Is there a way to make its height and width to just integrate with the actual aspx page ? ...more >>

Hi, I am creating an asp.net app and was wondering how I can call up a report created in RS from my app? Does anyone have any websites or docs on how to use RS? Thanks, JJ...more >>

Hi, SO how does everyone here like Reporting Services for SQL? Any real problems or bugs I should know about if I use it? Thanks, JJ...more >>

I tried to insert this line of code to the Column in the query design but it doesn't work. Similar command works in MS-ACCESS. IIf('[Policy Received?]=No', DateDiff('y', tblFileInfo.EffDate, GETDATE), 0) Can someone help, thanks in advance....more >>

I have a few questions regarding reports that I haven't found answers after a little searching. Thanks for any help! 1. I need to create a few reports with some repeating pages. For example, in one of them I need to have a cover page, then couple content pages, then a summary page. I need t...more >>

*Using SQL 2000 with latest service packs, and SRS SP1. I have built two reports, a master report and a subreport. I have tested the subreport, and it functions correctly on its own. The master report is a rather simple list, rendering a subreport instance inside the list, seperated by page...more >>

I have the following configuration on my RS server for an AD group. When a user from this AD group goes to the Reports web, they only see the Home title and the folder icon and nothing else. No tabs, no My Reports folder, nothing. Here is my config. System Role Assignments The AD gro...more >>

Hi all, I have to build a report from SQL tables thru an ODBC server. When I try to pass (nonnamed) parameters to the report, the SQL request runs but returns nothing, as if the value was not understood. I have put "?" in the SQL request in place of the parameter. Do I need to do something el...more >>

Hi, we currently have a situation where the column headings for our group is printed on the bottom of the page and the data starts on the next page. Is there anyway to ensure the group header prints on the next page instead if no data can be fitted on the page. Hope this is clear - in Crysta...more >>

Hello, I am posting this through the MSDN Managed NewsGroup section. We are experiencing the following problem: When programatically exporting MS Reporting Services Reports to Excel - the last row turns up missing. This does not happen 100% of the time but enough that we cannot reliabl...more >>

In my .NET application, I have my report control Zoom set to Page Width (rc:Zoom=Page Width). This works fine for the first report that appears, but when I click a link in this report to navigate to another, the zoom resets to 100%. Is there a way to get my Zoom to stay what I've set it to? ...more >>

I'm executing a query against an ORACLE DB. If I execute this query using TOAD it works fine...a little slow but I have the result rows. If I execute this query inside the Report Designer I get the next message: " An error occurred while reading data from the query result set. OCI-220...more >>

All, Figured it out. The URL needed to express a fully qualified domain. Here's the fix: From within Microsoft Visual Studio .NET 2003. 1. On the Project menu, click ReportProjectName Properties. 2. In the ReportProjectName Property Pages dialog box, type the URL of a remote repor...more >>

Hello, I use reportviewer component to present data, if I click view report button second time, it actually does not go to database and get the latest update, can I create a button and let it go to database and get latest data? Thanks, Jim. ...more >>

Hi, I finished creating my reports and have had an issue with generating the reports on http://localhost/reports. When I login to http://localhost/reports with a user that is part of the Local Administrators Group the reports run perfectly correct. But when I login with a user that is n...more >>

Hi, I have created a dataset say "DSMasterList" which has the list of items say product list and also I have another dataset say "DSDetails" which will have details of the products for a given productID. My requirement is to have a report that will print ALL the products from "DSMasterL...more >>

I'm trying to install Reporting Services on a new XP Pro SP2 IIS 6 development box. The local database is SQL Server 2000 sp3. At the end of the installation I get an error message indicating that the 'Setup could not initialize the report server' and that I'll have to manually initialize the ...more >>

I have a report where I have setup a table and am using a subreport for the header and using the Page footer for the footer (Subreports can't be used in traditional Page Headers. I also have a Right pane. What i'd like to do is create a table that will use the space that isn't the header/footer/ri...more >>

hi all, May be someone can help me, I have two questions : 1- When I am on the layout designer, every time I ask for a "preview", it takes several minutes to produce the report. My feeling is that the SQL request is run every time. Is that true ? If yes, I don't need that, because returned d...more >>

Hello, We've had SQL Reporting Services running for over 6 months. This week, every day, we've experienced a problem where the RS website stops responding. There's no page could not be displayed message or any other error message, just an hour glass as the browser tries to go to the URL. ...more >>

I need to convert a datetime, coming from a database table, to a date. How do I do this within my report? -- Don...more >>

Hi, I am trying to add an average column to a matrix in report services. I keep receiving errors about aggregate amounts. Example Amount Number of Units Average 10.00 2 ?...more >>

Is there a possibility to preview and print reports in landscape orientation? What should I do, if my report is to wide to print it portrait? ...more >>

Is it possibile to export a report to excel with specific template? I can set an excel template per each report or for every reports? thx Marco...more >>

Depending on the time interval, that is covered by the report and which will be provided by parameters, the format of the x-axis labels should be e.g. hh:mm:ss or dd.mm.yyyy. It seems to me, that the format can only be defined statically. Why can't I use expressions here? Any help is apprec...more >>