• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2372
  • Last Modified:

How do you get TQRExcelFilter to save a quickreport to an xls file?

How do you get TQRExcelFilter to save a quickreport to an xls file? I have dropped aTQRExcelfilter compinent on the form, and when the preview screen shows, there is an option to save as an xls file. But nothing happens
0
jacoalb
Asked:
jacoalb
1 Solution
 
LimbeckCommented:
dropping a filter to your report will only add the option to save as in excel. If you want to save it using your code try something like this


var
  sf : TQRExcelFilter;
begin
  ef := TQRExcelFilter.Create('c:\temp\abc.xls');
  try
    yourreport.ExportToFilter(ef);
  finally
    ef.Free;
  end;
end;
0
 
Computer101Commented:
Forced accept.

Computer101
EE Admin
0
 
EngineerlyCommented:
The accepted solution gives an error:  Incompatible types: 'TComponent' and 'String'
Evidently something other than a string is required.
There does not seem to be any documentation on the use of that TQRExcelFilter component.
A Google search led to a hint that maybe there are two different components: one that comes with the standard Delphi and another that is a professional add-on, but the Delphi compiler is still configured to look at the original (which expects a string parameter).
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now