Recent content by lamunta

Thanks for your help. I've learnt a lot from your advice which will come in useful. I have now managed to track down the cause of the problem to {fn DATABASE()} and {fn USER()}. I don't know why they are causing the report problems, but once removed, the report runs ok. As they are not...

This is the SQL it processes. The only thing I am unsure about is the way that the date is parsed, but I have removed the date processing from the report and still get the error. SELECT doc."DOCCODE", doc."DOCNUM", doc."CURDOC", doc."DOCDATE&quot...

A report that I have returns this error when connecting to DB2; &quot;SQL0104 Token ( was not valid. Valid tokens: + - AS <IDENTIFIER>&quot; Crystal then displays that an ODBC error has occured and then crashes. This only occurs on one report in Crystal 8.5. I also have versions of this...

Thanks - I managed to get it working using a similar method. I'm not too hot on using variables so I tried the following. 1 - I created my aged calculations and put these in the detail lines (Hidden - no drill) 2 - 1st grouping on Document number 3 - running totals created - 1st on the...

Having spent a while using this method, I have hit a brickwall. Although it works to exclude the dupplicate records, I am unable to sum the details into other group footers. I need the following Detail (hidden) 1 - 1000 2 - 1500 2 - 1500 Group 1 1 - 1000...

Thanks seems to be working.

Hi, I have a bit of a tricky problem that I would appriciate some help with. I am writing a report to calculate aged outstanding payments on invoices. This needs to be able to report on the details for a historical period. This is achived by taking the remaining amount (ie outstanding) and...