Print only first 2 values in table field.

[former_member1110314]

Hi there,

I have a table field in my report that may contain anywhere up to 100 values for any one database record... however for each database record, I only want the first 2 values of this field to be included in the report.

It seems like a simple concept... can anyone assist?

cheers

-KB

[Former Member · Accepted solution]

There are several ways to do this. Here's one way that may work for you.

Create a running total called CountValues.

Use count the field values for each database record. Make sure you reset it for each database record.

Then go to section expert. Go to the section that is printing your values -> Click the X+2 next to suppress-> Insert this logic:

{#CountValues} > 2

This should suppress all but the first two records for each database record.

I hope this helps,

Regards,

Zack H.

[former_member1110314 · Accepted solution]

Many thanks Zack, that was just what I needed!

I also want to run a comparison on the two resultant values, ie. I want to show the numerical and percentage change from value 2 to value 1. Are you also able to assist with that?

cheers

-Karen