I have a very simple query (below). I have tested in SQL Management Studio as well as the Configure DataSource in the Telerik Report Designer. Both return 19 rows of data. I added the ISNULL as those fields have the ability to be NULL and wanted to eliminate them from causing an error. If there is no parameter in query everything works perfect. When a parameter is filled in I see the title of the TABLE but the rest is blank. I know this is something beyond simple.
If I put in a default value into the parameter field on the table not even the header appears. The attachment shows how the Parameter is setup. Originally I was trying to pass the RegardingIdentifier (Guid) and through that was it so I modified the routine to use a string and still get the same results.
, ISNULL(Tasks.Priority, 'Normal') AS Priority
, ISNULL(Tasks.EstimatedHours, 0) AS EstimatedHours
, ISNULL(Tasks.PercentComplete, 0) AS PercentComplete
, ISNULL(Status.FieldName, '') AS TaskStatus
LEFT OUTER JOIN AppSettings Status ON Tasks.StatusIdentifier = Status.AppSettingIdentifier
LEFT OUTER JOIN Accounts ON Tasks.RegardingIdentifier = Accounts.AccountIdentifier
(Accounts.AccountCode = @AccountCode)
AND (Tasks.TaskComplete = 0)