• Registered: 2017-02-06
  • Posts: 11

Topic: Multiselect for report and print

Hi guys, I'm trying to print a report with multi selection from a grid table.
The problem is when I select more then one value the report gets only the last selected value. Any ideia? 

begin
    main.TableGrid.Options := main.TableGrid.Options + goMultiSelect;
end.

gutierrez100's Website

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Multiselect for report and print

Hello.


Example for you:
http://myvisualdatabase.com/forum/misc. … download=1

Dmitry.

3 Reply by gutierrez100 (edited by gutierrez100 2017-02-09 14:06:23)

  • Registered: 2017-02-06
  • Posts: 11

Re: Multiselect for report and print

Another question, how to use LEFT JOIN with your example?

Thank you very much Dmitry smile

gutierrez100's Website

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Multiselect for report and print

gutierrez100 wrote:

Another question, how to use LEFT JOIN with your example?

Thank you very much Dmitry smile

Form1.bSQLReport.dbSQL := 'SELECT lastname, firstname, strftime(''%m/%d/%Y'', dateofbirth) as dateofbirth, groups.groupname FROM employees LEFT OUTER JOIN groups ON groups.id=employees.id_groups';
Dmitry.