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!

  • Congratulations dencom 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 dinshak

  1. dinshak

    Formula explanation

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

    Running total

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

    Running total

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

    Running total

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

    Running total

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

    Increase cross tab column

    Ho can I increase the column width in a cross tab
  7. dinshak

    Vertical Line extends on next pg

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

    Details 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
  9. dinshak

    Details 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
  10. dinshak

    Display multiple values without parameters promts?

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

    Sub report help

    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?
  12. dinshak

    Sub report help

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

    Page Setup

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

    Group Footer output problem - URGENT help needed thankx

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

Part and Inventory Search

Back
Top