TigerLilly

https://www.doc-o-matic.com

Maybe it is related to this one (expert trying to gain access to the editor´s popup menu): https://en.delphipraxis.net/topic/31...rio-available/

As long as you are working with CDS, that load their data from a file, there is no need for an provider. Just use master/detail as usual. You can try this example to see how a provider comes into play along with a nested dataset: Put a TQuery on a form and connect it to some database. Drop a TDataset and wire it to the Query. Put another Query on the form and connect the mater property to the dataset. Put a provider an the form and coinnect it to the first query. Put a clientdataset on the form and connect it to the provider. Now you can retrieve the fields and have the second query as a nested dataset.

Maybe this can help you: https://github.com/spinettaro/delphi-event-bus

Not sure, why T-SQL is considered to be old. T-SQL (=Transact-SQL) is an enriched version of standard SQL, espescially for MS-SQL server. It is up to date and whoever issues SQL statements againstr a MS SQL server is heavy in T-SQL. https://docs.microsoft.com/en-us/sql/t-sql/language-reference?view=sql-server-ver15

I´d have alook at the trace that is created on the server side, to have a clear diagnostics where to look further. If the statement does not reach the server, the client is the way to go. https://docs.microsoft.com/en-us/sql/tools/sql-server-profiler/create-a-trace-sql-server-profiler?view=sql-server-ver15 BTW: Same issue on another machine? Same issue when executed locally? Same issue when switching protocols?

Interesting. Does this work out of the box, having both FR and HTMLComponets? Is this a preview or already shipped?

While this is impressive, I am not sure, what the video is about. Fastreport FMX 2? HTMLComponents integrating in Fastreport?

Sure: https://en.wikipedia.org/wiki/Gambit_(comics)

I just found this one: https://sites.google.com/site/kryvich/reporter Which is quite similar to EkRTF. But I have no experiences with it.

Of course. But this is one more step + usually there are layout problems when doing so. At least when the report structure is complex.

EkRTF - a RTF template based reporting engine https://www.128byte.ru/ We used it, because we had the need, that our users were able to edit the report after generation.

The idea of having kind of a framework for generating forms (and yes, there are so many so similar forms) is quite interesting. I remember a long ago Java project where we used STRUTS. Building forms was a matter of designing froms and wiring POJOs, validation and workflow. I liked it.

Usually there are trial-versions, free-versions and additionally 30-day-money-back. So for me there is no problem to evaluate and decide. We can´t expect vendors to deliver superior products, in-time support and usable documentation without being paid for. Ah, and we want them to survive for as long as possible! So respect a good product.

Here you are: https://www.tmssoftware.com/site/aureliusfree.asp

https://www.tmssoftware.com/site/tss.asp

TMS has such libs.