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

Having trouble populating checkbox values which can only be done through a separate table.

1 Answer 16 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Hunter
Top achievements
Rank 1
Hunter asked on 23 Jul 2013, 07:59 PM
I am connected to a SQL DataSource and I am using a stored procedure to populate all of the basic info for my report. All of my textbox fields are working great. I have about 5 checkboxes in the Categories section of my report. What would be the best way to show which ones should be check and not checked. I can't do it through my primary Entity because I have to pass in the CategoryID. CustomerCategories is the table all of the info is in. All of the primary info for my report is coming from the Customers table. (my Reports_CustomersGetList stored proc). Can anyone make an recommendations on how I can possibly use a function to do this?

1 Answer, 1 is accepted

Sort by
0
Stef
Telerik team
answered on 26 Jul 2013, 01:33 PM
Hi Hunter,

Since the data seems related, test if joining the table in your stored procedure is an option for you. Then having the flag from the second table you can set the required CheckBox item's state. On report level, you can use a user-defined function in binding to the CheckBox.Value property. Thus you can get the value from outer preloaded with CustomerCategories records DataTable object for instance.

Another option is to use master-detail report and pass the needed ID with parameter as illustrated in our Invoice demo.

If you need further help, please elaborate on your report structure and used data. Feel free to open a support ticket and send us a sample project illustrating your requirements..

Regards,
Stef
Telerik

Have you tried the new visualization options in Telerik Reporting Q2 2013? You can get them from your account.

Tags
General Discussions
Asked by
Hunter
Top achievements
Rank 1
Answers by
Stef
Telerik team
Share this question
or