Hi guys The Print control - printing directly from the Report Manager - have a default setting. Is there a way to change this default setting?? Our problem is that the default is 5*8 letter format whereas here we use A4 format. Preferable it would pickup the report format in regards to por...more >>

Hi, To test, I generated a few reports and I can go to http://servername/reports to see these reports. However, I have to log in (I'm using basic authentication in IIS 6.0 since this server will only be used for NetIQ internally.) as an administrator to view these reports. I'm not sure w...more >>

First let me explain what I mean by automated. I would like the report to change when the user changes the value of the report parameter without having to click the View Report button. Can this be done? I have a report that has a dropdown box and radio buttons, I would like the user to be able t...more >>

I am trying to export a report for SQL Reporting Services Report to Excel. Unfortunately the number of rows in my report are greater that the maximum allowable 65536 rows in an Excel sheet. Does anyone have a workaround that would allow for a SQL Reporting Services Report to be exported to Exc...more >>

Hey All, I've found another problem related to everyone's select all hack which is using a union and an extra check. I have a simple Customers drop down and I want to display the (All Customers) option. So, I took Reddy's advice and tried this: WHERE (Customer IN (@Customer) or '(Al...more >>

I'm working in VS2003 and building reports with SQL Reporting Services. My experience has been that when I set up a table to be sorted the sort is applied as expected, and when I specify grouping the data is grouped as expected, but when I specify both sorting and grouping, the sort specificati...more >>

I have a standard report with a bunch of fields and groups within a table. I've added a field for a running total: Field is amount_rt Definition is: =RunningValue(Fields!amount.Value,Sum,Nothing) The second I try to preview the report or deploy it, VS crashes. I figured it might be somet...more >>

I was able to change the chart legend to show the correct information. However, the words are too long for the column. How do I 1) Increase the width of the column 2) Make it so the Legend Rows can be taller I cannot increase the size of the chart, as I have 3 charts side by side with...more >>

Best case, I include the report date in the report header. Worst case, in the subject line of the subscription email. I'm using SQL/RS v2000, VS 2003, anybody know how I can do this? nothing crazy, just like this: ReportName xx/xx/xxxx -- Lynn...more >>

Hello, I have a text box in a table that has its text-decoration property set to Underline. The textbox has its value set from a column in a dataset. I have also defined the following as its Jump to URL expression: ="http://" & Parameters!WebServerName.Value & "/Policy/Reports/AdvisorA...more >>

Hi all, I am facing a problem with SQL Server 2005 Reporting services. I am unable to create a Report Project in VS.NET 2005 because it gives me an error saying “Could not load file or assembly 'Microsoft.ReportingServices.Designer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89...more >>

Hi I want to make a table or even a row to be visible on the first and the last pages only. Any suggestions on how to do it will be helpful. thanx ...more >>