My Visual Database — Help with ComboBox in report

Re: Help with ComboBox in report

null@example.com (cmoi) — Wed, 23 Mar 2022 13:13:17 +0000

Thank you again Derek.
issue resolved, I had an error in the code

1000 thanx

Re: Help with ComboBox in report

null@example.com (derek) — Tue, 22 Mar 2022 11:07:59 +0000

Hi,
Please attach the project.
Derek.

Re: Help with ComboBox in report

null@example.com (cmoi) — Tue, 22 Mar 2022 11:05:10 +0000

Hello
sorry for this, please bare with me
after I tried the Derek's solution I get this error

Re: Help with ComboBox in report

null@example.com (cmoi) — Mon, 21 Mar 2022 19:47:42 +0000

Hi Derek
thank you so much for help, I'm newbie (calculated field) and pascal programing.

Re: Help with ComboBox in report

null@example.com (derek) — Mon, 21 Mar 2022 16:33:34 +0000

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.

Re: Help with ComboBox in report

null@example.com (cmoi) — Mon, 21 Mar 2022 14:29:14 +0000

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.

Re: Help with ComboBox in report

null@example.com (derek) — Mon, 21 Mar 2022 13:13:54 +0000

Please attach your project otherwise it's just guesswork.
Derek.

Help with ComboBox in report

null@example.com (cmoi) — Mon, 21 Mar 2022 12:59:04 +0000

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