You’re offline. This is a read only version of the page.
Announcements
411
Hello Community!
I have a problem with the Distinct function. I've a combobox linked to a SQL Database. In that combobox I can search for an specific DMC. The column that has all the DMC´s is named 'DMC', there are more than 500 Different DMC´s, but it goes up to 8350 because some are repeated. When i try to use distinct: Distinct(Database,DMC). It's only bringing 25 item.
This combobox populates a gallery:
Share
ReportItems: SortByColumns(
Filter(
Database,
cmb_DMC.Selected.Value = DMC
),
"ID_Orden",SortOrder.Ascending)
How can I bring all the DMC´s without being repeated?
Thanks,
Hector O.
All responses (
Answers (
