DataSources based on dynamic sql queries

edited November 2022 in FastReport .NET


Is it possible to create datasources in runtime based on dynamic sql quires which

are stored as plain text and keeps some hierarchy?


I got huge database with thousands of tables and views.

Each table has millions of rows and some relations.


My datamodel for report is something like:


master dataset 1:

- parent: null


select a.*, as parent_id

from some_huge_master_table a

where id in (someparameter-from-entry-call)


detail dataset 1.1:

-parent: master dataset 1


select b.*, as id

from another_huge_table b

where master_id = :parent_id



detail dataset 1.2:

-parent: master dataset 1


select c.*, as id

from and_another_huge_table c

where master_id = :parent_id




Those tables cannot be fetched by Table/View Datasources (they are too big and

somehow dynamic) - but I can say before executing report how this model looks

like (what column and datatypes there are). I just cannot fetch the data

beforehand. And I need to open detail datasets after fetching rows in Masterdataset

because of given relation, detail datasets depend on actual data of master data



Is this reachable somehow? Is it reachable by standard objects (Table/View

DataSources or by BusinessObjectDatasource)? Or should I prepare my own descendant

of BaseDataSource? Or should I prepare some fake Connection?



Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.