Hi,
I have to create report of an activity of a user of a group., therefore I created form with groups of users binded from table (in a combobox). For this i should view users of a group in second combobox. After choosing this, report should be rendered... There's a little problem, I could not manage to bind those two comboboxes together in a stimulsoft designer. I've got all datasources connected via relations: Users (groups) -> GroupMembers -> Users (members).
How can it be done?
Binded comboboxes
Binded comboboxes
For binding DataSources to the ComboBox you can assign appropriate DataSource.DataColumn to Items property in DataBinding section in Property Editor or 'by hand' to the appropriate standard .Net Combobox in the Control property of the StiComboBox component in the report.
Attached report illustrates assignment of the DataSource into the Items property. Please open it in the Demo sample application.
In the Control property of StiComboBox in the report a standard .Net ComboBox is assigned, so you can also add items to it directly in the same way as it is possible in .Net.
All data in the report's Dictionary is converted to DataSet. If you have relations between DataSources then you can use them for selecting of necessary child records for appropriate Master row. Access to underlined DataTable is very simple:
MyDataSource.DataTable, where all data and relations are available.
Please let us know if any additional help or example report are required.
Thank you.
Attached report illustrates assignment of the DataSource into the Items property. Please open it in the Demo sample application.
In the Control property of StiComboBox in the report a standard .Net ComboBox is assigned, so you can also add items to it directly in the same way as it is possible in .Net.
All data in the report's Dictionary is converted to DataSet. If you have relations between DataSources then you can use them for selecting of necessary child records for appropriate Master row. Access to underlined DataTable is very simple:
MyDataSource.DataTable, where all data and relations are available.
Please let us know if any additional help or example report are required.
Thank you.
- Attachments
-
- 72.ComboboxExample.mrt
- (15.37 KiB) Downloaded 187 times
Binded comboboxes
Ok, but I need to make something like master-detail informations in 2 comboboxes. First one is master (filled with group names) and second one detail (filled with user names of currently selected group). Data source table Users got user and group names, data source groupmembers got group_id and member_id. Data relations are:
Users (id group_id) --> GroupMembers (member_id id) --> Users. In an example of combobox is getting information from one combo, which I manage to retrieve, but trick is to bind one (master) combo to the other (detail), which is still a mistery to me.
Thanks
Users (id group_id) --> GroupMembers (member_id id) --> Users. In an example of combobox is getting information from one combo, which I manage to retrieve, but trick is to bind one (master) combo to the other (detail), which is still a mistery to me.
Thanks
Binded comboboxes
Please see the attached report. This report works in Demo sample application and fills up the ComboBox2 after another 'Master' record is selected in in ComboBox1.
Thank you.
Thank you.
- Attachments
-
- 75.ComboboxMasterAndDetail.mrt
- (16.69 KiB) Downloaded 208 times
Binded comboboxes
Thank You, that more or less covered the topic. Based on that example I managed to solve my problem.
Thank You
Thank You
Binded comboboxes
Please do let us know if any assistance is required.
Thank you.
Thank you.