Dynamic report column for reporting engine and data export

V5 Request
1

Requesting a feature to dynamically define number of columns in the report.

CURRENT:

[Report:1,1,1]
{
...some query ...
}

[Export:0]
{
some query
:F.1, F.2, F.3
::"{0}","{1}","{2}"
}

REQUESTED:

[Report:*]
{
...some query ...
}

[Export:0]
{
some query
:*
::"*"
}

Requesting this because creating reports via dynamic SQL queries its impossible to predict number of columns. Using scripts and calling on them by {CALL:x.y} to replace [Report:1…] sections doesnt create any results. It gets returned as text.

This would allow to create dynamic reports.

3 Likes