Crystal Reports Onlastrecord Delete

Data Connectivity
Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity

Topic: Onlastrecord Delete

Author	Message
rapt6rr Newbie Joined: 03 Mar 2011 Online Status: Offline Posts: 2	Topic: Onlastrecord Delete Posted: 03 Mar 2011 at 6:36am
	Hi I imported a CSV-File. The last line contains only datatrash. How can i delete the last line of my imported CSV-File? Onlastrecord = delete? greetz rapt6rr
	IP Logged

hilfy Admin Group Joined: 20 Nov 2006 Online Status: Offline Posts: 3702	Posted: 04 Mar 2011 at 3:58am
	You can't. However, you can: 1. Set selection criteria to not read the last record with something like this: {csvtable.field1} <> 'datatrash' or 2. Set suppress formulas on any group and details sections to not show the last record by going to the section expert, clicking on the formula button to the right of the Suppress checkbox (do NOT check the checkbox!), and entering the following: OnLastRecord -Dell
	Proviti, Data & Analytics Practice www.protiviti.com/US-en/data-management-advanced-analytics
	IP Logged

rapt6rr Newbie Joined: 03 Mar 2011 Online Status: Offline Posts: 2	Posted: 04 Mar 2011 at 9:22am
	*Originally posted by hilfy* You can't. However, you can: 1. Set selection criteria to not read the last record with something like this: {csvtable.field1} <> 'datatrash' or 2. Set suppress formulas on any group and details sections to not show the last record by going to the section expert, clicking on the formula button to the right of the Suppress checkbox (do NOT check the checkbox!), and entering the following: OnLastRecord -Dell I need some help! csvtable.field1 is datatyp a number When csvtable.field1 has no content ( 0 is a content )then dont show the line! Every time i get an error with "" as no content...
	IP Logged

hilfy Admin Group Joined: 20 Nov 2006 Online Status: Offline Posts: 3702	Posted: 07 Mar 2011 at 10:16am
	Use 0 instead of "". -Dell
	Proviti, Data & Analytics Practice www.protiviti.com/US-en/data-management-advanced-analytics
	IP Logged

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.031 seconds.