Search results for query: *

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

Thanks everyone

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

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

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

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

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

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

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

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

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

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.

Stacy, Try listing the invoices horizontialy

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

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

Question: How did you look for leading zero employee number? 1. I would add the following the SELECT EXPERT against the employee number LIKE(length({employee number})[1]) "0" or " " or NULL use to fine all employee number with "0" or " " or null I found this reference page...

I developed a small database in MS ACCESS and create your issue, listed above. I also created a CRYSTAL REPORT XI, In which show proper breaking for the field1(group1), field3(group2) Database contained 3 fields field1 field3 field2 10 5 20 10 5 20 10 6 30 20...

YES, This possible! I would address this in the STORED PROCEDURE 1. CREATE a additional PARM to indicate how many PARMS you would LIKE to use EXAMPLE PARM1='1234' PARM2....... 2. IN THE WHERE CLAUSE THEN BEFORE every IF statement for the PARM use the LIKE command 1ST IF: IF PARM1...

or change 3. I would ADD a FORMULA IF LENGTH(PROD.CODE) < 1 THEN "NOT ASSIGNED" to 3. I would ADD a FORMULA IF LENGTH(PROD.CODE) = NULL THEN "NOT ASSIGNED" If this does not work download Teamview10 and install Tell me when you will be available (I am in Arizona or mountain time) and I can...

1. I would query the data and find a true null PROD.CODE, make sure its not spaces 2. This statement Right({PRODCODE.CODE},1) would blank out PROD.CODE 3. I would ADD a FORMULA IF LENGTH(PROD.CODE) < 1 THEN "NOT ASSIGNED" 4. PLACE THIS FIELD IN THE REPORT HEADING AND MAKE IT INVISIBLE IF THIS...