Period table


I need to create a SSRS report with a fiscal dates (year, month, weeks) grouping. We’re not using analytical cubes where we could have a Period Table with all those fields there. So, I’m wondering if I could use the NAV Date virtual table to create a view using it as a Period table with fiscal year fields added joining it to a main query. Or I’d need to create a different view or a temp table using some sql statement for it. If i cannot use the NAV Date virtual table please advise what a sql query could be to create a period table for a view or a temp table/variable.


I found an sql function to be used fto create a date table. The NAV Date table cannot be get from sql.