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

    Prompt Question

    Charliy and Ian. Thank you so much for your response. Ian. I did exactly what you suggested. What took you a couple of minutes to figure out took me about an hour of trial and error. The only thing you have to do is convert it from text to datetime. Works perfectly. I even passed the...
  2. MK_USF

    Prompt Question

    One mistake was using {?Days/Nights} in my concat formula. The new formulas are: stringvar starttime; totext(minimum({?Date Range})&" "&starttime); stringvar endtime; totext(maximum({?Date Range})&" "&endtime); The report runs but I can not get the formulas above to display the starttime and...
  3. MK_USF

    Prompt Question

    Thank you. I prompt the user for a begin and end date then I want to concatenate this with the begin time and end time established through the above formula. Here are my concat statements in the formulas {@Display Lower Date Range} and {@Display Upper Date Range}. One for the lower...
  4. MK_USF

    Prompt Question

    When the end user selects either "Day Shift" or "Night Shift" from the prompt I would like the select criteria to assign the following times accordingly. Can someone suggest best way to accomplish this? I've created the below formula but I get "boolean" error. I don't think I want to use if...
  5. MK_USF

    Customizing the User Prompt Dialog Box

    Thank you. That standard crystal prompt is ugly.
  6. MK_USF

    Customizing the User Prompt Dialog Box

    I have approximately 20 prompts for the user to enter before the report is run. The prompt box looks terrible. Is there a way to customize the look? I'm using CR 2008. Thank you in advance for any help. Mike
  7. MK_USF

    Cascading Prompt?

    I have a "yes"/"no" prompt. If the answer is "yes" then force an additional prompt. It is the response to this additional prompt that I want to select/filter on. If its "no" then just do the reset of the select formula. Do I use a cascading prompt? My logic (sorry if this is confusing)...
  8. MK_USF

    Highlighting Parameter Search Results in Text Field

    Thank you, thank you, thank you. Here is the final formula: WhilePrintingRecords; local numbervar i; Local stringvar Note := lcase({ChatMessages.MESSAGE}); for i:=1 to ubound({?Text_To_Search_for}) do ( Note := Replace(Note, Replace(lcase({?Text_To_Search_for}[i]), '*', ''), '<font...
  9. MK_USF

    Highlighting Parameter Search Results in Text Field

    Betty, Your formula works. Hello is in red. Pmax9999, Unfortunately, I can't. Question: I have 174 search terms. In the "default" list of my prompt, I imported a .txt file containing the terms surrounded with an *. The report works but it does not color those search terms red. When I...
  10. MK_USF

    Highlighting Parameter Search Results in Text Field

    Thank you. Now I really am lost. I created a formula called "highlight". I put it in the details section of the report. I get no errors but the result displays in black font. Is there another formula I could try?
  11. MK_USF

    Highlighting Parameter Search Results in Text Field

    Yes. I changed to HTML text interpretation. This has me stumped.
  12. MK_USF

    Highlighting Parameter Search Results in Text Field

    Thank you, Pete. I modified my code to match yours: WhilePrintingRecords; local numbervar i; Local stringvar Note := lcase({ChatMessages.MESSAGE}); for i:=1 to count({?Text_To_Search_for}) do ( Note:= Replace(Note, {?Text_To_Search_for}[i],'<font color=#ff0000>' + {?Text_To_Search_for}[i] +...
  13. MK_USF

    Highlighting Parameter Search Results in Text Field

    Nope. Still states this array must be subscripted. I subscripted your code as follows and replaced the line in my code: replace(lowercase({ChatMessages.MESSAGE}), {?Text_To_Search_for}[i],"<font color=#ff0000>" & {?Text_To_Search_for}[i] & "</font>") ); I got no errors but the text shows...
  14. MK_USF

    Highlighting Parameter Search Results in Text Field

    Thank you. I thought the solution was here. It errors "Local StringVar ValueToSearch := {?Text_To_Search_for};" and says "This array must be subscripted..." I'm simply plugging in my database.field and the parameter. Any idea why its failing?
  15. MK_USF

    Highlighting Parameter Search Results in Text Field

    This is stumping me. The following is the formula I'm using to highlight key words I'm searching a text field for in my database. I need it to highlight/color the word each time it is found in a sentence. The table and field is {ChatMessages.MESSAGE} The prompt is {?Text_To_Search_for} I have...

Part and Inventory Search

Back
Top