Hi, I have a strange problem since yesterday. I'm trying to change datasets in my project and I save changes. when I close the Report and open it again I see that the changes where not saved. Also the visual studio keeps getting stuck and I have to close it and open it again. I have notice...more >>

I have a great column graph, but I was wondering if there were any options on the graph so I add a trend line? Or maybe there's an option I'm missing on the line graph. ...more >>

I have a Matrix that always displays two rows of data. One row show values from Jan 1 of the current year. The second row shows values for today. In the foot I show the % the values have changed so YTD with the following formula: =(Last(Fields!Core.Value) - First(Fields!Core.Value)) / Fi...more >>

Can RS2005 run on/with SQL Server 2000? ...more >>

We would like to have a way to export just the data displayed in a report to Excel. We have looked at CSV export, but find it doesn't export well. We would like to remove the headers from the report when it exports. The only way we have found to do this is to create a separate report withou...more >>

I am using the report viewer that came with visual studio beta 2. With this report viewer there seems to be no way to send paramters to the viewer or specify a render format automatically. Is there anyway to send parameters to the vs 2005 report viewer ?...more >>

I want to search on a date field with user input. How can I make it to where it will give user a startdate and an enddate box? Remember I have only one date field. SELECT COURSE_NBR, ATTEND, COMPL_DATE FROM EH_MEMINFO_1 WHERE (COURSE_NBR LIKE @COURSE_NBR) or ...more >>

I am a newb in Reporting services and need to create a parameterized report. I have already created a report parameter and now I need to apply it in the report output. I assume that I have to somehow pass this parameter to the dataset that is used to display the data. I am putting = 'Parame...more >>

Maybe I should have asked in one of the SharePoint groups, but maybe someone in this group knows what's wrong. Anyway, in a SharePoint Portal server 2003 portal, I've created a page with the Reporting services web parts. As the company in question is Norwegian, I want to change the title of th...more >>

we have the following formula in a business objects report that we to convert to use in reporting services - I have no clue how to perform the MOD or TRUNCATE in vb .net =If(<Agent_Calls>=0) Then "00:00:00" Else FormatNumber(Truncate((<TOTALTALKTIME>/<Agent_Calls>/3600) ,0) ,"00") & ":" &...more >>

I have a scenario where I want user to input data for search. Statement looks like Select course_nbr, attend From table_1 Where (course_nbr = @course_nbr) This only allows user to input exact course number and then the query will return a result. I want to be able for user to input ...more >>

I have developed few reports using reporting services (service pack 2), but still facing some problem in the date parameter and would look for help / share here. Thanks advance! 1) How RS treat the date format? YYYY-MM-DD (the data is correct when i use this format) DD/MM/YYYY...more >>

Hi, I am trying to use custom assemblies in the reports. For a specific report I add the reference properly and used it in the field calculation. However when I try to preview it, or build it fails and gives me the following error message: Error while loading code module: 'ReportHelper...more >>

Is there any place I can find the listing of SQL Reporting pre-defined fuction? Thanks...more >>

Hi We have a strange problem. In our report we have a picture that has its Jump to URL property set to ="javascript:history.go(-1)". It works fine on my developing machine but when we run the report on server we get the following error: Exception of type Microsoft.ReportingServices....more >>

I have a report with multiple datasets. I need to create a Sales per Hour field that takes the sales from one data source / hours from another data source. The matrix is grouped on the Keycode from the sales data source. I get a number but not the correct number. Is it even possible to us...more >>

To all the expert: I am really new to SQL reporting. I have encountered this issue for couple days already. I hope you guys can tell me how to do this: I am trying to build this sales report, the report should looks like following: [Item Name][Sub Jan][Sub Feb][Sub Mar][Sub Apr].....more >>

I'm wondering if there's a way through code to manually trigger a timed subscription to run? The only thing I can see is to create an additional schedule on the fly set for a few minutes in advance. Any help would greatly be appriciated. Josh...more >>

I have developed a report that uses two 'datatime' parameters ('start date' and 'end date'). I then introduced a third parameter ('Range') which provides a difinitive list of integer values to select from. On selecting one of the integer values from the 'Range' parameter, the 'start date' an...more >>

We have an asp application that is linking to a SRS report via a url. We are using basic authentication, and need to know how we can pass the credentials without the user having to actually sign in? Is this possible? It is classic asp, not .net. -- Lauren...more >>

Does anyone know a way of changing fonts within a textbox in either = rs2000 or rs2005? I am trying to use bolding for part of the string =20 (ex: You owe $500.00, you must pay immediately) Thanks, Dennis...more >>

Is there an IRC channel on network that has any sort of reporting services conversation? Thanks in advance Weston Weems ...more >>

Is there a way in reporting services to define your date parameters as including the final date? Right now if someone enters 08/22/2005 for the start date and 08/29/2005 for end date it will run from 08/22/2005 12:00 AM TO 08/29/2005 12:00 AM. This will not include results from the 29th - wh...more >>

When I set the parameters on a ReportViewer and click the ViewReport button, the "Collection was modified after the enumerator was instantiated" error is thrown. Acessing the report directly through IE works perfectly. The problem only occurs in the ReportViewer. Is this a bug? Is there an...more >>

Hi. Hope this reaches the RS development team. I would like to know if in the new releases of RS there will be expressions as there are in the DTS visual studio. For example in the fields of width, height..at the moment we have to put a fixed width and height whereas we could use the expressio...more >>

Hi, Can I get a Date Parameter that the user filled and format it to 'yyyy-mm-dd' format, so I could execute the Query with the formated date? Limor...more >>

Is it possible to publish a report from a DEV reporting server to a PRODUCTION reporting server? We would like our developer to deploy to the DEV server and then someone publish it to production gert ...more >>

Hi I need to have the following result format into a date time parameter with the current date ='1/07/2005 5:00:00 AM' so when i schudule this report to run it will look at the current date at 5am. Thankyou todd...more >>

What will be "Query string"? Thank ...more >>

Hi , I wrote a function in the report property code : Public Function AA(field as string) AA = field End Function When I try to write an expretion like : =AA(Me.Value) I get and error of AA is not recognize. What is the problem ? 10x. ...more >>

I'm having a problem connecting to an access database from http://localhost/reports. I can connect from the computer I developed the reports but when I goto another computer it gives me this error message An error has occurred during report processing. (rsProcessingAborted) Cannot create ...more >>

Hi, we have a business need that would 1. allow a user to select and order the columns from a table in the UI 2. The user would then provide filtering on those columns (CLIENT SIDE) 3. User will then execute this report to return data based on criteria ** The initial UI screen will have dat...more >>

I have a table where a cell gets populated with a lot of data. When data is longer than the page it would page break into the next while leaving a huge white space on the previous page. how can i make it page break in the middle of the text when it needs to instead of the whole cell getting m...more >>

I have just installed RS (Standard Edition on Win2K. SQL instance on same server). At the end of install, I got a dialog that said: Setup could not initialize the report server. You must manually initialize the report server before using using it for the first time.. I ran: rsconfig -...more >>

I have some crystal reports .rpt files that I'd like to publish to users via the SSR menu. Is there anyway to do this? THanks -- Doug...more >>

I have read several posts but still cannot get to the answer and I think it is something very basic and simple. I have one report with embedded code that is running a sqlconnection, sqlcommand, and sqldatareader to get two different fields from a query to build a string to return back to the t...more >>

Windows 2003 Enterprise SP1, Sql Server 2005 June CTP. I created a report on data from another server. I can run the report just fine on the server with Reporting Services. When I try to run the report from my computer I get the cannot create connection error. I have full rights to the server ...more >>

Windows 2003 SP1 SQL 2000 SP4 RS SP2 I have a soap call to the report server that would generate a PDF. After installing SP1 to windows 2003 my code stopped working. I would get HTTP 401 - Unauthorized. If I remove SP1 code works like a champ. I have done the DisableLoopbackCheck = 1 ...more >>

Robert, I want to thank you for monitoring this group and providing us with answers to many of our questions. I would like to bend your ear concerning some functionality that we desperately need with SRS 2005. We are very happy overall with SRS and your team has done a great job. We ar...more >>

Hi, I am not an expert but I want to create a subscription. Where can I find informations? I don't understand all. Moreover, I used Visual Stucio.NET. In my application, I have created a webservice. I want that my application sends via e-mail the report. Must I use CreateSubscription method?...more >>

I have a custom form which users can use to create subscriptions for specific reprots. I am able to create subscriptions just fine but my issue is that all the subscriptions are created as ASPNET user. Am I missing something in the setup? Thanks for your help. -- Message posted via SQLM...more >>

We have been running Report Service for some time. Recently we changed the server name & the windows account that the Report Server used (using rsconfig etc). We deleted the old windows account we used (duh!). Everything is up and running with one exception. We can not delete subscriptions...more >>

Hello, I created a simple report that just one item in it, a subreport. If I run the report in my .Net Visual Studio, the report displays ok with the subreport. When I deploy the report to the report server, the report displays "Error: Subreport could not be shown. " message. T...more >>

Hi, I have just installed Reporting Services (SQL Server 2000 Std, Windows 2000 SP4) and within Report Designer (VS 2003 Architect) I can develop and test my reports successfully, but when I deploy them they produce a HTTP Error 403. The data source seems to be setup correctly and I can ...more >>

I've just started messing around with reporting services and was wondering how I can specify a search criteria for a drill-through report? Currently I have a Main report, so that when a user clicks on a location e.g. New York. I'd like my report 2 to show only New York information. But when ...more >>

I can't create a connection for Oracle (any version). Is this a CTP issue ?...more >>

Hi, I want to send to my Report hidden parameters by Url. I read that in order to do so I need to check the Prompt User checkbox and clear the Prompt string. But I can't find the Prompt User checkbox in the Report Parameters window. I installed SP1, but still I can't find this checkbox. Where ...more >>

I've got this installed and the sample database was working fine. I then imported about a weeks worth from two iis servers (grew the DB to about 5 GB) and now pulling up any of the default 12 reports takes at least 30 minutes to an hour or longer. Is this normal? The SQL server is a dual ...more >>

When I go to http://www.servername.com/ReportServer I get: You are not authorized to view this page. When I go to http://www.servername.com/Reports I get: The underlying connection was closed: An unexpected error occurred on a receive. In RSReportServer.config I have set: <Configuration> ...more >>

I understand the concept of subreports and their wiring... but if I have a table thats bound to some data, and for each record in that table, I'd like to spit out a basic subreport, should I not then be able to just stick it in the table detail row? I get table cell cannot contain subreport...more >>