Recent content by crumpm

Hi I'm using CR2008 on a progress database, using a proprietary driver. I have a table with the data I want, where the key index fields are strings (stupid design fault) To get around this, I have created 2 SQL conversion expressions, and use them to link 4 subreports to bring extra data...

All my other reports, connected to this database, are working normally, so I don't think it's a dbase problem. Thanks

Hi all I have a report in Crystal 12, that connects to an SQL database; some tables and a stored procedure. The report was working fine until a couple of days agao, when I tried to refresh it, but it came up with "failed to retrieve data from the databae" "Unknown Database Connector Error"...

Thanks, I will try this out.

CR 2008 on an SQL database. I need to count the records for each of my names, but the suppression field uses a running total, and I can't work out how to distinctcount. Gp1: Name Gp2: Reference Gp3: Details: Units of Time: Value of Time: Activity Code: Budget Vale: I have running totals...

That did the trick. Thanks very much.

Progress database with CR 2008. I have a rerport that pulls data from a transaction table based on fields stored as text, and I have to link the details in this table to another where the link values are stored as numbers. I have therefore created a subreport to get the correct values from the...

Brilliant, that fixed it :) Thanks v much MC

Group 1 - Department Group 2 - Sector Group 3 - Team Group 4 - Name Detaila - subreport - {Transactions} Detailb - {@LastMovement} <- This is my array formula Grp 4 Ftr - summary field (maximum({@LastMovement}, Name) Hope this helps explain. Thx MC

CR 2008 - SQL database I have a report that shows certain files, if they haven't had activity for a calculated period. The {@Last Movement} is an array formula maximum(makearray(file.last_time,file.last_bill,file.open_date)) which works fine. I now have to add a new element to the...

CR 2008 - SQL database I have a report that shows certain files, if they haven't had activity for a calculated period. The {@Last Movement} is an array formula maximum(makearray(file.last_time,file.last_bill,file.open_date)) which works fine. I now have to add a new element to the...

Great, that did the trick. Thanks :)

Thanks, I will try the integer as I think is what I'm looking for.

Progress database with Crystal Reports 2008 I have a table where the key indexes are stored as text instead of numbers (which they are in every other table in the DB) I need an SQL expression to speed up the conversion as the report often fails when there are a large number of transactions...

Thanks for the tools advice. I will take a look at that. And apologies for not mentioning version info. I'm using CR 2008. I will try the neatening formulas, as I think they will make it much easier to define. Thanks