Hi there Im a newbie to Reporting Services and am trying it out on SQL Server 2005 I went through the installation process for Reporting Services and installed a sample database from the Microsoft Press Book on Reporting Services. I tried to navigate to the following location : http://l...more >>

Hello, I'd like to print SQL Server 2005 reports automaticaly within VB6. For example, a clic on a button on a Client.frm form should print the Client's name, list of commands, ... I've tried something with the IE ActiveX control, but it seem's that I can't control the render when there are sev...more >>

Hello Friends, i have sql rs2005 and need custom rendering Excel extension, some sample? Tks My problem is group cell in excel by default extension. -- ------------------------------------------------------------------------- Microsoft M.V.P en SQLServer SQLTotal Consulting - Servicio...more >>

Hey all; I have an install of Reporting Service running on a dev box and pointing at our production Reporting Services database. My hope is to configure this instance to integrate with Windows Sharepoint Services 3.0 and have another instance that's not integrated. The problem that I'm ...more >>

I am working on a report that is a vendor forecast and need help on adding the same items qty's for a particular date. If the results are on the same date, I need them to be summed up. Check out the results I have now and what I am looking to do. What logic would I use to do this? The re...more >>

Hello All, I am currently creating a Reporting Services report whose total page width is 33in. I use three data tables to simulate one very large table. My issue is: When I export this data to the EXCEL format, tables two and three are not visible past the first sheet. Is there something...more >>

Does anyone know of a way to add MIME types to the export list. I would want to add plain text and maybe a few others. A third-party add-on would be exceptable too. Thanks in advance, Tj ...more >>

Hi Can i connect using ODBC data sources in SQLServer 2005 Reporting Services, Workgroup Edition? The option does not show, only SQLServer. AFAIK only the Express edition has this limitation. Thanks in advance Manuel Gomes ...more >>

I am having some issues with displaying SQL 2005 reports in IE. 7.0. The right portion of the report is getting cut. Here are my report properties: Page Width: 7 in Page Height : 11 in Left Margin : 1 in Right Margin : 0.1 in Top Margin: 1 in Bottom Margin: 1 in The same repor...more >>

I have a standard report that I would like to use over and over. The difference for each version is the WHERE clause on the dataset SQL. I tried using a parameter and sending in the information but it doesn't seem to work. Perhaps I am formatting it incorrectly. Any suggestions? Can I do ...more >>

Ok, I've recently begun to migrate a control I wrote that fetches a report via webservices and renders to web. it would appear as if the report is being rendered within a div called oReportDiv, which takes a style of "overflow:auto;" I would like to either remove that style completely, o...more >>

I have searched high and low and cannot find a working example of using OPENROWSET to connect to an access datasoure WHILE using a system database. I have seen lots of examples where the system database property is ommited, but I need to connect to a database specifying the system database so...more >>

Is there anyway to access the fields collection using an index? e.g,. =Fileds(0).Value ? I want to create a calculated field based on two columns (position 1 and 2) in a matrix report, but their column names change based on the dates as paramaters. Any ideas? ...more >>

I'm really liking Visual Studio report developer. I would like to use this with our web application, but am trying to figure out if/how I can allow the user to run a report on the database that they are assigned to from the web application. In other words, in the ASP.NET web app they are using, ...more >>

How do I display only the top 20 rows in a group in a table? I tried using RowNumber but must have done something wrong. It was working on the data as a whole, not on the group-specific counts. Thanks. Stephanie...more >>

Is there a way to automatically collapse or hide the Report Manager header bar, the one with SQL Server Reporting Services > Home on it? Stephanie...more >>

I have a machine with Sql Server 2005 running the Reporting Services. The server runs both the front-end and back-end. I change the machine name after installation of Sql Server 2005 and the Reporting Services. I subscribed to a report, but the report is delivered to me with the old machine...more >>

Hi all Whats the deal with Visual Studio 2005 crashing out every time. I get it when working in all types of BI projects (Reporting Servcies, Integration Services and Analysis Services). Its starting to become annoying and work gets lost....more >>

Can anyone give me guidance on how i go about creating a report that can receive a value from an sql trigger and send it via e-mail? Thanks...more >>

Hi Experts, I am working on SSRS 2005. I want to implement security for each folder for different users on my report server. I have 6 different folders on my report server and I want that any person can open them after entering a valid username and password. I want set different username an...more >>

hi there, Anybody know how to create a letter using Sql Reporting. My report format is given below please advice which tool item i should use and how to justify the letter body. where xxx is from database Dear Mr xxxx xxxx is pleased to confirm the receipt of the sub amt for the xxx pr...more >>