?
Solved

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

Posted on 2007-11-14
4
Medium Priority
?
2,306 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
3 Comments
 
LVL 19

Accepted Solution

by:
Limbeck earned 600 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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

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 I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses
Course of the Month14 days, left to enroll

807 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