• From: Gotham City
  • Registered: 2017-12-31
  • Posts: 406

Topic: DATA TO REPORT

Hello friends... need help
I am retrieving data from mssql database. How can i print this data using fastreport without saving in mysql/sqlitedb.

  • k245
  • k245
  • Member
  • Offline
  • From: Deep
  • Registered: 2017-10-12
  • Posts: 1,545

Re: DATA TO REPORT

No way. In any case, you will need an intermediate data storage: a database or a text file. In the latter case, you must also write a script to read data from a text file directly into the report.

Визуальное программирование: блог и телеграм-канал.

k245's Website

  • From: Gotham City
  • Registered: 2017-12-31
  • Posts: 406

Re: DATA TO REPORT

Thanks..
How to store data in txt file.. please share script..
Another question
When i retrieve data from mssql database ... large number of transaction take long time... i am using while loop to get data in grid. Any another option or script to load data in grid immediately. Like we retrieve from sqlite or mysql db.

4 Reply by vovka3003 (edited by vovka3003 2023-01-20 13:16:02)

  • From: Белгород
  • Registered: 2018-12-03
  • Posts: 657

Re: DATA TO REPORT

How to store data in txt file.. 

procedure Test;
var SL:TStringList;
    i:integer;
begin
    SL:=TStringList.Create;
    SL.Add('<html><head></head><body><table border="1" cellpadding="5" cellspacing="0">');
        for i:=0 to 9 do
        Sl.Add('<tr>  <td>#'+IntToStr(i+1)+'</td>  <td>AnyData...'+IntToStr(i+11)+'</td> </tr>');
    SL.Add('</table> </body></html>');
    SL.SaveToFile('1.html');
    OpenFile('1.html');
end;
Системы безопасности в Белгороде

vovka3003's Website