I have a report where the customer is the rows and each column is a month o
total sales. it works, but I am show ALL the dates when I want to limit it to
the last 12 months as of today. I am not sure how to do this.
Any help is appreciated.

In sql server report 2005 (SSRS 2005), I will be generating some reports
that may not have any data selected at times. This can you can tell me how
can you display a message like 'The report is not generated since no records'
were selected for this report. Can you tell me how to ...

SQL 2005
I'm brand new to Reporting Services, but have been a SQL developer for
years.  Up to this point all my reporting has been done using Crystal
Reports.  I'm trying to convert some existing reports from Crystal Reports

I want like to know how to do the following in sql server report service 2005:
 1. Setup a main report and have it pass selected parameters to various
subreports.
2. Setup a table of contents for a report that has a main report and

I am doing a column chart in SSRS 2008.  Is there a function or a way to
mouse over the bar and see the data value of the column.  I see there is a
way to show the value in the bar but I want to be able to mouse over it
(value appears then disappears) like in excel.  Is this ...

Does anyone know how to set up the Connection string for the Datasource
inside Business Intelligence Studio to point to a Model deployed to a
Sharepoint WSS Deeply integrated Report Server. Also I am getting strange 260
character limit errors reported when I use the previous ...

Is MS Reporting Services capable of adding new kinds of charts like a pareto
chart?  If so, i'd like to find out if there's one that plugs in to VS .NET
2003 designer and MS Reporting Services.
Dundas does make a pareto chart in their enterprise charting package.  They

I have a report ath I had setup the Document Map Labels, but I've removed them
and don't want the Documnet Map side bar to open up automatically in SRS.
WHat can I do?  I WON"T GO AWAY??? :)
THanKs!, Bob

Is it possible to extract AD information of the user running the SSRS
report?  Currently only UserID is available.
For example, I would like to extract the user's primary e-mail address in AD
and use it to lookup other details from our HR directory (exposed as web

Is there any alternative in SSRS 2000 for the NEXT function of Crystal. Or
can someone provide a code snippet or logic for the same.

stored procedure 1:  exec getcolor @color = blue....this runs fine.
stored procedure 2:  exec getcolors @colors in('red', 'white',
'blue').........bombs
code is

I was wondering if it is possible to join 2 different datasources in
Reporting Services.

I am unable to deploy a report to my local report server. On my Window
7 Professional machine the reporting service is running, I am in the
local administrators group on my machine, and I have administrator
rights on my SQL Server 2008 Standard installation (a full

Can sql server reporting service report 2005 rdl be displayed in sql server
report service 2008 without doing any conversions? If so, are there things I
should be aware of that might cause a problem? If not, can you point me to a
URL that will show me how to convert sql server ...

I have a Reporting Services server that I needed to put Integrated Services
on.  After the install my Reporting Services no longer works.  Get the old
"target machine actively refused" error.  Nothing relating to that changed
that I am aware of.  Reporting Services Configuration ...