Hey all,
I have a report that reports issues per month. In this report the issues are separated into issues per day - that is open issues, opened issues, closed issues, and overdue issues for each particular day. This is all put in the graph. This is fine.
The graph reports every 7 days and then the last day of the month. These days are pulled from a table. Here is the problem.
The user puts in the month in the form 'ReportsF' that he/she would like to run the report on, but how do I update the table to reflect the current month? And the first day, every 7 days after, and then the last of the month? (I do this so that the graph is not too packed with data, but I could settle for just pulling every day between StartDate and EndDate from 'ReportsF')
Thanks in advance!
I have a report that reports issues per month. In this report the issues are separated into issues per day - that is open issues, opened issues, closed issues, and overdue issues for each particular day. This is all put in the graph. This is fine.
The graph reports every 7 days and then the last day of the month. These days are pulled from a table. Here is the problem.
The user puts in the month in the form 'ReportsF' that he/she would like to run the report on, but how do I update the table to reflect the current month? And the first day, every 7 days after, and then the last of the month? (I do this so that the graph is not too packed with data, but I could settle for just pulling every day between StartDate and EndDate from 'ReportsF')
Thanks in advance!
