Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Limit Report to 30 days of history and six months form today
Migrateduser
<p><span style="font-size:medium;">[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]</span></p><p> </p><p><span style="font-size:medium;">[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]</span></p><p> </p><p><span style="font-size:medium;">[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]</span></p><p> </p><p><span style="font-size:medium;">[font="calibri;"]The SQL for the data set is attached.[/font]</span></p><p> </p><p><span style="font-size:medium;">[font="calibri;"]Thank you,[/font]</span></p><p><span style="font-size:medium;">[font="calibri;"]Rob[/font]</span></p>
Find more posts tagged with
Comments
There are no comments yet