Flexcel in report with parameterised query

FLX TMS FlexCel for VCL & FMX
1
How does one set things up to use a parameterised query when creating a report?

For a non-parameterised query the report call would be something like
      fr.AddTable('queryName',dm.queryname);
      fr.Run( frTemplateStr,frFileNameStr);

but what is the situation if dm.querymame expects a parameter?

Thanks
   Bruce
2

You would have to set the parameter before calling run:


      dm.queryname.ParamByName('Customer').Value:= 'adrian';
      fr.AddTable('queryName',dm.queryname);
      fr.Run( frTemplateStr,frFileNameStr);

This will get you a report on customer adrian. But this only applies if the parameter is not for a master-detail relationship. If md.queryname is a detail and the parameter is the link with the master, then FlexCel will fill up the parameter automatically when the master changes.