Hi all, I'm currently installing Reporting Services Enterprise Edition in one computer that use : - Windows 2000 Server+SP4 - SQL Server Standard Edition And I've got errors during installation : Package 'VsRptDesigner Package' has failed to load properly ( GUID = ..... Package 'ACT Proj...more >>

I can i place a tick in a tick box, do i have to write code or is there easy way...more >>

I have a textbox in my page footer with an expression like this: Sum(iif( (ReportItems!textbox56.Value = "Complete"),1,0)). Basically it counts how many times "Complete" comes up in a page. I also have a parameter which can filter out any "Complete" values using the visibility of the detail ...more >>

Sorry but new to RS and need to have each detail line in a table to be numbered. Can somebody please help me with some code or point me in the right direction. Not totally sure if it's done via expression or not. ...more >>

Hi, I have a very simple problem. I have an image , a chart and a matrix in a report. But after deployment when I view the report from http://localhost?reportServer, the the image is at the top ALIGNED in the cenetr of the page, The chart is aligned Left in the page & there is a HUGE EMPT...more >>

Hi, I am facing the same problem as many other, i.e when I deploy my reoprts project, I get the error :: "The Underlying connection was closed. Could not establish trust relationship with remote server". I was just wondering that if its a good idea to set the <Add key= Secure Key Connect...more >>

Headers are more sophistacated these days. They require client information, report execution date, page number, report spacific details like account numbers. It seems that I cannot put a pagenumber in the body, and I cannot have dataset info in the header. If I wanted to do this .... could ...more >>

Deploing a report from VS.NET often fails with permission error. I know that making a user Admin on the target server solves the problem, but I would like to know the minimum required permissions for this operation. Thanks, -Stan ...more >>

I am trying to create a data extension and this extension has to access a COM+ application in order to run as a domain user to access files on the network but every time I try running this code it errors out with a security permission error. How do I setup permission to access the COM+ applicatio...more >>

I have a report with columns which the user may optionally turn on. when these columns are not displayed (hidden=true), the report fits nicely in legal sized paper, and when the columns are displayed, it is typically because the report will be exported to Excel. here's my quandary: if I as...more >>

Does anybody know how the licensing will be set up for Yukon? I remember seeing in the sp2 chat that 2005 RS will run on SQL 2000 [need to confirm this too], but was wondering if it is possible to purchase JUST reporting services to run on our boxes or do we have to purchase the entire thing ...more >>

Hi All, I'm a newbie to Reporting Services and i'm having a strange requirement. I have a report wherein I need to show a PriceCode on top of every page like "A", "G" and all. The problem is, whenever a new Pricecode is there, that page should have that new PriceCode not the old one. For eg...more >>

If it is in that textbox (in the details row), I have to display a drill down row underneith that record. Any help is appreciated. Trint ...more >>

Is their away to have reporting services call a dataset from an access database and export it into a sql server table through automation in a project with 2 datasources. One datasource from access and the other from sql server. I can do this with a DTS, but could I do it another way to work ...more >>

I have a Reporting Services installation where I first implemented Forms Authentication. I am now implementing SSL and have run into a problem. I can access the report server through https://<servername>/reportserver, howerver I cannot access the report manager using https://<servername>/r...more >>

Hi, I have installed Developer editio of reporting svcs on my webserver. Our SQL server 2000 (developer edition) is on a separate database server. Now I have created a simple report but when i try to deploy the report the report... i get the error Report Server not found at http://localhos...more >>

Ok here it is: this row is always visible: dealernumber dealername dealerlineageid +(show a drilldown under each dealernumber if a number in the table this additional row comes from contains any matching string in their number with "dealerlineageid" number on the row above them. In other ...more >>

Help. After we installed Windows 2003 service pack one the SQL reporting is getting an error: The request failed with HTTP status 401: Unauthorized. Can anybody help? ...more >>

I have Reporting Services, installed on a win 2003 server. For all the report created with matrix (control) when I try to export as Excell file, I have this error: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. Object reference not set ...more >>

Is there a way to query RS for subscription execution history? I'm looking for something like ExecutionLog, but for subscriptions. Thx, Joel ...more >>

Hi all i have a little problem i don't knew why i am using reporting service as a reporting engine to my application but i notice sometimes the report is generated in no time and some times it takes a long time so the perfomance not predicteable is there are any way to configure the r...more >>

I need to create data report that has repeating rows and it is composed of field names. This report looks like a payment book. I don't know how to do this, because the report show me the first record but not the next 5 records. Also, it occurs with the letters. If I have 4 customers that woul...more >>

Is there any method to deploy a report to a folder under the project's folder? I currently deploy new reports from within VS.NET and manually move them to their correct folders using the "move" button on the http://servername/reports/pages/folder.aspx?IsDetailsView=True web page. Is there an...more >>

The Subject is the whole question: Can I run Report Engine and Report Manager in different servers? This is because of my current network infra-strucutre.. I know that ReportServer is a Web-Service and Report Manager is a Web Application that consumes this Web-Service, so I would like to kn...more >>

Is it possible with a datagrid to display a hierarchy view of a dataset which is held in a single table that have an ID and Parent ID field giving multiple levels of a hierarchy? If it is possible how do we do it? Regards <<<Bryan>>> ...more >>

I have a group within a table which has for example 5 rows,all the data is the same except for one column for example invoice number,I dont want all thse data to be repeated 5 times,i would like to have only the first row with all the data and the other 4 rows with only the unique data , this ...more >>

Hi All, How do I publish SQL report in a web portal. Please help me if anyone has done it. Thanks., Adarsh ...more >>

A fairly straightforward question: When using rs.CreateFolder to create a folder, is it possible to set the "Inherit security from parent" property to false? How would I do this. What is the property called? I have tried "InheritSecurity" but that did not work......more >>

Hi, the problem in one of our reports is, that there are a lot of detail lines for each group, so if you scroll down to see them, the table header is not visible. Our customers are complaining about that, because they have to scroll up and down to see to which field the detail belongs. Mor...more >>

Hi I am doing a test database migration for SQL Reporting Services (leaving the front end as it is). I have successfully moved the database using http://support.microsoft.com/?kbid=842425 as ref guide. I have also moved the databases that the reports uses to collect data from. I hav...more >>

I have a matrix report (Report1) with rowgroup and columngroup. Both contain also totals (defined as group subtotals). The number of rows and columns varies. Area1 Area2 Totals Product 1 10 12 22 Product 2 7 11 18 Totals 17 23 40 I also have another report where I can list thi...more >>

When i export a report to Excel, there are created some coluns and line that not appear in the report. These lines and coluns are smaller than the normal ones, but if i need to work with this file, a must have to delete each one. And athis operation is not easy. Thanks by your help. Pe...more >>

I have several parameters on my report, some have non-queried lists, and some have queried lists. All of them have default values. When I ran reports on the Report Manager, I changed the value of the parameters from the drop-down list to produce different reports. My problem is whenever I change...more >>

Hi, Please let me know how can I add a reference to my WebService in the Business Intelligence Studio for Yukon Reports. I would like my reports to be populated from a webservice method. Cant find any step by step information. Thanks, Shafia ...more >>

Does anyone happen to know if there is a maximum Number of report parameters supported? thanks -- Wayne Snyder MCDBA, SQL Server MVP Mariner, Charlotte, NC (Please respond only to the newsgroup.) I support the Professional Association for SQL Server ( PASS) and it's community of SQL P...more >>