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

It worked. I have a formula field: if isnull({@specs}) then {PRODUCT_SPEC.DESCRIPTION} else {@specs} when the report runs it displays the value "11.1<=Resut<=19.5 days", but in one location its blank and it only displays when i double clik in the blank area. I know this is a freaky situation...

it works thank you. if i need to add the below with the above formula how can i do that if isnull({#Pos}) then "N/A" else totext({#Pos}) //no decimals, no comma separator if isnull({#NegL}) then "N/A" else totext({#NegL}) //n

I did try the above by putting the formula in running total display string. It still does not display NA

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 ?

Crystal 11 you got it right I did try to group it by id, but the ID does not change it remains constant. I also have a selection criteria of id<>-1 any other criteria (is one of or is any) gives blank report

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.

what exactlt does sharing the same parameter mean? so I can have unlinked subreport? but then how will the fields in the subreport fill in?

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.

the subreport links look good.

Thats right I am only able to see partial information information for D_Value_Test. Just one particular Group footer that has the following fields as: Running total field (max) for #PlCount1: {RESULT.REPLICATE_COUNT} = 1 and InStr ({RESULT.REPORTED_NAME}, 'Growth Plate 100 min') > 0 Running...

I have the following under main report (formula-Grouper) if {TEST.ANALYSIS} in ["STERILITY"] THEN "1" ELSE IF {TEST.ANALYSIS} IN ["GROWTH_PERFORM","CULTURE_PURITY"] THEN "3" ELSE IF {TEST.ANALYSIS} IN ["M_TUBERCULOSIS","M_LUTEUS","N_MENINGITIDIS","P_AERUGINOSA","E_FAECALIS","S_PNEUMONIAE"] THEN...

Hi J, Both subreports are referencing same tables, but pulls different data out of it.

I really dont know as to why they are together. As I just joined this workplace and am picking up from someone elses work. Is there a way that I can webex and show you my problem. I will realy appreciate if you can help me with this.

yes both subreports are linked in the same way

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