1 Topic by prahousefamily (edited by prahousefamily 2017-07-20 02:43:29)

  • Registered: 2014-02-17
  • Posts: 365

Topic: How to create or update frxdataset from report script

Normal MVD procress create dataset from mvd form
Tdataset  >>>  frxdataset
how to edit script or update frxdataset in report page code ???
by custom sql query in edit code


 
https://s12.postimg.org/dn6iskvz1/2017-07-20_09_30_21.png

My Visual Database : I Love You
Easy For Beginner Student For Me
  • Registered: 2014-02-14
  • Posts: 10,294

Re: How to create or update frxdataset from report script

I know how to do it only using script from MVD, example:
http://myvisualdatabase.com/forum/viewtopic.php?id=1664

Dmitry.
  • Registered: 2016-08-08
  • Posts: 36

Re: How to create or update frxdataset from report script

Can you post an example...???

I have tried the following

procedure frxReportOnStartReport(Sender: TfrxComponent);
var
report : tfrxdataset;   
begin
     Report:=sqlexecute('select * from Funkzellen where Print="false"');
                                                                                                                                                                                         
end;


It didn't work out as the where - clause didn't work out...

or is there a different function to filter the data in the Report??