I need to join a transaction table to a financial periods date table in Crystal Reports. (SAP Business One)
Can I link tables in Crystal to form a "between" join;
The Transaction date would link to both a PeriodStart field AND a PeriodEnd field to return the correct period label:=
11/09/2009...
When linking tables on Informix, equal joins work OK.
Left outer or right outer return a rowset error.
To be honest I have taken the SQL statement and tried to run it as a query within SQL directly with the same result.
Is there a way of acheiving a left outer join with Informix?
Any ideas how I might create a formula that will show the difference in minutes between an event creation date and its event closure date. I need the number of working minutes that the event was active.
My main problem is that the office hours are 08:30am - 19:00pm Monday to Friday and a...
Has anybody out there had any success in identifying how to build/write a processing extension to allow row time security when running a Crystal report.
I have run reports on my C Drive, network drives and more importantly servers successfully, showing disk space taken by files/folders etc.
But what I ultimately want is to show a Pie Chart reflecting used space against the available capacity of the drive.
I have been using the "Local...
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.