I am trying to extract the latest date for a currency rate located in a oracle database table.
The data in the table includes many entries for each currency code. For example the Euro has 12 entries ie 12 dates,and I need the last date entry to get the current rate.
The MAX function works find...
Hi,
I am using Reporting services to write a report from an oracle database and I need to compare two dates, a date extracted from Oracle and the System date (SYSDATE).
First i need to subtract 7 days from the sysdate, and the solution should be sysdate-7 but this gives me an error 'you entry...
Hi, I have a 1 page report, but have multiple pages when print previewing. The problem appears to be the List box duplicating on each page. The List box contains a text box which summarises a column of quantities, ie a Totals figure. This Totals figure is based on report parameters which are...
To summerise Totals using Impromptu I have found a method of moving the data into the report header and supressing the body of the report. However, I have come across a problem building another report in this manner.Firstly I built a list report with totals of a grouped category. Next I moved...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.