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

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

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

I meant the Preview Panal command that shows parameters and the group tree, but I've manged to re-instate it, by ticking the box in Report Options, then saving and closing the report and re-opening. I'd forgotten that it won't show until you close and re-open a report. Thanks

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

I do have dual monitors, so with a bit of messing about and moving them around, I have managed to do as you suggested, and it is now back in place! Thanks so much for the help.

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