Search results for query: *

Can someone please explain me the formula below Global BactId as String dim numBactId as Number dim lenBactId as Number lenBactId = 0 numBactId = {RESULT.REPLICATE_COUNT} if ({RESULT.FORMATTED_ENTRY} = "Not Applicable") then if (numBactID = 0) then BactId = "Not...

I have a running total named Pos. In the Evaluate section with a formula: {SAMPLE.X_MON_LOCATION_ID} = 'POS_CTR_WAT' OR {SAMPLE.X_MON_LOCATION_ID} = 'POS_CTR_WAT_M' I want to add to the abouve formula that when the "Pos" is empty fill in "NA" instead of leaving the field blank.

Ho can I increase the column width in a cross tab

Why does the Vertical line extend on second page (report footer) when the vertical line is only drawn in Group footer section ?

I have my fields in the detail section. When the report is run it displays the output for the same id again and again. I want it to display multiple outputs each time with different id's information

One of the oracle databse field has multiple values (list). I would like to display all those values on the report without any prompts once the report is run.

I have created a report with several sub reports in it because creating all fields on one page would be too long. The database used is only one. How do I link my subreports to the main report. Should I have all the required tables show up on the main report and then just link each subreport...

I would like to leave space to the left, right and bottom of the report. I tried the page setup option but that does not help. Also since its detail section has can grow if the information is a lot it goes all the way to the bottom of the page.

i have a main report B_EM_BacT-Alert.rpt and two sub reports B_Micro_dvalue.rpt and B_Micro_Bioburden.rpt Both subreports have the same Group footer that has a formula @Pos2 (as under) numberVar a ; stringVar pos2; a := instr ({RESULT.REPORTED_NAME}, "-Btl "); if a > 0 then pos2:= Mid...

new to crystal can someone pls explain me briefly what each line is doing. numberVar a ; stringVar pos2; a := instr ({RESULT.REPORTED_NAME}, "-Btl "); if a > 0 then pos2:= Mid ({RESULT.REPORTED_NAME}, a + 5, 1) else if instr({RESULT.REPORTED_NAME}, "Ster") > 0 then pos2 := '4' else if...

I have a heading that I need to suppress, but after the last record not on last record. So Under section expert, suppress formula I added onlastrecord but that is suppressing the heading on last record. Can anyone tell me how to suppress it after the last record has been printed.

I have inserted a running total field on the sub-report but it does not display when I run the report. There are other running total fields on the sub-report that display porperly. I am new to this and am working on a previously created report. Any help is appreciated as to why this running...

can anyone help me with a script to updtae odbc driver on client machines

have a database field for customer signature (displays name of the signer) that I want to display on report only when it is "T" true and not when it is "F" false

need to change varchar field that has data to clob?

I have a main report and then added a sub-report in detail section. The database fields from main report show up, but the database fields from sub-report do not display on execution. I have only one database table hence no linking possible. Any help on how the sub-report database fields can be...