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 >>