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...
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" ;
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...
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 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)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.