I have an Impromptu report off an Oracle database that uses direct SQL to retrieve a value from the previous row. Ex this query:
select c1, lag(c1,1) over (order by c1) c2
from table;
will return:
c1 c2
row1
row2 row1
row3 row2
I would like to be able to use an Impromptu user...
Is there a way to determine the number of weekdays between 2 dates?
Ex. Start Date End Date Weekdays
5-01-04 5-15-04 10
5-16-04 5-31-04 11
6-01-04 6-15-04 11
I've been using 2 hotfile reports to get billing rates from a billing database into a time tracking database. I am now trying to use Access to eliminate the first hotfile. I have rewritten the 2nd hotfile report using Access to combine the 2 databases. My problem is that if I save the new...
Nagrajm,
I've followed your suggestion. If I understood you correctly the height sizing will only apply to the comments field not to the header itself. The header row will only accept a specified height size not a dynamic size. So I would need to make sure my header row height as least as...
I have an Accounts Revceivable report with a column for comments that is associated to the customer id. The comments column is a long datatype. I set the Layout of the comments field to multi-line with word wrap. The height size of the cell is set to dynamic.
the report looks like:
Cust Id...
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.