nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Limit Report to 30 days of history and six months form today

RConti

[font="calibri;"]I am building a shop floor loading graph and only want to show 30 days back (past due) from the current date and six months into the future.[/font] [font="calibri;"]I have the graph grouping set to one week intervals and summed. Weekly totals are displayed but the data set is too large. We have jobs that run out to 2015 and we do not need them on the shop floor loading graph. The data is on an IBM i5 with a DB2 database. [/font] [font="calibri;"]Could the limit be done in the SQL or would it be best accomplished with BIRT Eclipse Ver 3.6.2 Parameters?[/font] [font="calibri;"]The SQL for the data set is attached.[/font] [font="calibri;"]Thank you,[/font][font="calibri;"]Rob[/font]

Find more posts tagged with

Comments

micajblock

Always best to filter on the database.

RConti

As a novice I need help with the actual SQL. Could someone please post the SQL that will accomplish the date limits. Thank you in advance,Rob

micajblock

I am not sure about DB2 but for SQL Server it would be<pre class="_prettyXprint">DDATE between DATEADD("D",-30,GETDATE()) and GETDATE()</pre>If I read the online (Google is your freind) SQL manuals correctly then it is:<pre class="_prettyXprint">DDATE between CURRENT DATE -30 DAYS and CURRENT DATE</pre>

bgbaird

Actually, I think you can include both dates in the same statement: DDATE between DATEADD("D",-30,GETDATE()) and DATEADD("M",6,GETDATE()) Brian