Our company head office is in LA. But we have global operations. Users create sales orders and purchase orders across the globe and all data in stored on the SQL server in LA. But our users wants reporting in their local time meaning a user raising a sales order on 1st Oct 2006 in Japan at 8 AM ...more >>

aCan anyone point me iin a right direction. I have 3 Security groups created in our Active directory system. I cannot get the members of these groups successfully authenticated to the Reports Server. here is the break down: In Active Directory Group Name: MD.ALL.HRA Members: John Doe J...more >>

Hi All: When i am trying to save the report (http) as PDF format, how can i make sure the format is what i want? Becuase currently what i got is that it splits report to two pages by saving PDF, and each half as one page, which is actually one page content. Any helpf will be appreciated...more >>

I have a report that is being displayed as a web page, and I've also got a "Printer-friendly" button to call the same report generates as a PDF. However, due to the business needs of the application, we need to add an additional footer with copyright information to the bottom of each page in th...more >>

hey. I've got 1 copy of BIDs open... and I'm working on this project / solution ; etc I open a specific dialog box; and I want to go and lookup this property (because the popup for parameters has the focus).. so I pull up another copy of BIDS; i look the 2nd copy of BIDs for the answer that I'm ...more >>

I'm using Visual Studio 2003 and RS2003. A VB .Net applicaion concatenates several string values and passes the resulting string to the report via url integration. This parameter is likely to contain a long string and I'm concerned about limitations of the url. Do you know if there's a l...more >>

On my form I have a web control that shows my report services report. When I click on the printer button I get the error "An error has occurred trying to get the current window.", then the next error, "A Runtime Error has occurred. Do you wish to Debug? Line: 25 Error: Marshaler restriction: ...more >>

I am in the process of migrating all of our reporting needs to RS 2005. Everything is going good, however I do have some issues deploying reports. We have many reports and I would like to keep them all in one master project file in VS.NET but deploy them to different folders to help users find...more >>

I am trying to produce a report with the page headers always showing. If the result set is empty I need to add a "No entries found for the selected criteria" line below the headers. If I use the NoRows property it does not include the headers in the report, which is a requirement. Is there ...more >>

Is anyone aware of a problem with the propagation of the role-based security settings in Reporting Services 2000? I have an AD group named RS-ReportingServices which has access to a report folder "Shared Reports" in Reporting Services. I have a report in Shared Reports named QuickReport tha...more >>

Hello Everyone, I am new to reporting services and am trying to Deploy my RS project to a SSL secured website. I am getting error "Could not establish trust relationship for ssl/tls secure channel". I did check the box ssl. I other thing I noticed is when I go to the configuration surface f...more >>

Ran into a problem with linked reports not printing correctly when the original report printed fine (SQL RS 2005 SP1). Found a posting in this newsgroup (http://msdn.microsoft.com/newsgroups/managed/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=a5b93fe8-47ec-4e94-932b-9971d8a6f...more >>

Hey guys/girls, I was wondering if there is a way to store the report query results into a SQL database for use within an application. I would like to have the query information used in the report updated to a SQL table for later use. The other catch would be to deploy the information to ...more >>

Hi All, I have a requirement where I need to create a report book (7 reports) making use of RS. The challenge is that the client need this in excel. A button on the intranet must generate the excel output. Has anyone done something like this as I can't find any docs on RS and excel outpu...more >>

How do I get the 'Totals' column in a matrix to appear on the left, just after the row headers instead of on the far right?...more >>

hello... i'm using SSRS2005 i 'm wanna know how to substract day? let's say 21/02/2006 minus 20 days..which result to 01/02/2006 (dd/MM/yyyy) what is the solution? i want to put it at expression.. that's aLL.... ...more >>

Hi, We are currently working on a project where we need to have all our reports to have a common style (Reporting Services 2005), but we struggling to find out how to find a way where we can have a common style implemented for all our reports. For example if I need all tables to have t...more >>