Dashboard epiUltraCombo list with APInvHed FiscalYear

This might be so simple, but i have not been able to get it done.

I have created a new Dashboard which is working great pulling information from APInvHed table. I created to epiUltraCombo fileds to work as “filters” and manually added a list of Years and Months for the user to select the desired ones. In case of the months, there is no problem, since there will always be 12 months, but in the case of the Years, there will always be the need to update the list to show the “new” year every end of year.

I have created a very simple BAQ to the APInvHed table, showing only the “Group” of FiscalYear field. giving me the desired results, of years from the begining of company operations to todays date.

is there a way to populate the epiUltraCombo with that information instead of “hardcoding” the epicombo list?

Try getting the data from the FiscalYear logic instead of a BAQ. Otherwise, use a BAQCombo.

1 Like

Hey Thank you Jason… i knew it was a very simple thing… i had been dealing with this for a while… and the BAQ combo was not working!!! i just “deploy” the dashboard with the baq combo and it nailed… I was missing that dam part!!!

for the BAQ combo to work, dashboard needs to be compiled!!!

thank you Jason!!!