Hi

As stated in previous post, i have finished some improvements and fixes to Fast report 4.x connector. I have submitted the changes to support team so they can check them and include them in next release.

Some of them:

1) Added Delphi XE packages and Group Package

2) Fixed issue with master-detail with TfrxADQueries and TfrxADStoredProc Pro components

3) Improved parameter handling with TfrxAdQuery

4) Improved parameter handling with TfrxAdStoredProc (now the the params are autofilled when selecting a Stored Procedure Name)

5) Improved parameter handling with TfrxAdStoredProc (InputOutput and OutPut param types return the returned values)

6) Improved Design time editors for TfrxAdDatabase, now uses the AnyDAC standandard connection dialog
a) Hide Connection 'Options Tab' or added an optional parameter to TfrmADGUIxFormsConnEdit.Execute to pass an already
instantiated TfrmADGUIxFormsConnEdit object where Specified tabs can be Hidden before showing the connection editor
b) Or Implement the same TADConnection properties to tfrxADDatabase so editing any advanced options in the Dialog can be assigned to TfrxADDatabase
I have made the modification myself the Unit uADGUIxFormsfConnEdit.pas is also attached in the mail sent to support team, the changes are marked as ‘{changed by fduenas}’
I have only added and optional parameter to the ‘Execute’ methods to pass an instance of the TfrmADGUIxFormsConnEdit form
With previous modifications the TADFrx Components can now be used in the Fast Report ‘Create Wizard’
a. HINT for developers:
b. From what I have experienced developing these components, the interface for the conection is quite inconsistent, especially with the wizards to create connections, tables, and queries since it only has 2 fields, The driver (ADO, DBX, Zeos, AnyDAC, etc) and a databasename which by default is an ADO connexion or a file, which for most engines, is not enough. As a matter of fact, of the diferent engines I tried, only the ADO Engine works.

I was able to make it work with the wizard but I had to make a small change in the "frxConnWizard.pas" (Fast report sources) since there seems to be a bug and have never been fixed. In this unit, I had to add the line:
FItemIndex := ConnCB.ItemIndex + 1;

after the line:

FDatabase := TfrxCustomDatabase(ClassRef.NewInstance);

inside the procedure TfrxConnectionWizardForm.ConnCBClick(Sender: TObject);

If you have problems with the wizard and you have the source, you may want to make this change.

7) Able to use the $(APPDIR) (don't know if AnyDAC already uses a variable to access this value) in the Database Name for File Based Databases like Access, SQL-Lite and embedded Databases.

8) Registered some properties and methods for Fast Report Script.

I had no time to create test cases, but if you can give a guidance on how to do them and also suggestions for improvements all are welcome.

Hello

Thank you for your great work ! The changes will be included into main AnyDAC source base.

Thank you. Just some doubts

1) I saw you can use a $(ADHome) variable for the Database path, do you had something but for current Application exe folder? or current folder? maybe you implement something like I have done in frxADComponents

2) Please Add The Info tip how to fix the FrxConnWizard bug like in Txt or something in the frxAddOnFolder

3) Can you give me some guidance what can i include in Qa test cases for this frx Addons?

regards

1) There is $(APP) variable for an application EXE folder. So, I have deleted the code for APPDIR. If you needs some additional variable, let me know.
2) Done.
3) I do not expect, that that will be some non-visual fully automated text. So, some application, that will allow to open reports at design time and run them, will be OK. Add also some instruction with steps - what to in the program, what press, etc and what result is expected.

I will send the merged code base to you. And the updated addon.

Thank you for your efforts fduenas. Especially now that I see FastReport 4 ships with XE2, updates will be very welcome!

Hi I have Updated and solved some issue regarding Params in the connector. This is because the behaviour the Params have with tFrxQuery, it seems they store and expression instead of a Value, so that can cause problems between TADparams and Tfrxparams. Made some workarounds and I have already sent the changes to you.

Regards

Hello

Thank you ! Your code will be included as is into the upcoming AnyDAC release.

We have no experience with FastReport and no test environment for FastReport. So, I can only believe you Still, to make all properly, I will suggest to you to post the FR addon to this thread and to our customers to post feedbacks to this thread too.

OK, I will do that. I didn't make it before, because, originally it was never mine originally and wanted to give you the single channel to obtain the sources. But you're right I will post it in a new post and so they can make the tests.

I haven't had time to make the test cases. but if you can give me some orintetaion what tables I can use from the test database you create, for example with master-detail, stored procedures, etc. so I can create the reports.

thanks and regards

Here are the sources of the latest AnyDAC connector for fast report 4.x, pleas efeel free o test it and comment it.

Don't forget to read the 'readme.txt' file first.

Is there a sample on how to use this component, I did installed on Delphi XE2.