I am creating a cognos report that uses date prompts, when you run the report you enter a start date and an end date. What i would like to do is make a calulation on the results of a query based on the number of months between the start and end dates entered for example
if the number of months between the start and end date entered is 12 I would like to multiply a query result by 12 and then Divide by 2 but if the number of months between the start and end date entered is only 1 I would just like to multiply by 12.
Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource. In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.