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

Search results for query: *

  1. BettyJ

    Splitting Name field with non-standard data

    The following formulas may help you. @FirstName WhilePrintingRecords; split({Sheet1_.Name}," ")[1]; @LastName WhilePrintingRecords; if (" " in {Sheet1_.Name}) then split({Sheet1_.Name}," ")[2]else if ("/" in {Sheet1_.Name}) then split({Sheet1_.Name},"/")[2]; @LastnameWithoutAdditionalData...
  2. BettyJ

    Splitting Name field with non-standard data

    The following formulas may help you. @FirstName WhilePrintingRecords; split({Sheet1_.Name}," ")[1]; @LastName WhilePrintingRecords; if (" " in {Sheet1_.Name}) then split({Sheet1_.Name}," ")[2]else if ("/" in {Sheet1_.Name}) then split({Sheet1_.Name},"/")[2]; @LastnameWithoutAdditionalData...
  3. BettyJ

    Hide Employees with no data from subreports

    I believe pmax9999's reply in the following link will help. http://www.tek-tips.com/viewthread.cfm?qid=1720758
  4. BettyJ

    Highlighting Parameter Search Results in Text Field

    Try creating a new report and add the following formula: @highlight stringvar txt:="Hello World!"; replace(txt, "Hello","<font color=#ff0000>" & "Hello" & "</font>") Right click the formula; select Format Field->Paragraph(tab)->Text Interpretation: HTML text and see if Hello is displayed in...
  5. BettyJ

    Highlighting Parameter Search Results in Text Field

    Have you formatted the formula to HTML text? If not, change the text interpretation by right clicking the formula; select Format Field->Paragraph(tab)->Text Interpretation:HTML text. I forgot to specify it in my previous post, but in the link I first sent, it was mentioned in the post by lbass.
  6. BettyJ

    Windows7: Version: CRXI / Experienc

    if ( "WEAPON" in uppercase({CAS_ActionEntity.ActionEntityNote}) or "WAEPON" in uppercase({CAS_ActionEntity.ActionEntityNote}) or "WEAPN" in uppercase({CAS_ActionEntity.ActionEntityNote}) ) then "W" ;
  7. BettyJ

    Highlighting Parameter Search Results in Text Field

    Try the following: replace(lowercase({ChatMessages.MESSAGE}), {?Text_To_Search_for},"<font color=#ff0000>" & {?Text_To_Search_for} & "</font>")
  8. BettyJ

    Windows7: Version: CRXI / Experienc

    Try: if ("WEAPON") in uppercase({CAS_ActionEntity.ActionEntityNote)} then "W"
  9. BettyJ

    Highlighting Parameter Search Results in Text Field

    I believe the following link will help you: http://www.tek-tips.com/viewthread.cfm?qid=1212085
  10. BettyJ

    Grouping based an date ranges

    That's why - it first groups on Farm and then on Quarter. I am not exactly sure how you need it, but maybe you can try to combine the groups the way you need by creating a formula like: @CombinedGroup @QuarterGroup &" "& {TABLE.YourFarmField] Change QuarterGroup to the name of the formula...
  11. BettyJ

    Grouping based an date ranges

    Do you have any other groups above this group?
  12. BettyJ

    Suppress Group Header based on Shared Variable

    Please refer to pmax9999's reply in the following thread: http://www.tek-tips.com/viewthread.cfm?qid=1720758 Hope this helps.
  13. BettyJ

    Export to excel without excel creating blank rows

    I totally disagree with Skip. I also had trouble while I first started working on exporting reports to Excel, but now I am able to export reports without any unwanted columns or rows.
  14. BettyJ

    Date/Time Parameter help request

    Try the following: Create a formula say, Todate_StatusDate date(split({Status_Date}," ")[1]); In the record selection formula, {@Todate_StatusDate} >= {?StartDate} and {@Todate_StatusDate} <= {?EndDate}
  15. BettyJ

    Date/Time Parameter help request

    In the record selection formula, try the following and see if it works: date({Field})>= {?StartDate} and date({Field})<= {?EndDate}
  16. BettyJ

    In Crystal Reports Preview, only text, parameters, and inbedded Excel spreadsheet is displaying. Fie

    In the Section Expert, click on any section (say, Details). On the right side you can see the Suppress Option . There is an x-2 button next to it. If you click on it, you can see if there are any conditions attached to Suppress.(also the x-2 button will be in red font)
  17. BettyJ

    duplicate data using SQL

    In Design View, check if your Details Section is suppressed or hidden. If so, check in which section are the records being displayed.

Part and Inventory Search

Back
Top