Never done that before, but maybe you need to create an appropriate data source inside the report server folder where you have deployed your report?

Only thing I can think of.....

I assume that the report is using a Table, if so, click on the table to select it, then right click and select properties. In the properties window select the...

I assume you are using SSRS.....

You create a parameter in SSRS which is boolean, let's say this is called @Param

In your SQL Query you use the following

SELECT

T1.Field1

,T1.Field2

,T2.Field11

,T2.Field12

,T1.Field1 * T1.Field2...

This is a standard combination of Visibility/Toggle.

The thing to remember with the toggle is that the only symbol SSRS uses is a + sign, it does not give you a...

This is the a very simple form of matrix, the only way you can get this wrong is if you put your fields into the wrong place.

When you place a...

It sounds to me lik you shouldn't be using visibility and toggle at all.

Visibility: The purpose is to hide information that you don't want to see now, or don't...

Hi

As far as I know there is no way to directly achieve this in SSRS2005 and I've not seen any enhancements to this effect in SSRS2008. The way I...

Take a look through this article, I haven't read all of it yet but it would appear that this will cover your needs and more. I'll probably try working...

OK, I understand a bit more about what you need, let me do a little work on it and I'll come back to you.

Is this report ALWAYS going to print only a 12 month period (i.e. one year of data from Jan to Dec).

If the answer to this is Yes then I'd probably...

I think you should be able to achieve this by wrapping your invoice within a ListBox (from the toolbox in VS2005), the list box has it's own grouping property which...

Sorry, somehow the visibility expression went slightly wrong.....

IIF(Parameters!StartDate.Value '31 DEC 2008',TRUE,FALSE)

I still think you shouldn't need to use it though, the dataset should really take care of it...

1)Do I add the below,to all 3 datasets?

IF @StartDate >= '01 JAN 2008' AND @EndDate <= '31 DEC 2008'

BEGIN

select Name,Address

from dbo.Customer

...

Hi You could do the following

IF @StartDate > '01 JAN 2008' AND @EndDate <= '31 DEC 2008'

BEGIN

Select Name,Address from dbo.Customer where

...

The simple way would be to return a combination of ProdKey and SubKey as your parameter key, you would need both of these anyway when the parameter is passed...