My problem is this: I have develo

[ipazzo]

My problem is this:
I have developed an application that allows the final customer to construct the own ones report. But in the report designer it is not possible to create a query on the database.
Is there a way for giving the possibility to the customer to create the query to use in the report.

Thanks.

 

[ramani]

HI

If you can provide a way to store the SQL selects in a Tables Memo field and then also store the name of the report along side in the same record, you can then, use macro statements and call the SQL, create the cursor and then run the report as well.



ramani
(Subramanian.G)

http://winnersoft.coolfreepages.com/

 

[Mike Gagnon]

ipazzo

You may have to design you own "wizard" like interface. You can find the source code for VFP's own query wizard in the "C:\Program Files\Microsoft Visual FoxPro 7\Tools\xsource" directory, or you can purchase a thrid-party product like FoxFire (

http://www.hallogram.com/foxfire/)

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[Mike Lewis]

ipazzo,

To confirm what the others have said: You basically have to write your own interface for this.

Alternatively, there is a product called FoxFire, which is essentially a reporting tool but it does include an end-user querying tool as well. It is written in Visual Foxpro and includes source code. I have never used it myself but several people I know do use it.

For more info, see:

http://www.micromegasystems.com

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk

 

[rob444]

And there is UserQ a query and reporting tool which also includes sourcecode.

Information:

http://www.harp1.com/userq/

Rob.

 

[ipazzo]

Thanks to all for the reply.
I will try first FoxFire....

... to be continued

 

[rgbean]

Don't forget to checkout the Stonefield Query product at

http://www.stonefield.com/

- it's got thing's that FoxFire! doesn't.

Rick

 

[Mike Lewis]

Rick,

I'm not 100% certain, but I believe Doug Hennig has discontinued his query product, so as to concentrate on the database toolkit.

Someone will correct me if I'm wrong.

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk

 

[bholmstrom]

I would strongly suggest they purchase and use Crystal Reports 9.0.

 

[rgbean]

Mike,
That was the "old" query product - the new one is MUCH better. It comes in standalone customized versions or a Developer's version (w/ different options) that can be easily integrated into your application. See

http://www.stonefieldquery.com/versions.html

for the version info. Doug's team has been working very hard on this product as well as the Toolkit upgrade for VFP 8.0 - they've done a great job!

Rick

 

[Mike Lewis]

Rick,

Thanks for that update. I just took a look at the web site. The product looks terrific.

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk

 

[ipazzo]

Thanke to all,
i have decided for CrytalReports.

@bholmstrom, i think you have alredy use CR with VFP.

But i have trouble to distibuite my application.
1. On my pc all works fine but if i install my application on a pc without CR i can't see the reports.

2. Is possible to distribuite e CR component/activx that allows the final user to customize reports ?

 

[Mike Lewis]

Ipazzo,

Re Crystal Reports, you might want to read "Using Crystal Reports with Visual FoxPro", at:

http://www.ml-consult.demon.co.uk/foxst-19.htm

Also, take a look at Craig Berntson's site:

http://www.craigberntson.com

If you have any more questions about Crystal Reports, I suggest you start a new thread so that others will see it.

Mike



Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk