Databases
StackOverflow2013
Postsdbo
POHow to concatenate the first and last value of field and hide a specific record in table group footer in IReport
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to concatenate the first and last value of field and hide a specific record in table group footer in IReport
    primarykey
    data
    text
    <p>I have a table component which shows some records in a group of year like this</p> <p>For example:</p> <pre><code>Year Month SumMonth //group header 2009 Jan 1000 //table details Feb 2000 Mar 3000 2009 xxxx 6000 //group year footer 2010 Jan 1100 //table details Feb 1200 2010 xxxx 2300 //group year footer </code></pre> <p>The "xxxx" part in the above table is which i need to modify.</p> <p>I want to display the format like this:</p> <p>"<strong>Jan-Mar</strong>" (for 2010 is "<strong>Jan-Feb</strong>")</p> <p>The question is how to get the value of <strong>first month</strong> and <strong>last month</strong> and concatenate them into a variable (or not need to?), so that I can put it into footer?</p> <p>The other problem is that how can I hide the records in specific year?</p> <p>For example the final modified display may like this:</p> <pre><code>Year Month SumMonth //group header 2009 Jan-Mar 6000 //group year footer 2010 Jan 1100 //table details Feb 1200 2010 Jan-Feb 2300 //group year footer </code></pre> <p>You can see the whole records in 2009 are hided in the above table. Which options or what expression should I set?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USuser1264222
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow to concatenate the first and last value of field and hide a specific record in table group footer in IReport
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload