I am trying to populate the pulldown menu on a custom active report. I thought all I needed to do was to fill in the DrillDownFieldName section with a (Table).(Column) value hence
DrillDownFieldName = "Tender.Description"
But this isn't doing to job.
Any help would be appreciated.
Patrick
Patrick,
Using the stock Tender Summary report as an example;
Add your JOIN statement in the Tables Queried statement;
LEFT JOIN Tender ON TenderEntry.TenderID = Tender.ID
Change the Fieldname = "Tender.Description" Change the DrillDownFieldname = "Tender.Description"
Have something to add? Share your thoughts — no account required.
Ask the community — no account required