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

[Hunter]

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?

[Stef]

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