Search results for query: *

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

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

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

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

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

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

I have to write a formula to calculate countback days on a WiP balance, and wonder if anyone knows any shortcuts, as I have to go back 24 months, which involves huge repetitive formulas. e.g. if {#MFE WiP Bal) > {@Mth 1 Time} then if {#MFE WiP Bal) > ({@Mth 1 Time}+{@Mth 2 Time} then etc...

My preview panel command/button is greyed out, and I have no idea why. Any help gratefully received. Thanks

I've done this before, and I'm even pretty sure I've seen the answer somewhere here on TekTips, but no amount of searching can find the answer today, so I apolopgise for any repetition! My field explorer is usually docked on the right, I've managed to undock it, which would normally be just a...

I have a report summarising time entries, but I need to display the total number of hours as 146:06 (for 146 hours 6 minutes) I keep getting the error message "Hour must be between 0 and 23" Is there any way to get around this, other than decimalising the total? Thanks

I have a report with 2 parameters, and I want to enter multiple values for both, and use both to search in string fields. e.g. {?Name} = "Brown","Green","White" {?Postcode} = "SO9","SO6","SO4" {?Name} in {Client.Name} and {?Postcode} in {Client.Postcode} but i can't find any fomula...