tags:

views:

23

answers:

1

Hi,

I have around 8 columns that are retrieved from the database using iReport. For the first 3 columns, i want to print them only if their combination is unique. Can someone help on this?

Thanks, Karthik

A: 

I don't know how to handle this in iReport. But you can handle this very easily with the query.

Multiplexer
well, actually i will be fetching all the 8 columns(required) by using the query. Then, from the iReport i want to print only the unique combinations of first 3 columns. It the unique combination is repeated in the next record, that should be left blank.
Karthik
I think you can do this using the variables. Create some variables. Assign the query results to this variables and play around it.
Multiplexer

related questions