I have a report that shows the past 6,12,18,24 (one at a time using drop downs) months of sales, with a different series for each salesperson. The problem is that the farther I go back, the more salespeople I have. The 24 month report has over 150 different sales people and the report gets...more >>

After searching and searching through this forum I have seen several similar questions but no answers for my question so here it goes. We have added front end screens for all of our reports. We also allow our users to create subsciptions using these screens. For dates, our users would lik...more >>

Ok, I have just developed the c# app and the rs report...how does my c# app open the report (and how does it pass parameters)? Thanks, Trint ...more >>

Hi all I am having quite a frustrating problem. I have an MDX statement that looks like this: SELECT { Measures.members } on Columns , NON EMPTY {{[Business].[User].[Business Entity Id].[1583].Children} * {[Time].[Calendar].[2002].[Quarter 2].[May]: [Time].[Calendar].[2004].[Quarter 3].[...more >>

I am just getting into SQL reporting services and I am looking into upgrading some Access reports with SQL reporting services. In the Access reports there was an interface that allowed the user to select some different options and then generate the report based on some of those options. To generate ...more >>

Hi, I've been following the newsgroup with great interest but this is my first posting. There are hundreds of messages regarding the following scenario: ASP.NET + ReportViewer.dll + Reports using sensible parameters + Subscriptions on those same reports + "I do not want to loose interacti...more >>

I am using a modified version of the Printing Extension that is in the SRS samples. On some boxes it works fine, on others the Reporting Server is generating an EMF file that is 4x as large as needed so when it is spooled to the printer, only 1/4 of the page is shown. I've narrowed down the issue ...more >>

When I try to open a report I was developing I get the following error: c:\inetpub\wwwroot\he_reporting\rptTargetRentalRate.rdl(4438): Deserialization failed: The table "table1" has rows that contain a different number of cells than the number of the columns in the table (including cells th...more >>

I have a parent report, whenever the user click a item, the user will jump from parent report to a corresponding section of subreport like a group section. How do I get such function? Thanks for your kind help....more >>

I want to write a Code block routine that returns the parameter Prompts and ValidValue that was selected from within the report. Can I access the ReportParameters collection (not the parameters collection, but the actual parameter definitions collection) from within a Code block? Thanks, --j...more >>

Hi I have a Requirement wherein the Report Should look like this........ Contacts: Name: Dave Henderson Phone: (654) 345-3923 Mobile Phone: (654) 343-9827 MobilePhone Fax: (654) 223-2323 Email: DH@yahoo.com Position: Buyer Reports To: Mik...more >>

Hi, I've been struggling with this problem for a couple of days. The RS system seems to be working fine. However only the administrators can open the reports. If a user attempts to open a report, a login window pops up. After pressing OK three times, a message "You are not authorized...more >>

In Report Manager I can see the page footers but when I tried to print these report (In html format) page footer is not getting printed. When I export same report to pdf format, It’s showing footer in it also. Plz guide on same ...more >>

I forgot where I installed my Report Server Database! Reporting Services is working fine but I just want to make sure we are backing up the database. Help!...more >>

I have the following code in my report: Protected Overrides Sub OnInit() Dim strTemp as String strTemp = Report.Parameters("PersonNameParam").Value End Sub For now I am just trying to get the value of the parameter, but when I try to preview the report I get the following error. "Faile...more >>

Does anyone have any commentary on reporting to email and/or fax? I noticed that http://www.fenestrae.com/ has a product that seems to support reporting to fax. Does anyone have any feedback/experience with it? I'm looking at producing account summary mailings/faxes to our customers in a bu...more >>

So I'm making a matrix report. It's driving me nuts, frankly. Here's what I want to do. __________|Item Code|Description | Column Group ----> Row Group| | | ------------------------------------------------------ ...more >>

I need to have text rotated 270 degrees from the standard starting position. How do I rotate the text in the VS.Net 2003 environment? Thanks, Kevin...more >>

I get the above exception when attempting to open an .rdl file with the Report Designer. It will open in the code view, however, I need the designer to properly form the XML in the RDL. The exception is thrown again when attempting to view the Designer from the Code View (Alt+View+Designer)....more >>

I have set up a data-drive subscription to do a null report on a report that takes 3 minutes to run. I have it set up to run at 3 am and it works fine. My question is when a user runs it at 6 am, does it use what I cached plus the new data, or does it re-cache the whole thing? This report...more >>

When I render in Excel, the Excel cells do not grow to accomodate the cell contents so data is hiding up, e.g. ABCD is not wrapping up as AB CD but showing up as AB if the column width is small. Anybody has seen this happen? How to overcome this? Thanks Sanjay...more >>

I get the following error when trying to pass a very large paramater through a url. The path of the item '/TCM Reporting/TCM_gridexport_Carrier2,061IPCE0^,4801^, Order By Line_lac' is not valid. The full path must be less than 260 characters long, must start with slash; other restrictions...more >>

Hi, I have RS and SQL Server on the same development box. When I browse to http://localhost/ I can see my reports on my box. However, when other users browse to my machine with http://mymachinename/ they get a Windows Login box pop up. When they type in their Windows Credentials, the box ...more >>

When I use a stored procedure for a dataset, is there anyway to capture output parameter values when the stored procedure executes? -- Thanks, CGW...more >>

I have a valid SQL Server 2000 license on a Windows 2003 Server. I have a VS 2003 licensed copy on my desktop. I have the 120 day eval CD set with the SQL Server Reporting Services Trail CD. I don't have an MSDN subscription. If I install the Reporting Services Trail will it automagically ...more >>

I've read several places that there isn't a way to localize reports at run time of a report, so I wanted to ask what is the "best practice" of deploying the reports if you have some clients that might want to view 'English' reports and others who might want to view 'German' reports. I'd like ...more >>

I am attempting to call a DB2 stored procedure from SSRS through the IBM OLE DB Provider. The procedure has 3 input parameters and 2 output parameters (I don't care about the results of the output parameters). Has anyone been successful doing this? If so, can you share the syntax that you used...more >>

Hello, I've been developing a matrix report in Reporting Services, and for some reason, pagination does not work. Instead of getting page breaks when the report runs over the page height, the report renders as a single page. PDF export seems to work fine (i.e., the pagination works correctl...more >>

Any help with this would be greatly appreciated. Thanks in advance. I have a field in my db that is a string field that holds numeric data (salesperson quota). My report is grouped as follows: Group Header 1 - Territory Group Header 2 - Sales Person (hidden) Detail - (hidden) Group F...more >>

Trying to install the report designer on a mchine running xp sp2 with vb.net already installed. During the inital portion of the setup it states visual studio.net not installed. What is it actually looking for?...more >>

I'm having a problem getting this iif statement to execute properly. =IIF(Fields!AlarmLevel.Value = 0, "", Code.rptUtilities.GetPeakLevel(Fields!ThresholdFormat.Value, Fields!SpectrumFormat.Value, CType(Fields!Spectrum.Value, Byte()), CType(Fields!Threshold.Value,Byte())) ) It se...more >>

Hi, Some of my charts have many data series on them and the colours can be difficult to differentiate. I would like to include a label on the actual line chart as the legend is not helpful - the colours are too similar. Is this easy to do? For an example see here: http://tinyurl.com/3k...more >>

I have .NET 2003, IIS, SQL server and Reporting services installed on my development pc. I have created a Report Project and can view the results in VB.NET - however when I try to Deploy I get the message that it cannot connect to http://localhost/reportserver Can you advise please.... -- ...more >>

Is there any way to show the count of a collapsed group on the row set to toggle visibility. For example, if I have rows for Purchase Orders and grouped under that, rows for line detail that are hidden with Purcharse Orders number as the toggle textbox, is there some way to show the detail l...more >>

I have seen that it is possible to render reports as gif image files, but have not been able to find documentation. What has to be added to the configuration file to have the image output as gif rather than tif? Thanks, Ed Fox...more >>

Does Reporting Services in any way offer justified text alignment?...more >>

newbee! question. Want to see sample reports that display the data in calendar format like outlook does. Example ... all appointments for the next 2 weeks arranged as a calendar. Thank you for your help in advance. ...more >>

Hi there, I have Visual Studio 2005 and SQL Server 2000 with Reporting Services. What Do I have to do, to get the ReportDesigner working with VS2005? If it's not possible, please tell me, when it will be available. Thanks. Betina ...more >>

I have a user defined parameter for my report. I would like to have the option to select all options instead of only one. I already created the query for the parameter and defined 'all' in the following way: SELECT per_initial = 'all' UNION SELECT per_initial FROM Table How do I then ...more >>

I have a report that uses a drop down for the user to make a choice. The report works fine when choosing only one selection but I need the user to be able to choose one or all choices. Can someone please point me in the right direction? ...more >>

I have the following problem with Reporting Services: My report has about 6500 lines and 100 columns. When I export it into Excel the size of the end file is about 20 Mb. As I have to send it using subscriptions, it is a problem – too large file for e-mail. Are there any ways to minimize t...more >>

Hi, I have intalled a evaluation copy of sql server reporting a week back. Everything was working, but now Report Upload option and Site setting options are not comming. Could you please help me out and tell me what went wrong. Thnaks -- Message posted via http://www.sqlmonster.com...more >>

I am trying to understand the basic security that RS uses. During install, a userid is used to install/create the databases. That userid is then tied to the basic services, like scheduling etc... Is this correct? Are all services using that first-supplied ID? After that when users run a...more >>

I am allowing users to create One-time Schedule's (via the Web Service API) with "Stop this schedule on" automatically being set to the next day. However, the Subscriptions list is never cleared for the report, even though the schedules are weeks past the stop date. This results in dozens of...more >>

How to render image in HTML reports? I have a webapp which invokes Reporting Services web service to generate reports in HTML format. The reports are for internet users - the image is not accessible to these internet users because they cannot access the report server directly which is in the...more >>

Does RS natively allow the application of Rights Management to reports as or once they are rendered, e.g. to a web site or into a pdf file? If not do you have any insight into how this can be done? Are there plans to integrate with RM?...more >>

I am trying to toggle the visibility of a simple bar by the value of a parameter named DETAIL. This is the expression used =IIF(Parameters!DETAIL.Value=true,false,true) When I view the report in .NET IDE it displays fine, when deployed to the target server I recieve the following error Re...more >>

Hello there, Ok, I did find some snipped of codes here and there however, I still haven’t been able to get it to work correctly. If it is true that people were able to overcome the jump out of Frame while drilling down when using a costume page and the ReportViewer component, could yo...more >>

Just starting to work my way through the Blackburn & Vaughn book to figure out RS. One thing I need to figure out though so that I can sell this thing to my boss: we have a SQL 2000 database that holds all of our study data. It looks like that makes us good on the licensing, and I was plann...more >>

I'll be quick and too the point... 1: I have a stacked area chart. 2: Percentages are the values being marked. Issue: I need to make the 100 mark (text and line) on the y-axis to be red. I've tried writing an expression to get at the current "label" for the mark. I keep getting the follow...more >>