Hi , When I try installing SQL reporting services on Windows 2003 with Windows Sharepoint Services already installed, during installation it gives me a message similar to "Reporting components will be disabled. Do you want to manually enable them later". The installation completes su...more >>

Is this possible? I now that i can use custom application to do this, but is it possible to change semicolon as a default delimiter on server. Thank's in advance.. ...more >>

I've spent almost a week googling, blogging, attended the intro to Reporting Services training and still have not found a way to pass multiple parameters to a report (I don't want to run a report for one employee at a time, but let the user select multiple employees, then run the report and inclu...more >>

Hello, First let me describe the situation. I have win2003 server (name: SRV) where I have SQL 2000 Reporting Services installed, win2003 server with SQL2000 server (name: DBSRV) where I have a database and a workstation where I create reports in Visual Studio. When I am creating report...more >>

I have a master detail report that I'm having trouble with, I have the report layed out and populating fields in the master report with data, my report uses fields from the master report and passes it as parameters to the subreport, that's all working well, the problem is I only get data for...more >>

I have a master detail report that I'm having trouble with, I have the report layed out and populating fields in the master report with data, my report uses data from the master report and passes it to the subreport, that is all working well, the problem is I only get data for the last rec...more >>

Am I missing a trick here? When i set up my parameter in reporting services and hit preview, the prompt apears and asks for the specified column - however the sql generated is not refined any. it brings back all the data and then filters on the selected column in the report. By contrast in b...more >>

How can I get 90degree text orientation for matrix column headers?...more >>

Is there anyway possible to grab a snapshot via some vb.net or c# code and then export it to pdf, txt, etc...?...more >>

I have tried this in 2 different wasy: 1. By typing "onlinebenefits.xsl" in the Data Transform text box of the Data Output Tab in report properties. I preview the report then export to XML. 2. By using URL access - "http://lidevsql/reportserver?/EMReports/Extracts/Extract&rs:Command=Render&rs:...more >>

I have parameters that I programmically populate and don't want the user to see. I remove the value for Prompt in the Paramters dialog in the designer. After deploying the report I find in the Report Server that Prompt User is checked and the default prompt lable is the parameter name. I t...more >>

Hello Group. I have to do some reports, but the brequeriments are that the reports have dynamic graphs, can Reporting Services have dynamic graphs??? That's the end user can change between an pie or a bar char?? Tanks. ...more >>

Has anybody worked on a custom viewer for reporting services? the need for this came up because I needed imersonation on the report server. I called the web services from my custom .NET web app using custom credentials and was able to render the report perfectly fine. However, if the report has ...more >>

I have never wasted so much time trying to get a report designer to do what I need it to do, you can't put data elements in a page header without using a stupid from query parameter, which seems to slow everything to a snails pace and blow up the designer and send it into orbit, now I'm ge...more >>

I'm getting this message when I try to enter an SQL statement for a new report: "There is an error in the query. MinimumCapacity must be non-negative." My SQL statement is: "CALL GET_INSTALLMENTS_HEADER(?,?)" I've tried using both IBM DB2 Provider and HiT Softwares OLEDB/400 pr...more >>

We have a server machine running Window 2000, .net 1.1 framework and SQL server 2000 standard edition and it's a domain controller. We tried to install RS standard edition onto that server machine. At the end of installation, the message shows that Setup has successfully installed RS, but Se...more >>

Just ran into a strange error. I want to see what year and month it is today, like 200411 for November, 2004. I've added a textbox to show this, and set the value to ="Month: " & Format(Now(), "yyyymmmm") For some reason, this shows 200430, because the time is 09.30 on my computer. I've trie...more >>

Is it possible to schedule a report based on a flag or stored procedure completing. Currently have an overnight load process which must complete before the report starts. Any suggestions would be most appreciated --- Posted using Wimdows.net NntpNews Component - Post Made from http://www.Sql...more >>

Hello, I have a report that displays about 200 data records. There is no any group or subtotal in the report, but just plain data. It is built in a table. The report always generates two pages when it is ran, even though I checked "fit table on one page if possible" box on the properties of t...more >>

Hello all Am I missing a trick or does there seem to be a drawback in using parameters in Reporting services. They do not act the same way as for example a prompt in business objects . When a user specifies a value in a prompt in BO this will alter the Where clause of the sql behind the...more >>

We are building SQL Reporting Services for use within our company, what we are going to do is launch the reporting services from with in our Company intranet. We would prefer not to launch a new window when we do this, is there an easy way to add a link on the Reporting services page to link t...more >>

Hi - I am generating a table with large amounts of data. When I generate the report, the report looks fine but when I print preview it, every alternating page is blank with only the header and footer being displayed on every page. I have tried playing around with the page breaks with no luck. ...more >>

I have several reports that needs to be installed on report servers at different customers. Is there an efficient and not too time-consuming way of doing this? Ideally I would want to just connect to the server, copy the files to the correct directory on the server and run some (command-li...more >>

I'm trying to do something as follows: I try to pass some field values to a url and render it to a web application. I tried to do it with a javascript function javascript:if(window.open('http://server?id=' & Fields!ID.Value,'Popups','width=400,height=500,location=0,menubar=0,status=0,toolba...more >>

How can I upload several pictures at once to use in a SQL Report? There are over 6,000 pictures that I need available for a form letter that will include a picture of the product referenced in the letter. If I can load all of them at once into the project and reference them by name connecte...more >>

Hi, We are trying to find if it is possible to customize grouping with drill-down in a way as explained below. Any help is appreciated. Thanks. The structure of the data is such that a group can contain subgroups which in turn contain detail rows. However, in some cases a group does no...more >>

Hi! I tryed to run a report in browser but it didn't work. This is the URL https://uranus.memory.ro/Reports/Pages/Report.aspx?ItemPath=%2fProductie%2fReportName&rs:month=september&rs:year=2004&rs:Command=Render&rs:Format=HTML4.0 The report was displayed but the user must pick up the parameters ...more >>

Does anyone know if its possible to use report parameters as parameters to a data driven subscription query. This would be useful for changing the names of the files generated by the subscription according to the parameters passed to the report. For example, a report that takes a customer name...more >>

hi, i need to create a user interface for creating the schedule. i wish to create this schedule programmatically and use it to for subscriptions. how can i create the Schedule programmatically ?? need help on this, Thanks in advance,...more >>