Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Delete First Data Set Row
Migrateduser
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
There are no comments yet