Solved

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

Posted on 2007-11-14
4
2,183 Views
Last Modified: 2013-11-22
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
Comment
Question by:jacoalb
4 Comments
 
LVL 19

Accepted Solution

by:
Limbeck earned 150 total points
ID: 20287377
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
 
LVL 1

Expert Comment

by:Computer101
ID: 21216628
Forced accept.

Computer101
EE Admin
0
 

Expert Comment

by:Engineerly
ID: 22907057
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question