I am using SQL Reporting services with Microsoft Dynamics AX using the
perspectives (model) objects. I noticed that my reports are showing old data
and I can't figure out a way to get it to refresh. I have tried restarting
the SSRS server - even that has not helped. I am guessing ...

I am trying to make a Report on SQL Server Reporting Services 2005.
Here I am facing a problem that is follows-
I have a two seprate database server Server1 and Server2 and from both
server have table1 on server1 and table2 on server2.

I have a report that needs to show three different counts in the first 3
columns.  This will be on a group header line.  The detail for the group
needs to show the data that is used to get the third count.  My report footer
needs show a sum of the three counts.

Good moring,
I am working on my first matrix report and trying to add in a total for a
group and rows
Table is as follows:

I have a report that has three columns: CUST_NO, AMOUNT_PAID, DATE.
If a customer has paid more than one times it shows that many entries in the
report output. For example:
CUST_NO   AMOUNT   DATE

I have a few Textbox components (amongst other things) on a report with 1 of
them using an Expression to control it's Visibility->Hidden property at
run-time.  The thing is when it is Hidden it causes the other textboxes
adjacent to it to move over to the left, but I want these ...

I have a report (in SQL Server 2000) in a web page that is very slow when it
renders the data.
The query is not so slow to justify this problem (running it in Query
Analyzer it takes only a few seconds).

Good morning,
I have created a report that I want to use a Report Parameter to provide
users with ability to select from drop down box to determine sorting.
1) Created a Report Parameter called SortOrder and added in various non

Hello RS world,
I've just made a clean install last week of SQL Server 2005 SP2 x64 on
a Windows Server 2003 x64 SP2 box, 2Gb RAM.  All SQL Server modules
are installed, but only Reporting Services is running. No other

Is it possible with Reporting Services to create a scatter chart
where the colour of the report area are dependant upon X or Y axis value?
For example: can I specify that if the point values are greater than
75 then the color of those parts shall be red? and other are green as an

We have a new install of RS2005 SP2 - when creating new subscriptions the
"To" field is disabled for users with "Manage Individual subscriptions" task
setup for their role. This works Ok for users with Manage All subscriptions
task.

I am using static variables in reports for custom aggregates. I built
a Hashtable object in C# to hold million rows of data from report
DataSet. The Hashtable is public and static, so other reports can use
it as well.

All of a sadden my report refreshes its interface every time I choose
something from dropdowns. Any reason for that?
Thanks

I have a report that can get null as a value for one of his
parameters.
I'm running this report in a reportViewer (WinForm application).
How can I send this report the value NULL?

Initially..a good morning all :)
I am a "new user" of RS..so please be gentle.
I have create a Graph based on a query that works well (big step for
me)..script below.