?
Solved

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

Posted on 2007-11-14
4
Medium Priority
?
2,251 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
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…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses
Course of the Month10 days, 9 hours left to enroll

765 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