Search results for query: *

Got it! Writing it down did the trick. Link the TransDate field to the PeriodStart field >= then link the TransDate again to the Period End Field with a <= join. Job Done!

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...

Nice to know you are trying all avenues Speak to you soon Lyle

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?

Is there a way of finding all reports with events attached. Are there any 3rd party tools to allow triggering remotely ta.

Use NumericText() function. This returns True or false as to whether it is a number or charachter within the field

Is that you Mr Cunnigham. You will let me know if you ever find the answer outside of v9. Regards Lyle

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...

Just what I was after, Ta very much

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.

Try a RunningTotal. Get it to sum the $ value and to reset using a formula; Remainder({$Value},6)=0 I haven't had time to test it further than the number of records you supplied but it should start you off on the right track.

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 &quot;Local...

Try the CrystalDecisions.com site. go to support and downloads, then UFL's there are a batch of functions relating to Business days

Are you saying that you wish only to chart on one field alone. If so then &quot;Insert&quot; a chart, select the pie chart type, then move to the &quot;Data&quot; Tab. Make sure you select the &quot;Advanced&quot; button under the label &quot;Layout&quot;. Enter the field in both the &quot;On...

Have you made any further progress reporting on Users logged on. When I used the NT event Log no user names were being returned, so although I have the timestamp I have no name.