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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by tomcat24

  1. tomcat24

    PercentileRank in Crystal

    https://stackoverflow.com/questions/770579/how-to-calculate-percentage-with-a-sql-statement Select Grade, (Count(Grade)* 100 / (Select Count(*) From MyTable)) as Score From MyTable Group By Grade or as ( select Grade, count(*) from MyTable group by Grade ) select Grade...
  2. tomcat24

    Is there a COBOL version that will work in the Windows 10 environment?

    Thanks everyone
  3. tomcat24

    Alert user if data they entered into a parameter doesn't exist in the database

    https://stackoverflow.com/questions/36539225/how-to-program-crystal-report-to-lookup-a-record-in-a-table Else display "Error Message
  4. tomcat24

    Example to Run a Crystal Report from an Oracle Stored Procedure?

    https://www.tek-tips.com/viewthread.cfm?qid=1716287
  5. tomcat24

    Cannot connect to any ODBC datasource with MS SQL Server data in crystal

    https://support.microsoft.com/en-us/help/822841/fix-setting-of-connection-attribute-fails-when-you-use-connection-pool
  6. tomcat24

    Is there a COBOL version that will work in the Windows 10 environment?

    Is there a COBOL version that will work in the Windows 10 environment?
  7. tomcat24

    select ALL codes

    https://www.infosol.com/crystal-reports-selecting-all-values-in-a-dynamic-prompt-list/ Answer: In order to do this, you will need to create a SQL command, that grabs all the values you want for your prompt and joins it to another query, that pulls the wildcard (*) value and the word ALL that a...
  8. tomcat24

    Compatibility - CRXI(v11.0.0.1282) and Win10(v1703)

    YES, but beware of a Microsoft Update That will 401? that will prevent connecting to MS ACCESS and EXCEL
  9. tomcat24

    Active X

    Out-of-date ActiveX control blocking https://docs.microsoft.com/en-us/internet-explorer/ie11-deploy-guide/out-of-date-activex-control-blocking
  10. tomcat24

    Barcode Fonts missing in Crystal install

    https://archive.sap.com/discussions/thread/933487 It seems that the font of the reports does not support 128 barcode so the incorrect characters appear. Take a look at this barcode128 maker for Crystal Reports, which is able to select the barcode 128 subtype automatically...
  11. tomcat24

    CR 2008 Radar chart

    https://books.google.com/books?id=Q0x21-20d3AC&pg=PA273&lpg=PA273&dq=how+do+i+create+a+radar+chart+in+crystal+reports&source=bl&ots=Mdh_tX1Hab&sig=7Vxf4JvDDzkNdIap-M9Yte7-DKs&hl=en&sa=X&ved=0ahUKEwiz_pX88ebWAhUnwFQKHckZANUQ6AEIVTAJ#v=onepage&q=how%20do%20i%20create%20a%20radar%20chart%20in%20crys...
  12. tomcat24

    edit/new options disappeared???

    Should check to see if the existing crystal report library is protected. And you have to migrate to a different working environment to make changes.
  13. tomcat24

    subreports and can grow options

    Stacy, Try listing the invoices horizontialy
  14. tomcat24

    Crystal Reports 2013, Oracle 11g, Command Parameters for same field, wildcard and existing results

    https://www.youtube.com/watch?v=tPcw27SwmqY
  15. tomcat24

    Crystal Reports 2013, Oracle 11g, Command Parameters for same field, wildcard and existing results

    Then move everything I suggested to the Report Selection Expert in ONE BIG FORMULA.
See more

Part and Inventory Search

Back
Top