Fastreport dataset can't find any TDAMemDataTable

TIMOTHY_LAM · October 22, 2021, 2:59am

Hi,
I want to migrate Crystal Report to FastReport. But I found FastReport can’t find any TDAMemDataTable. It will difficult to using TfrxReport to design the report under Delphi IDE. Any suggestion? Or any other report that is recommend by RDA?

claudio.piffer · October 22, 2021, 5:15am

Hi Timothy

FastReport work fine with DA. To work in designer active your DAMemDataTable. TDAMemDataTable expose the DataSet property

TIMOTHY_LAM · October 22, 2021, 7:43am

Hi,
Under Delphi IDE, TDAMemDataTable can’t set in the TfrxDBDataset’s DataSet. So I can’t design the report under IDE mode. It needs to using coding to assign the properties to TfrxDBDataset’s DataSet.

fastreport

EvgenyK · October 22, 2021, 8:09am

Hi,

Try to use TfrxDAComponents component from ...\Data Abstract for Delphi\Source\Unsupported\FastReport folder

TIMOTHY_LAM · October 22, 2021, 8:35am

Hi,
I installed it and tried it. It can’t work. Any sample can provide for my reference?

EvgenyK · October 22, 2021, 9:38am

Hi,

check sample - 25562.zip (99.5 KB)
looks like TfrxDAComponents isn’t required anymore - table can be shown via TfrxDBDataset

TIMOTHY_LAM · October 22, 2021, 11:51am

Hi,
Thanks. I checked your sample that is using the coding instead of drag & drop the fields if “DataSet” assign to dataset component. I will try to apply it.

One more thing, which once is prefer by your suggestion between Digital Metaphors ReportBuilder & FastReport? If ReportBuilder, it can using DA.

EvgenyK · October 22, 2021, 12:05pm

Hi,

up to your decision.
both engine work with DA

TIMOTHY_LAM · October 22, 2021, 12:18pm

Noted with thanks.

TIMOTHY_LAM · February 15, 2022, 2:31pm

Hi,
I started to doing the report migration. But I found it has the problem about subreport feature in FastReport. The reason is missing data dictionary. So I can’t doing the master-detail mapping in IDE. The following is the normal design in FastReport Designer. Any idea to create the data dictionary under IDE mode?

EvgenyK · February 15, 2022, 2:36pm

Hi,

can you create a simple testcase that reproduces this case with FastReport, pls?
you can upload it to support@ for keeping privacy

P.S. you can use sample DB from C:\Users\Public\Documents\RemObjects Samples\Database.

TIMOTHY_LAM · February 15, 2022, 2:40pm

Hi,
Your demo sample also can’t show the data dictionary. Any solution to create the data dictionary?

EvgenyK · February 15, 2022, 2:45pm

Hi,

I’m not familiar with the latest changes in FastReport.
at least it worked as expected with FastReport v4 when I touched it in 2010.
so I need a testcase that illustrates the issue with required steps.

TIMOTHY_LAM · February 15, 2022, 2:46pm

Hi,
Noted. I tried to prepare the testcase for your reference.

TIMOTHY_LAM · February 15, 2022, 3:14pm

Hi,
Testcase sent to support’s email.
Thanks!

EvgenyK · February 15, 2022, 4:15pm

Hi,

everything works as expected:

workaround: specify m/d on DA level via wizard:

claudio.piffer · February 15, 2022, 5:46pm

Hi Timothy

but, from your screenshot, is FR for .NET not Delphi. Right?

TIMOTHY_LAM · February 16, 2022, 7:59am

Hi,
No. It is FR for Delphi. I open your demo sample from FR v6 under Delphi 10.4.2.

EvgenyK · February 16, 2022, 9:08am

Hi,

screenshots from FastReport for VCL. Delphi 11.