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!

Register Log in
  • Congratulations derfloh 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: *

  • Users: mike99
  • Content: Threads
  • Order by date
  1. mike99

    How do I Suppress a Blank Supreport

    I have subreports that I want to suppress when they are blank. I have ticked the "suppress Blank section" box both in the main report and in the sub report but the blank pages still appear. New page after is also ticked in the main report. Thanks for your help Mike
  2. mike99

    Subreport Selection By Date

    I have data that I need to print in columns by date but the date must be variable. I thought of making a subreport for each date and I could then pass that date to the subreport with a Shared Date variable. I can get the variable date into the subreport but I cannot access it to use for...
  3. mike99

    Formatting Group Header

    I have a report with 3 groups; Group 1 = Customer Group 2 = Order Group 3 = Invoice I want to format the Group 1 header (to suppress it) based on results determined by a formula in the Group 1 footer. There is a formula in the Group 1 footer that adds results from formula's in the Group 2 and 3...
  4. mike99

    Difference between Ver 7 and Ver 8.5

    I have a report with 3 groups; Group 1 = Customer Group 2 = Order Group 3 = Invoice I want to format the Group 1 header (to suppress it) based on results determined by a formula in the Group 1 footer. If I run it at the office on Ver 8.5 with test data it displays the result of the formula in...
  5. mike99

    Conditional Subreport ?

    I have a situation where I am printing Invoices. If the product sold meets certain criteria a new report has to be created after the invoice is complete on a new page and before the next invoice is printed. Any suggestions? Thanks Mike
  6. mike99

    Linking Word Document to report

    I have to include information in a report that exists on Word documents . The Word document is different for each type of product that is referred to in the report. I don't think I can use Insert because that only enables me to link to one specified word document and I want to be able to choose...
  7. mike99

    How do I Insert a Word Document into a report?

    How do I Insert a Word Document into a report? Thanks Mike
  8. mike99

    Referencing a separate document

    Is it possible to put a file path into Crystal to trigger the printing of a Word document that has to be produced under certain conditions? Thanks Mike
  9. mike99

    Selecting problem on string field

    I have a string field that contains a) Numeric Characters b) Alpha Characters c) Null Values How can I separate the Fields that contain Alpha's from the fields that contain numerics. When I use " tonumber" it hangs up on the null's and if I set the nulls to "0" it does not...
  10. mike99

    Conditional Totals in Groups

    I have a report where I have grouped on Invoice, order and Customer. I have a conditional calculated field that awards point that is dependent on the order value and cannot find a way to total the points at the Customer level. points Inv 1 100 Inv 2 150 Order 1...
  11. mike99

    Ver 8.0 "HELP" Is not available

    I have installed Crystal Report Ver 8 and when you click on "HELP" and the "Crystal Seagate Reports Help F1" nothing happens. No message or anything. The same with the Context help. You can Drag the "?" down but nothing else happens. All the other items on the...
  12. mike99

    Creating a Btieve File

    I originally submitted this to the Crystal list but thought it might be more relevant here. I have to develop a report that prints labels for goods to be shipped and the quantity of labels to be produced must be determined by the quantity sold as detailed on the invoice. I have set up two...
  13. mike99

    Page break control when printing subreport

    I need a report that prints shipping labels and the number of labels depends on the quantity of items sold. I have developed a main report that does not print anything but passes the quantity sold information to a sub report via a link. The sub report generates the correct number of labels...
  14. mike99

    Extracting data from Access

    We have to extract data from an Access Table. It is customer address information that is in one column in Access with a special character that looks like a "square box" separating the address lines. How do we get the info out of access onto individual lines or columns? We have tried...
  15. mike99

    Multiple Copies Of Same Report

    I'm back again I have to develop a report that prints labels for goods to be shipped and the quantity of labels to be produced must be determined by the quantity sold as detailed on the invoice. I have set up two tables in Access as a "proof of concept" where I link a "Quantity...
  16. mike99

    Linking Crystal to EXCEL

    I have created an Excel file with two columns. Row 1 is column labels that I have range named and the rest of the rows are filled with numbers. I have linked this Excel file to Crystal V8 via ODBC. In Visual linking expert in Crystal when I right click the field the properties of the field are...
  17. mike99

    Sub report border - get rid of

    How do I get rid of the border around a subreport?
  18. mike99

    Linking Btrieve to Access or Excel

    I'm trying to link from a Btrieve file to Excel or Access and when I establish the link I get a message that the data is not "the same type", as far as I can determine all fields are number fields. Is it possible to link Btrieve to Excel or Access? How can I make sure that all file...
  19. mike99

    ODBC connection to Excel

    Where can I find detailed step by step instructions on how to set up an ODBC connection from Crystal to Excel? Thanks
  20. mike99

    Multiple copies of Same Report

    I have to develop a report that prints labels for goods to be shipped and the quantity of labels to be produced must be determined by the quantity sold as detailed on the invoice. I am unable to find any reference as to how to determine the number of times a report is produced based on the value...

Part and Inventory Search

Back
Top