Have a look at the Inscope-function:

Without more information it's hard to give an example but it shoud look like:

=IIF(INSCOPE("Groupname")

, Fields!UsageCount.value/Fields!NumberDays.value

, Fields!UsageCount.value/Fields!TotalNumberDays.value)

In the table properties check tthe "Header should remain visible while scrolling"- check box.

For a matrix check the "Group header should remain visisble while scrolling" - checkbox of the group...

You could use a SSIS package as your datasourcetype.

You might want to replace the dot in the time columns.

DECLARE @date DATETIME

DECLARE @time CHAR(5)

SET @time = '07.45'

SET @date = CONVERT(DATETIME,REPLACE(@time, '.', ':'))

SELECT @date

SELECT LEFT(CONVERT(VARCHAR,@date,108), 5)

Use the cast or convert function in you SQL query.

Unfortunately this isn't supported yet.

See link:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=725904&SiteID=1

Hopefully rich text will make it in SQL 2008

Hi,

I've had the same problem: enabling Agent XPs didn't help.

I've managed to fix it by repairing the Native Client setup:

-Select "Run the SQL Native Client Installation Wizard" in the setup...

Try the Switch function:

=SWITCH(Fields!new_Region.Value=1, "West",

Fields!new_Region.Value=2, "Central",

Fields!new_Region.Value=3, "East",

Fields!new_Region.Value=4, "Atlantic")

See AutoRefresh in the report properties.

I found the a solution:

The shared schedules are created as SQL agent jobs. The name of the job is the ScheduleID that is associated with the schedule name in the...

Thanks,

I can't change the source tables. The only way I can get it to work is create a temp table with a identity column in the dataset and join...

Table should like the attachment.

You could use Gert Drapers extended stored procedure. Works fine!

http://www.sqldev.net/xp/xpsmtp.htm

BOL stands for Books OnLine. Don't touch MS SQL without it!!;)

http://msdn2.microsoft.com/en-us/library/ms130214.aspx

Or download it:

http://www.microsoft.com/downloads/details.aspx?familyid=BE6A2C5D-00DF-4220-B133-29C1E0B6585F&displaylang=en

The tutorials are in BOL.

Try this:

Create a variable with datatype object and name varResult

In the general tab set ResultSet to 'Full result set'

In the result set tab add a resulset named '0'...