This is a migrated thread and some comments may be shown as answers.

Broken Parameters

1 Answer 13 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
John
Top achievements
Rank 1
John asked on 14 Mar 2018, 02:36 PM

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 . 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 () and through that was it so I modified the routine to use a string and still get the same results.

 

SELECT 

  Tasks.TaskIdentifier
, Tasks.RegardingIdentifier
, Tasks.StatusIdentifier
, Tasks.TaskNumber
, Tasks.DescriptionShort
, Tasks.StartDate
, Tasks.DueDate
, ISNULL(Tasks.Priority, 'Normal') AS Priority
, ISNULL(Tasks.EstimatedHours, 0) AS EstimatedHours
, ISNULL(Tasks.PercentComplete, 0) AS PercentComplete
, ISNULL(Status.FieldName, '') AS TaskStatus
FROM 
Tasks 
LEFT OUTER JOIN AppSettings Status ON Tasks.StatusIdentifier = Status.AppSettingIdentifier
LEFT OUTER JOIN Accounts ON Tasks.RegardingIdentifier = Accounts.AccountIdentifier
WHERE 
(Accounts.AccountCode = @AccountCode)
AND (Tasks.TaskComplete = 0)
ORDER BY 
Tasks.TaskNumber

1 Answer, 1 is accepted

Sort by
0
Accepted
Todor
Telerik team
answered on 19 Mar 2018, 12:56 PM
Hello John,

The screenshot shows configuration of a Report Parameter. Have you linked the Report Parameter to the corresponding SqlDataSource Parameter?

You can check how to do it through the Report Designer in the '4. Configure Data Source Parameters' section of the SqlDataSource Wizard article, or
programmatically in the Using Parameters with the SqlDataSource component article - Binding SQL Query Parameters to Report Parameters section.

Regards,
Todor
Progress Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
Report Designer (standalone)
Asked by
John
Top achievements
Rank 1
Answers by
Todor
Telerik team
Share this question
or