Forum > Databases

How to Load lazreport from blob

(1/1)

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


--- Code: Pascal  [+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i < x.length; i++) { x[i].style.maxHeight='none'; x[i].style.height = Math.min(x[i].clientHeight+15,306)+'px'; x[i].style.resize = "vertical";}};} ---  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  [+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i < x.length; i++) { x[i].style.maxHeight='none'; x[i].style.height = Math.min(x[i].clientHeight+15,306)+'px'; x[i].style.resize = "vertical";}};} ---  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:
Use "LoadFromXMLStream(fStream)" instead of "LoadFromStream(fStream)". LoadFromStream is for prepared binary report.

sydenis:
Thank you very much! Works fine.

Navigation

[0] Message Index