Ok, so below is the template START EXPRESSION...

expressions
(Steven Jeffery) #1

Ok, so below is the template START EXPRESSION and IF EXPRESSIONS, that I am using for my template.

It works, but it is still leaving “DEAD SPACE” because it is running the ‘Start’ and ‘End’ expression, but simply not putting anything there, if there isnt something to put there.

I would like to write a Start Expression, that ONLY pulls in fields with data in them.

INSTEAD of looking for data and inserting blank’s if it does not find anything.

How??

<<Start: [Related Site Equipments [Company]]>>

<<IF( ISBLANK([recentservicerecord]), ””, “Technicians That Performed Repairs For Following Equipment:”)>>

<<IF( ISBLANK([recentservicerecord]), ””, ([recentservicerecord].[Technician#1]))>>
<<IF( ISBLANK([recentservicerecord]), ””, ([recentservicerecord].[Technician#2]))>>
<<IF( ISBLANK([recentservicerecord]), ””, ([recentservicerecord].[Technician#3]))>>
<<IF( ISBLANK([recentservicerecord]), ””, ([recentservicerecord].[Technician#4]))>>

<<IF( ISBLANK([recentservicerecord]), ””, “Technician Resolution & Any Additional Findings During Repair.”)>>

<<IF( ISBLANK([recentservicerecord]), ””, CONCATENATE("Unit Tag#: ", [recentservicerecord].[Unit Tag#]) )>>

<<IF(ISBLANK([recentservicerecord]),””,CONCATENATE(“Unit Summary Notes:”, [recentservicerecord].[ Unit Notes Summary]))>>

<<IF(ISBLANK([recentservicerecord]),””,CONCATENATE(“Technician Recommendations:”, [recentservicerecord].[Technician Recommendations]))>>

.<>

(Steven Jeffery) #2

[recentservicerecord] = a virtual column with MAXROW reference, so it finds the most current service record.

(Philip Garrett) #3

@Steven_Jeffery

We don’t really support this ability.

Your approach will work to suppress both the label and the field value when the field is empty.

However, I am not sure how effective the approach will be at altogether eliminating the empty space from the resulting document. Any

HTML elements that remain in the template will be honored.

It is conceivable that if you put most or all of the expressions together with no

elements intervening you can get close. I have never tried that, so I am speculating.

(Steven Jeffery) #4

what is

?

Sorry, I am a HTML Dummy! :slight_smile:

(Philip Garrett) #5

is a Paragraph element. It starts a new paragraph.

(Steven Jeffery) #6

Is there an expression, to search records and find ones that are alike?

Here is what I need the expression to do:

I have various pieces of equipment, with various materials per piece of equipment.

Example:

Unit #1 has (2) 20x20x2 filters. Unit #2 has (4) 20x25x2 filters. Unit #3 has (4) 20x20x2 filters. -same as unit #1 w/different qnty. Unit #4 has (2) 20x25x2 filters. -same as unit #2 w/different qnty.

I would like to run an expression in the template, or app if easier, to search records for the filter sizes that are the same, and then be able to calculate the TOTAL filter qnty, for each size.

So in essence, having the report return something like this: Filter Sizes: 20x20x2 = (6) 20x25x2 = (6)

What would be the best way to do this? I was trying to figure out how to have the template calculate this, but if I should build a VC that calculates these, that would be fine also.

Thanks, Steven