Sounds crazy but the name is def correct? Also, can you provide a screen shot of the error when trying to use preview?

using the following as test data

DECLARE @TestData TABLE

(

WhatData NVARCHAR(10) ,

SomeValue BIGINT

...

Here is my take on this with the sample data below

DECLARE @TestData TABLE

(

EntryNumber INT ,

...

What do you mean by the filter is not working? Can you show some sample data, expected output and what is actually being output and I will have a...

have you tried wrapping it in an IF statement?

=IIF(somecalculation > 0,somecalulation,"")

or

=IIF(ISNUMERIC(somecalculation),somecalculation,"")

Is the subreport inside or outside the Matrix? If in the matrix have you on the sub report properties "Keep Together" property set to True or False? And also...

I would personally NULL city when not in USA. See examples below

DECLARE @State NVARCHAR(20) = 'Not In USA'

DECLARE @City NVARCHAR(20) = NULL

DECLARE @TestData TABLE

(

...

Had a quick look and does the following link shed any light on your problem as a potential solution?

http://stackoverflow.com/questions/13076761/get-ip-address-of-user-client-viewing-report-in-ssrs-2008-report-manager

Can you provide some sample data and I will have a look at this for you. Until then, I will make an assumption:

You could re-write / write a query...

Something like this?

Design the spark line as a sub report with the second data set in it and use a parameter for the metricname and it should work and a...

Left outer join and a couple of isnull should do the trick unless there is a better way?

SELECT p.dbpatid ,

p.dbadddate ,

...

You just need to put a tablix on the report pointing to your data set, create a group on the ID and then another child group with the audit description....

For this kind of thing we have used SSIS to bcp the file out and set the relevant paths and file names etc and works quite well.

http://technet.microsoft.com/en-us/library/ms162802.aspx

You could also use the Wingdings font

=iif(somefield = somevalue,þ,¨)

[font="Wingdings"]þ[/font]

[font="Wingdings"]¨[/font]

Is the attached the kind of thing your looking for?