Hello how can i sum date? eg. getdate + 1.3 months thanks ...more >>

We have many reports where we have date parameter for a begin and end date. When users either type a date or select it from the calender, it is causing the screen to refresh when they are done with that field. This is very anoyning to the users and is turning them off to RSS. Is there a set...more >>

I cant find the forms authentication samples for srs 2005 C:\Program Files\Microsoft SQL Server\90\Samples\Reporting Services\Extension Samples\FormsAuthentication Sample ...more >>

I want to create a horizontal table as follows: Ingot 12345 12345 12345 Traveler 98786 87657 77675 Pieces 15 20 12 Step 1 x x x Step 2 x x x Step 3 ...more >>

I understand that SSRS only works with windows security and not sql. Does the windows account need to be created on the sql server in security logins? What is the minimum security for the windows account on sql if so? I am trying to get a few windows authentication accounts access to a rep...more >>

Hey guys I have the following in my SQL statement: DATEADD(hh, @hours, @startTime) hours is an integer and startTime is actually a string, but the thing is that this statement works fine if I use it like this: DATEADD(hh, 8, @startTime) The first version is what I need so that the us...more >>

I loaded an .rdl file into reporting services. The .rdl file needs to display the following text "domainName/norman" in the <label> when displaying the results of a query in a chart. It looks like reporting services is manupulating '/n' in the text as a newline character and hence breaki...more >>

I have a web app where I am using 2005 Reporting Services with ProcessingMode of Local. The ReportViewer is not showing the print button. I've looked through messages and found that printing was not supposed to be available. However I thought I read that printing functionality was supposed...more >>

Why do all the export formats I try result in chopping my report in half? I have not adjusted the standard width of my report (10.25 in) and it ought to be a simple matter to fit it into Adobe. You would think they could come up with a better default than this. ...more >>

Hello, Is there any way to expand a pie chart legend so the legend description is not truncated? Thanks in Advance! ...more >>

Hi, I have created a report parameter with multi-value option. In preview mode i can see "Select All option" but once deployed i can not see that option over web. any idea? Regards, Sri ...more >>

Have then following error after removing reporting services from our sharepoint 2.0 server. The RSWebParts, Version=8.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 assembly specified in a Register directive of this page could not be found. When I go to the Web Parts Maintenance ...more >>

I am new to SQL reporting and am trying to use two datasets in one report using Visual Studio 2005 Both datasets are from SQL databases and are added to the report fine i can also drop fields from both onto the report the problem i have is how do i link the 2 datasets so i can pull data from b...more >>

Hi there We have an emerging set of demands for reporting services 2000 and reporting services 2005 for at least two applications and frankly I too little about it but am in the position of having to make some decisions pretty quickly without the time to play around and experiment. We have t...more >>

Hello, Environment: Win2003 server SP1, IIS 6.0, SQL Server 2000 SP4, Reporting services 2000 SP2. Reporting services using account of sql server authentycation with logon name of 'sa' and password. Executing reports from manager working fine, but timed subscriptions failing on execution ...more >>

I would like to put the names of the colors into the database to allow users to configure how they want a matrix report to appear. I don't think they are standard HTML names are they? Can someone point me to where can I find this list of names, or any other advice with this endevour? ch...more >>