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 >>