You are not logged in. Please login or register.
My Visual Database → Reports → Help with ComboBox in report
Hello
please could you help me solve this issue.
I have a ComboBox (employees)
I want to show a different employee names in the same report, but the report keep displaying the same name from ComboBox
emp.JPG 22.74 kb, 151 downloads since 2022-03-21
Please attach your project otherwise it's just guesswork.
Derek.
Thank you for you interest Derek
this is a simple project (same idea) because the original one is so large
i want to show the selected employee name from the combo box in the report but the issue is (the final report display the same name even if i choose a different names from the combo box e.g : employee in = alpha ,employee out = omega)
sorry my English not so good i hope this is a clear explanation.
combo box.rar 294.46 kb, 287 downloads since 2022-03-21
Hi,
The problem is not with the report, it is with your data structure.
If you had shown both 'employee in' and 'employee out' in form1.tablegrid1, this would have been apparent.
To fix it, because you are using the employee combobox for two things ('employee in' and 'employee out'), you need to
1. define a second relationship between the 'main' and the 'employee' table.
2. create a calculated field to hold the name of the employee from the second relationship.
3. add the calculated field to your report selection.
Please see the attached.
Derek.
combo box2.zip 337.76 kb, 286 downloads since 2022-03-21
Hi Derek
thank you so much for help, I'm newbie (calculated field) and pascal programing.
Hello
sorry for this, please bare with me
after I tried the Derek's solution I get this error
Capture rep.JPG 18.29 kb, 151 downloads since 2022-03-22
Hi,
Please attach the project.
Derek.
Thank you again Derek.
issue resolved, I had an error in the code
1000 thanx
My Visual Database → Reports → Help with ComboBox in report
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi