Search results for query: *

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

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

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

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

Thank you. That standard crystal prompt is ugly.

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

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

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

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

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?

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

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

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

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?

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