Hello, My report seems to be generrating a randon number of rows per page. Some pages have only one row, others three and some blank. this does not appear to correspond to group breaks. Has anyone else seen this? Is there a way to make the report rows follow immediately one after another...more >>

Hi everyone, this may be a very stupid question or a stupid way of doing things, but I have a report in a matrix in the following format: -------------------------------------Year -------------------------------------Month Customer----Part----Currency--=Sum(Amount) The problem I'm having is ...more >>

Hi, I want to know if you can edit the Subtotal function for a matrix? I have two columns namely: TY, LY, % Diff (TY - LY). When I do a "Subtotal" it adds even the % Diff column. I want it to do the equation TY-LY. Is there a way to do that? Thanks....more >>

I added a "Hide Details" Boolean parameter which I am using on the Visibility.Hidden property for some rows in a table. But if I enter the following in the InitialToggleState property for the expansion cell the + (plus) “icon” never changes to a – (minus) “icon”. Here is the expr...more >>

I am using Parameter to determine the grouping of my table. Is it possible to use a dynamic parameter based upon my grouping value. i.e. if the user selects to group on students the dynamic parameter will be populated with all student names, or if the user selects to group on subjects the dyna...more >>

When RS completed installation a message was dispalyed saying that the installation was successful, but that RS was unable to initialise. Now whenever I try to access the http://servername/reports site, I get the following error. " Compilation Error Description: An error occurred during th...more >>

I'm working on a project for a national restaurant chain. I've built a complex class that allows them to do various forms of sales estimations for stores who fail to report their weekly sales. I say "complex" because it has a detailed class hierarchy under it and performs lot of SQL Server work...more >>

Ive written a security extension based on microsoft samples, i can call the SOAP API and get authenticated but i dont know what to do so i can use this authentication method using URL access, i need that since i want to be able to keep the toolbar. ...more >>

I have a matrix with the following format Date Month RowGroup1 Group2 Amount I have month in the rows because I want to page on month when exporting to excel in order to produce a new sheet. This seem to work ok except for the following. ...more >>

Hi What are the implications of a long running query/report on asp.net thread pool, I understand that if I am using reporting webservices or any webservices it uses one of the thread from asp.net thread pool and if that thread is blocked for processing the long running report/query it can't p...more >>

I install the evaluation version of SQL Server 2000. When I install the evaluation version of Reporting Service, the Installer require me a SqlServer with Server pack 3a But the Server pack 3a can't install with evaluation version of SQL Server 2000 How can I do? ...more >>

When installing reporting services, I get the following error: "Authz is not installed on this computer. Authz is required by the Report Server component." I am allowed to continue the installation. When complete, I notice that my database server now has the AnswerWorks2000 database ...more >>

Hi there, I know there has been a lot of discussions and irritations that RS does not offer direct printing, instead the user has to export to pdf(or another format) and then open that and print the report from there, but I would like to know if it something that Microsoft is working on and...more >>

I want to hide the parameters section of the toolbar only when the report loads the first time. is it possible by any URL parameter ? To be more clear, Theres a button on the toolbar that closes/opens the parameters section of the report. correct ? I want to keep the parameters section close w...more >>

Tries to export the key files but I only get Access Denied. Tried to export to a: and had logged in localy as admin. Anyone got a clue whats the problem? The same problem on 2-servers... Regards...more >>

I have a big database to test my report, the report is made by reporting service. But when the query for the report get too many data such as more than 100,000 rows for the dataset, My computer is down because of lacking memory. What can I do ?...more >>

Is there a zoom facility when designing reports? can't seem to find one. Regards Toby ...more >>

In my detail section I would like to have a report that has a "Carried Forward" amount as a total for the page and then on the next page header the value as "Brought Foward" this will total up at the page footer and be "Carried Forward" to next page and so on until the last page where "Carried F...more >>

I changed port of IIS to 9000 and after setup of RS I have received following message: "Setup could not initialize the report server. You must manually initialize the report server before using it for the first time. For more information, see the Reporting Services setup documentation." I hav...more >>

hello installing sp1 requires the original cd? please tell me i don't... i really don't want to shuffle tons of files around so i can extract a 600mb file just to install a service pack. man, i hate this about msft... i'm always digging up original cds for updates. what a pain. what's the r...more >>

Hello, I have a report with drill down capability that is grouped by two columns. I would like the first group by column to alwasy be expanded and the second to allow drill down. So far, I have not been able to find a way to do this. I have tried checking the initial aooearance of toggl...more >>

hello, we have RS installed on a W2003 production Server without VS (no design) . This version is a french version , we also install SP1 french version Everything seems ok and we got a french version ( we are making call of reports via URL in an aspx page) . Times to times, and there is our ...more >>

We have an app that calculates invoice values. We would like to immediately trigger it to print a reporting services based invoice. How do we pass the variables from a stored procedure and start a reporting services based report. As with a previous post, we could call a c# app that would...more >>

I have a table with subjects and various marks per subject. Subject A : 10%, Subject A: 80% Subject B: None Subject C : 20% Sunject D: 90% If the subject only has one mark which is greater than 50% I dont want it appearing in the table. i.e. Subject D would not appear. If the subject ...more >>

Hi guys We are closing down our old test server. This server used to run RS. Is there any documentation on how to move the RS installation to another server so that Reports, Schedules etc. is intact and ready for use on the new server? Thanks. Regards Jonas ...more >>

bringing an old thread back to life.... How about this question: I have a stored procedure called "get_months" that shows a list of available months specific to the user who runs the stored proc (you pass in an @emp_id stored proc parameter). I'd like to show the output of this as the dropd...more >>

I have successfully installed RS. However during the installation I was advised that Visual Studio was a prerequisite on the RS server. I am just wondering if there is a way that the required components from Visual Studio can be installed without installing the whole thing. Any links to docu...more >>

I had to stop the RS service on our server. It's creating 30 megabyte log files, once every minute. I can still serve up reports evidently with the ReportServer service stopped in Control Panel, but I doubt I can publish reports. If I start the service, the log files immediately start to pile ...more >>

Our production server ran out of disk space over the weekend due to a runaway log file condition (again). We had this happen about 2 months ago, prior to SP1, and I reported it here. MS admitted that had seen the problem, but was not able to reproduce. In the Event Log, I see thousands of en...more >>

Hi, Is there a way to read the rs: parameters from a report? I can read my parameters, but don't know if I don’t know how (if there is any way) to read the parameters such as rs:Format, rs:Snapshot, rc:Section, etc. Please, if it can’t be done, tell me. Thanks in advance, Santiago...more >>

Hi list, This is the second time I've posted this question, the second time I've created a report with "From Query" parameters and the second time I've had problems with performance with the "From Query" parameters... http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&threadm=eOTaQ1ufEHA.3024%...more >>

Some one told me that there are parameter controls in other reporting tools such as crystal reports and oracle. So is it true that the only advantage that MSRS has is it is free for SQL server? -- Sincerely...more >>

Hi group, like other members of this group I've got the error message: Exception of type = Microsoft.ReportingServices.ReportRendering.ReportRenderingException was = thrown. (rrRenderingError) Get Online Help Exception of type = Microsoft.ReportingServices.ReportRendering.ReportRenderingEx...more >>

hi, when I was installing reporting services I unchecked the box when it asked me if I wanted to use ssl, because it was giving me an error if i left it checked. Now I am getting an error when I try to deploy from my machine to a different server - "The underlying connection was closed: Cou...more >>

Hi, How can you add valadation controls to parameter text fields - for data type checking, range checks, etc.? Thanks, Gearóid...more >>

I have a table that has 2 colums Project Probablity 1 15 2 89 3 12 4 22 5 7 6 11 7 43 8 92 9 63 10 87 ....n ...n I have to show report that has to sh...more >>

We are currently implementing forms authentication in our RS deployment. The MSDN sample helped get us started. We are now faced with the authorization implementation. How do I go about telling RS which user has access to which folder/report? Telling RS which users will be administrators...more >>

Hi Group, How do i Conditionally Hide the Main Report Iitem based on the SubReport Value. My Main Report Looks Like This Task Id Description Effort 1020 Project Plan 100(Subreport Item) What i want is if the effort is Zero i Should hide 1020,Project Plan and My Subrepo...more >>

the running value works on the preview of reporting services but when i run the report on the server it displays zero all the time. plz tell me how to solve it thanx in advance...more >>

My y axis of bar chart does not show values when there is more data in table. Is there any way out .please help me --- Posted using Wimdows.net NntpNews Component - Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching....more >>

I have chart and table in my report.Depending upon groups i decide whether to show chart or not. when there is condition that chart should be invisible then my first page comes blank and data is shown from 2nd page.Thanks in advance --- Posted using Wimdows.net NntpNews Component - Post Made f...more >>

I'll try posting this again, since it garnered no reply the first time. Greetings. I found an odd issue when working with a series style in a line chart in SP1. I was using my own function to determine the color of the series. So I entered =Code.PickColor(Fields!ResultSort.Value) for the ...more >>

I am writing window application to generate report by calling web service. But I am using form authentication. Then I add reference (Microsoft.Samples.ReportingServices.CustomeSecurity) which is generated in form authentication sample. When I render report, the following error occured: ...more >>

I am having permission problems with the sample report printing program from Bryan Keller. (http://www.csharphelp.com/archives3/archive545.html) The DefaultCredentials from the CredentialCache certainly has no data, and I don't seem to be able to get valid data into the cache Not sure about...more >>

I have been project managing the rollout of Reporting Services for the last couple of months at several client sites in Austrlaia and have been looking at the SQL Server 2005 Express Beta 2, as well as visiting some discussion groups. I have also noticed that the Beta doesn't have any Repor...more >>

Hi all We are getting a 'Operation Timedout' error when trying to render a report as pdf. Will setting the Timeout and Timeoutspecified property will help resolve this issue. Based on some criteria this report can take long time. Also I cant find how to set the timeout and timeoutspecified p...more >>

I want to use the CSS stylesheet to modify the viewer/ toolbar. This may be a dumb question, but can anyone please tell me: What are the steps to modify the CSS? Also - please tell me what kind of things I can do with it? I have been trying to open the CSS in a text editor and playing wi...more >>

We are installing Sql Reporting Services 2000 Evaluation Edition. During the setup we are selecting the Remote Sql Server Instance (On the same network and it is an enterprise edition) as the Reporting Server Database. Locla system has IIS and ASP.NET installed, so it will be used as Report ...more >>

Can anyone tell me if VBScript is supported in this product? I have developed a report that takes one parameter. I have removed the checkboxes for allowing nulls and blanks for the parameter, yet when I execute the report and do not enter anything into the parameter field - nothing happens. ...more >>

I am trying to write C# .NET code to stream a report without using the SOAP Reporting Services tools. (There is a reason for not using SOAP in my case.) I am using the System.IO.WebRequest class to get the response from the server Here is my code: WebRequest request = WebRequest.Create( ...more >>