Search results for query: *

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

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

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

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

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.

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

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

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

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

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

Do you have any other groups above this group?

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

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.

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}

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

It can be done by using subreports.

Do you have null values in the text field?

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)

Did you check if there are any Suppress conditions?

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