Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. crumpm

    Subreport trouble

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

    Database Connector Error

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

    Database Connector Error

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

    Count records based on the result of a running total?

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

    Suppression based on subreport

    That did the trick. Thanks very much.
  6. crumpm

    Suppression based on subreport

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

    Need to pass a date from a subreport to an array in the main

    Brilliant, that fixed it :) Thanks v much MC
  8. crumpm

    Need to pass a date from a subreport to an array in the main

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

    Need to pass a date from a subreport to an array in the main

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

    Passing a data from a subreport to an an array in the Main report

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

    Need to convert text to numbers

    Great, that did the trick. Thanks :)
  12. crumpm

    Need to convert text to numbers

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

    Need to convert text to numbers

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

    Countback Days

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

    Countback Days

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

    Preview Panel command

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

    Preview Panel command

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

    Field Explorer won't dock to the right

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

    Field Explorer won't dock to the right

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

Part and Inventory Search

Back
Top