nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Delete First Data Set Row

zax

Hi,

This sounds easy, but I am struggling to know how to start. I am using MySQL and Birt 3.7.2.

I have a customer who has a database containing some bad data and they don't want to show the first row in datasets in a particular report. I know, rubbish in, rubbish out. But we are where we are....

So how can I remove the first data set row? I have a chart that uses the table derived from the dataset, which also needs to have that first row missing. Any ideas how to remove the first row of a dataset?

I could go down the SQL route, but as the number of rows is small (<50) and the database is ever growing, I thought Birt would be the best place to do this.

Thanks in advance,
Stephen

Find more posts tagged with

Comments

Tubal

You should be able to put a filter on your table (or dataset) and remove row number one.

Add a computed column to your dataset, name it rowNum (or whatever), and datatype integer, aggregation is running count.

Then add a filter to your table (and chart) on the new rowNum column you created so it's greater than 1.

Tubal

Double Post. Sorry.

BRM

if you are sure you won't truncate rows returned you could do LIMIT 2,9999.

lfreeman

If you "go down the SQL route", you can end the query with "limit x offset 1". x being the number of rows you want to return, and "offset 1" skipping the first row.

zax

Hi All,

Thanks, all good ideas. I think the simplest is to use the LIMIT SQL as this is simple and obvious to anyone looking at the SQL of the report.

I have implemented it in the report and it makes the bad chart look good.. thanks again.

Stephen