How to Load lazreport from blob
lazarus / 16-Databases

----------------------------------------------------------------------
sydenis · 2021-05-10 11:48

ubuntu 20.04 + lazarus 2.0.12
I am trying to load report from my SQLite db:

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i   fStream
:= TMemoryStream.Create; (fQuery.FieldByName('blob') as
TBlobField).SaveToStream(fStream);  fQuery.Close;  fStream.Position :=
0;   fStream.SaveToFile('blob.lrf');  //for cheking   fStream.Position
:= 0;   with frReport do  begin    LoadFromStream(fStream);   
ShowReport;  end;               
 
I get an exception: Invalid binary report: Invalid report version
(60).

When I take my control file 'blob.lrf' (see above) and do

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i   with
frReport do  begin    LoadFromFile('blob.lrf');    ShowReport;  end; 
all is good... (

I try to use frReport.LoadFromDB but the problem persist.
So, where is the mistake. How to load report from db blob?

see report file in attachment

----------------------------------------------------------------------
korba812 · 2021-05-10 12:54

Use "LoadFromXMLStream(fStream)" instead of "LoadFromStream(fStream)".
LoadFromStream is for prepared binary report.

----------------------------------------------------------------------
sydenis · 2021-05-10 18:18

Thank you very much! Works fine.