Is there anyway to modify the Worksheet name(s) for a report that is rendered to Excel? e.g. I have a report that produces 10 pages of content, rendered to 10 worksheets within an Excel file. Rather than having these sheets called "Sheet1", "Sheet2", etc, I would like to be able to set t...more >>

Hi there, My project requires me to plot a column chart having minimum and maximum threshold values. I'm not too sure how to implement in the reporting service under the chart option. I've tried another method where I plot a column chart and then I drew two lines on top of the column chart. ...more >>

Hi, we are using a .net proxy to control access to RS, proxy calls SOAP Render() and each report image stream is saved locally and the report html returned and displayed correctly by the users browser - the report images are accessed on a shared directory and removed after each access With a ...more >>

I tried to access an external image sample.gif.img through the URL: http://localhost/WebModule1/images/sample.gif.img. But, the image did not show. When i tried another image http://localhost/WebModule1/images/sample2.gif, it showed. My question is does reporting services render images with ....more >>

Hi, Can RS excute batch print? I have many .rdl report on Report Server, but I want to choice some of them and auto print, like I choice report 1, 4, 5, and so on.. any function can do it? Thanks! Angi ...more >>

Hi, I want to keyin many values in a parameter textbox, and I try the syntax like following but it doesn't work, and response the syntax error, why? SELECT * FROM Product WHERE (Year = 2003) AND (MonthNumberOfYear IN (" + Parameters!Month.Value +")) Is any mistake in my s...more >>

Passing a URL parameter, everything works ok until I clear out the "Prompt String" (so user can't see parameter). Then my report DOES NOT render. The datasets are not even populated, just a blank screen is displayed. Please help!! ...more >>

I have a report that I always have to set the 2 date criteria fields to the first day of the month and to the last day of the month....I'm sure there's a function that I can set as a default in the report designer?? Possible?...more >>

I have a stored proc to return the main report data. I have another dataset1 to return the distinct values for my parameter. I filter the main data based on the parameter selected by user. I wanted to add 'ALL' option to the parameter drop down. I have added an UNION to the dataset1 to include this ...more >>

Hello, I am defining StartDate as a parameter and use it in my query as @StartDate in the where clause, it works fine. Now, in where clause I also need to have this: "AND ID=Environ("MyID")". Environ is a function in visual basic to get environment value from system. How can I do this in ...more >>

Hello. I am new to SQL Server Reporting Services. The short explanation of what I want to do: In a pie chart, I have turned on point labels. I want each of the point labels to be a link. When you click on the link, you are taken to another report (in table format) that is more information about the ...more >>

Hi, When I click on Scheduling, History, new subscription hyperlinks the below error message is popping up, so I couldn't schedule a report. please help me in this regard what needs to be done. EXECUTE permission denied on object 'xp_sqlagent_notify', database 'master', owner 'dbo'. Thanks...more >>

I've configured the IIS with only windows authentication, when i connect to Reporting Server or Reporting Administrator uses the windows account, but the security rules work different: I have configured rules for two accounts: my windows account and IUSR_machine. When i try to connect to ...more >>

I have Reporting services configured for SSL everything works, including links to depolyed reports, folders, property pages, Site Settings and Subscriptions etc. The one thing that does not work is the HELP link in the upper right hand corner of the report manager. The link here Clearly uses http:...more >>

I am building a web application which uses the report service to provide the reports. (This is to allow outside users access to specific reports, I render the report on the web-server, not the sql server). Currently I have some reports built and tested (http://[Report server name]/reports). I ...more >>

I have had enough of Crystal and RAS, can this be done?...more >>

Hello, I'm currently in the process of deploying reports transfered from Crystal Reports to a Reporting Services server. All of the reports have been deployed with the exception of about a third of the reports that make use of Oracle. I originally designed the shared data source to use the Or...more >>

hi, do i have access to subreports ?? for example: how many rows were created? a have a tablerow with a sub report. i want to set the visibility to hidden, if no rows were created in the subreport.... regards Patrick ...more >>

I get the error, "An attempt has been made to use a rendering extension that is not registered for this report server." I get this error when I use the stored procedure below as a dataset. It occurs when I try to preview the report. Any reasons why? SET QUOTED_IDENTIFIER ON GO SET ANSI_N...more >>

I am experienceing a very frustrating and embarrasing problem. I hope someone may be able to help me. I have developed various reports and tested them on our in-house development server. Some contain charts and most are drill-down. After deploying the reports to our customers production serv...more >>

Hello, I am attempting to use a CREATE GLOBAL CUBE command when defining a data set in MSRS. The intent is to use the MSRS security and scheduling capabilities to dump local cube files from our data warehouse to a file share, then use MSRS's delivery mechanisms to deliver the cubes to the intend...more >>

Hello, I just started to use Reporting services, how can I provide an input parameter to a report? Thanks, Jim. ...more >>

I have a report with 2 subreport inside. When i view the report the 2 subreport appears on the same page together with the data from the main report which is correct. Problem is when i render it/export it to a different format so i can print the report, the subreport appears on different pages. Anyb...more >>

Hi, everyone: I have a report, in which there are two subreports. One subreports displays Major Qty and the other subreport shows Minor Qty . Then in the main report, I need to sum these two Qty together. How to pass result from subreport to main? In crystal report, I can use Shared Variable to d...more >>

Hello, I'm getting the following error on the application log of the event viewer: Schedule and Delivery processor cannot connect to the report server database. However I have no trouble to test some reports (e.g. the sample reports provided with reporting services). What could be wrong ...more >>

I am building a web application which uses the report service to provide the reports. (This is to allow outside users access to specific reports, I render the report on the web-server, not the sql server). Currently I have some reports built and tested (http://[Report server name]/reports). I ...more >>

I'm developing a class for manage the reports in a Windows Form. I'm using the URL access. Is there a system for obtain the total numer of pages of the current reports? ...more >>

I have a report with several groups. the last group (3rd group) displays totals so I only have a group footer displaying. This group only displays 2 rows which are totals for that employee. However in the 2nd Group footer when I try to get a count of the number of rows, which in this case is only...more >>

Guess this was already posted somewhere.... My connection string to connect to sybase: DRIVER={Sybase ASE ODBC Driver};SRVR=<server_name>;DB=<db_name> Data source type : ODBC Works on the Designer but not on the server. I get a system error 126 - specified driver could not be loaded. ...more >>

I've got an issue I cannot seem to address. We've upgraded to SP1, and I still am not able to open Excel files exported from Reporting Services if they contain more than a few hundred rows. For example, I have a report which contains 1453 records. Exporting to an Excel takes a few minutes, the...more >>

Is it possible to concatenate the subject in a table cell? For Example: ="string text " + CStr(Sum(Fields!Revenue.Value)) Return value wanted: string text $9,999.00 Thanks in advance....more >>

Hi all, Consider the following scenario: Table1 has 3 fields - account, trn_no, balance. To produce a report listing records for each account & sum of the balances we would do the following: Add a table Add a group & set the group on expression to the account field Add the account fi...more >>

Hello, Getting pretty desparate here. There has to be an easy to way ensure that each column in a MSRS table is represented in the exported Excel sheet as ONE column and not a bunch of merged columns. Microsoft -- is there a list of "suggested" report building techniques that will allow re...more >>

I am having trouble installing SQL Server Reporting Service SP1 I get prompted for the Reporting Service CD which I put in but it then claims it cant find the MSI ?? Any ideas...more >>

There is a example about dynamic query in Waokthrough of about report service in the MSDN: In Data view, select the Employees dataset, and then use the generic query designer to replace the original query with the following expression: ="SELECT FirstName, LastName, Title FROM Employee" & IIf...more >>

Hello all, If I want to create a report where there're 3 parameters A, B, C. While the list of displayed items of A depends on selected value on B & C. list of displayed items of B depends on selected value on A. list of displayed items of C depends on selected value on A also. Is this p...more >>

I get such warning : "Images with external URL references will not display if the report is published to a report server without an UnattendedExecutionAccount" And picture dont shows. Can anybody help me ? Thanks. P.S I have SP1 ...more >>

Was there an answer to this issue that I missed? http://groups.google.com/groups?selm=ebk4HkMEEHA.3804%40TK2MSFTNGP09.phx.gbl I'm having the same problem - how to do a complex filter e.g. Expression: (CInt(Fields!Field1.Value) ! = CInt(0) OR CInt(Fields!Field2.Value) != CInt(0)) Operat...more >>

Just thought I'd report a little bug I'd found. My system is set to UK regional settings which includes metric measurements. When I add section to a report, i.e Header or Footer the height property is in inches. If I change the height, say to 2 it correctly treats it as centimetres. A small ove...more >>

I would like to get hold of ActiveViews to evaluate but all on-line avenues end up at the Microsoft Press Release, announcing their acquisition of it! Regards Chris McGuigan...more >>

The problem with exporting Sub-Reports contained inside a Table or Matrix...will there be a service pack to fix the problem? As most reports consist of a table this is a major deficiency. Please advise......more >>

Hi, I have a table with no header and but all details sections. How can i put a page break after the last row of the details section gets printer. Thanks...more >>

Hi, My reports require a custom font "Helvetica". But this does not display in the Font Selection combo and when i keep it hardcoded in the font selection field. it errors out (for charts and graphs, in particular, and not for textboxes). How can we achieve having this font in RS?. Thanks...more >>

Hi, I have a formatted Dataset query with size exceeding 300 lines (vertically). The dataset editor is not allowing me write it. Is this a limitation that the query size should be less than 300 lines or do we need have any way to increase this. Formatting helps understand the query it in a le...more >>

I haven't seen any examples of using RS with a web service as the datasource. Is this possible and if so could someone point me to a url? From what I've seen you can only use a database as a datasource, what happens when you've got business components adding 'value' to raw data. You don't have t...more >>