How to add generated columns with dates on stimulsoft?

Question

SQL

There is a task to create such a report on stimulsoft, the problem is that there are records in the database with certain numbers and how to make such a sequence of days in the report prntscr.com/cotdvb ?

Answer 1

You need a data source that contains all dates sequentially.
To do this, I used a database query. Example on ORACLE:

SELECT least(DATE '2016-09-01',
                 trunc(SYSDATE)) - 1 + LEVEL dt
      FROM dual
    CONNECT BY LEVEL <= abs(DATE '2016-09-01' - trunc(SYSDATE)) + 1