Hi, I've created one multicolumn (Mailing Lable) Report. I want to arrange data across than down. I've used list control and set it's writingmode property to lr-tb. But it didn't work. It prints record down then across. How to get this kind of report. Thanks -- Thanks & Regards Malke...more >>

I just reloaded my SQL 2000 database and went to download the base reporting services and any license information... All I can find now is the evaluation copy and the SP2, no base product?? The SP2 is not the entire package? Where can I download the base software from? I still can run re...more >>

Hi friends! I have installed SQLH2 reporting and collector services and all of them work fine. I configured IIS WIth Reporting services with SP2 and uploaded the reports pages, the connection to the database seems to be well, but when i try to see some data (not happens with all reports) a...more >>

I am trying to append the date to each snapshot of the report that is deployed on a file share (e.g. RPT001 5-25-2005.xls). I tried RPT001 @ExecutionTime in the File Name of the subscription definition but this deploys the report as: RPT001 @ExecutionTime.xls Anybody any ideas? Thanks, ...more >>

I'm having problems with the SharePoint configuration on a REport Viewer web part. When Report Explorer and Report Viewer are used together, all is fine. This is just trying to configure Report Viewer as a stand alone web part. My direct URL path to a report is: http://server01/Reports/Pages/...more >>

We have several business areas that want to run a scheduled batch job to render reports in a pdf file to them. We seem to be hitting an issue with reports that take longer than 15 minutes to render. We get the error message, " The underlying connection was closed: Could not establish secure...more >>

This message has been asked before but not answered. I am generating a PDF with multliple subreports containing graphs. All is well until a certain level of complexity is reached, and the Export to PDF just hangs. Seems to be an all or nothing effect. Either the report generates to PDF wit...more >>

Is there a way to install SQL Reporting in a Virtual Web (which has an external DNS) on IIS6 so that it can be run like www.<external DN>.com/Reports ? I've installed it on my SQL server in the default IIS directory, but want to run reports in the virtual web. Creating a virtual directory po...more >>

The background: Before I get into my error let me give you some background in what I am required to do. All the text field parameters must be stored in the database. What I mean by this is every text box's value, background colour, font(weight, size and etc), TextAlign and TextDecoration info...more >>

Hello, I am using forms authentication to access RS. I can publish reports from the RS interface, but I somehow can not publish reports from within the VS2000. It asks me for a password and username and I supply those, but without an error message it asks me again and again, with no success...more >>

I'm trying to create a chart in Reporting services that compares, say, this years sales, with last years sales, one line overlaying another (effectively as different series). Trouble is, the date is represented along the x axis and if I try to put the 2 series on one chart, obviously the x axi...more >>

When I put a total beneath a column for which the "Hide Duplicates" checkbox is checked, the hidden values are still counted in the total. I don't want the hidden values to be counted in the total. Can someone tell me if this is how Hide Duplicates is supposed to work and/or suggest a possible ...more >>

Hi, I have used Jump-To report navigation in RS 2000 successfully to navigate from one report to another, passing a report parameter to the second report from a click event from a table in the parent report. However, when I try to do the same thing in RS 2005, when I set up the navigation jump-...more >>

Hi All, I need to get the following desing in a matrix.... --------------------------------------------------------------------- Revison Rev1 Rev2 Rev3 Rev4 --------------------------------------------------------------------- Totals ---------------...more >>

We have very long names for our series that appear in a chart legend so they appear cut off with an ellipsis (three dots ...) at the end. We noticed though that if we specify a \n in any one of the series names then they will all wrap over two lines! Ideally we would like the series names t...more >>

It seems reporting services cannot accept foreign lang (eg. Chinese) when pass parameters via URL? Is there anybody tell me why or How? ...more >>

I have a lengthy string which has to be passed as Image datatype to the report so that it is not truncated. Can it be possible ?? chans...more >>

Hi, I am still having some problems with Localisation assembly. It is to do with CAS. I have granted FullTrust to all the possible resource files in the server config, and they work fine on the production server when it is in the MyComputer Zone (http://localhost/reports). When I access...more >>

Hi All, Please let me know of this problem. Can I have a static row in a matrix?? The design of the report should be like this Matrix Header Totals : Static Header Row1 Row2 Row3 Labor : Static Header Row4 Row5 Row6 The number of rows in each section ...more >>

How do a change the alternate rows within a group. ie i am grouping in a product type that also has a product numbers & value on the same line. Since there is more than 1 product type there is multiple rows within the group. I have tried the formula iif(rownumber(nothing) Mod 2, "Red", "Wh...more >>

Have the following script. After checking it breaks on the function. Am I invoking the function correctly in the script or not. Or is there something else wrong with the script. SELECT 'Dear ' + n.FirstName AS Salutation, 'RE: WHOLE HERD TB TEST FOR YOUR CATTLE HERD NUMBER ' + CONVERT(v...more >>

In the report manager you have the option to export to PDF which pops up a windows that has a timeout encoded into the URL that generates the PDF. The URL generated looks like: http://localhost/Reports/Reserved.ReportViewerWebControl.axd?Server=http%3a%2f%2flocalhost%2fReportServer&Timeout=10...more >>

Hi I have beening trying to build a report with 2 parameters. When I run it under VS.net preview, it all went well, but after I deploy it to the server, I got the message as following: **Reporting Services Error--The path of the item '' is not valid. The full path must be less than 260 c...more >>

Does anyone have any code to run a report and email it. I want to run the report that has one parameter and then email it. With the report as the Body of the email and then the same report as an attachment in pdf format. I would like to also add some text to the email in front of the report. O...more >>

Hi, I want to pass, logged in user name, as a parameter in the report without user knowing or entering it. How can i do that?. The Idea is to pull the information based on logged in user. Any help would be highly appreicated Regards, ...more >>

Hi, I want to add more fields in report list. So instead of just showing the report name and description, I want hyperlink to some other information as well. Is it possible? if so how can I do that? Any help would be highly appreciated Regards, ...more >>

I want to install Reporting Services to find out about how it works, but I'm having problems. I tried to install it on my Windows XP workstation to run with MSDE but got the message: "This edition of the Report Server Database is not supported on the edition of SQL Server 2000 you have c...more >>

I'm a .Net developer and we'll be installing Reporting Services next week. To schedule reports to be sent via email, does RS require SQL Mail in SQL Server 2000 to be working to send the reports? Thanks in advance for your help. Richard ...more >>

Please Help. I am calling a stored procedure which creates a SQL statement and then runs exec (@SQL + @Where + @Order) Is there anyway to manual create fields. The Stored procedures returns the same column names and number of columns? -- Thanks, Jon A...more >>

I have a report in which I need to display an Image in the header, that is coming from Database or sometimes an alternative text in place of the image. Both ways I couldn't do it. Case Text: I have tried several ways such as using ReportItem Parameters, but the problem is the text is displaye...more >>

Just installed SP2 and started experimenting with the print functionality. The size of the print jobs are huge. I had a fairly simple six page report with a spooling size of over 100 mb, a single page over 17mb. Is there anything that can be done to reduce this size . If not, we will not b...more >>

Our database is normalized to the point that I need to build a dataset to render a report from. The code to build the dataset has logic that I would like to keep in a custom assembly. What is the best way to call that code and have it pass the dataset back for use by the report? Thanks, ...more >>

Got a dataset that is used to populate a table. Want to alternate the background color on every other row in the displayed detail group. Easy enough right? Here's the catch: the output is grouped at display time. A query output might be: KEY Value1 Value2 A 0 ...more >>

Hi I'm using Visual Studio Beta 2 I have few questions about the ReportViewer WinForm Control. When rendering a Server Report the Print button appears disabled is this by design? Also the Print Preview button is enabled but it does not do anything is this also by design? Any help is app...more >>

Hi all, I am designing a system that will be exposing reports to the internet via a link provided from within a .Net application. We want to use Dynamic SQL because the end users building the reports wont be able to implement stored procedures. Are there any security reasons not to do thi...more >>

I have only been using Report Services for a short while and my boss is now taking an interest. He has a couple of questions. 1.Is it possible to amend the 'Home'page slightly eg by adding the company logo to the header and having different icons for the folder structure? 2. I know it is p...more >>

Is it possible to use the Data Source in the Code section? If so how? ...more >>

Hi, i've been working on this report for the whole day now and have come to the conclusion that this can't be accieved with Reporting Services SP1. Or maybe i'm wrong... I'm trying to display a report like this: -- Group 1 ---- SubGroup 1,1 ---- SubGroup 1,2 ---- SubGroup 1,3 -------...more >>

If I want to use a custom authentication model on my reports but I want to use a customers already existing report server, how can I best accomplish this without intefering with the customers current authentication model? Shall I install a new report services installation on the same machine,...more >>

Hello, We are using SRS2005 (April CTP) for a new reporting system. We are using a hyperlink navigation action on a chart to go to a new report in a new web page, and when we do that we're gettng the error "Unable to locate control: ctl00oReportCell". The URL we are using is with the "rc:T...more >>

Hi, I have a stacked column chart and i would like to plot one of the series as line. Can't seems to find any way to achieve it. Is there a workaround for this? Below is the sample data. (X Axis: Date, Y Axis: Orders, Series Group: Item) Date Item Orders ====== ===== ====...more >>

Hi All, I have a report with 6 tables - only 3 are visible at any given time (depending on the users requirement). The reports stored procedure takes 60-120 seconds to run when executed stand alone depending on the load on the server. The report runs fine in the Dev environment - although ...more >>

Hi, I encounter a problem when setting a subscription in rs(with sp2) : Failure sending mail: The server rejected the sender address. The server response was: 503 Authentication needed for local user. this is my configuration in rsreportserver.config: <Configuration> <RSEmail...more >>

Hi, I currently have a report that displays a chart among other things. If the report is called but no data is available for the chart i get a big block of white space. Is it at all possible to display something in it's place rather than just nothing at all if there is no data for the chart to ...more >>

Hi all, My daily question is: I have a report with two data sets, First dataset gets the top five performers and the other dataset gets the bottom two performers. I want to diplay each data set result on table of its own on the same report. meaning I want to drag two tables on the repor...more >>

I would like to do a email subscription but the Email option doesn;'t show up in the delivery methods. What needs to be enabled to allow this option? Cheers Brian...more >>

How can I make a row in a table shrink or collapse when there's no data for that row? I have a table with several detail rows in it. the bottom row has 2 cells. the first one if for a label and the second one is for the data. cell 1: =iif(len((Fields!Id_Assignee.Value))>0,"Assignees",...more >>

In a table im populating I have to leave a data cell blank depending on the value retrieved. eg. if the breed type is deer leave the cell blank. Do i use an Iif function for this or not. And if so how do I write it. Total sqlnewbie here. I have this so far.....Iif(Fields!Breed.Value ...more >>

I have a few required parameters listed at the top of a report. I want to make it where when one parameter is chosen in the drop down menu, the other parameter(s) limit their choices accordingly. I can't seem to find a way to do this though. Any help would be great. Thanks. ...more >>

What is the best way to move a folder in reporting services from one server to another. The folder contains reports, data sources, images, and subscriptions. I dont want to move the entire databse....more >>