Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: To sort certain data Post Reply Post New Topic
Author Message
lalakeyorai
Newbie
Newbie


Joined: 01 Nov 2009
Online Status: Offline
Posts: 19
Quote lalakeyorai Replybullet Topic: To sort certain data
     Posted: 02 Nov 2009 at 8:04pm

I’m using CR 2008 and i'm a new user of CR 2008

 

My question is, how can i sort data in order to make sure only consist data that have " IF-‘IP address’/ [se*/*/*] " regardless the number in the square bracket is appear in my report. As long as the data have [se / / ], the data is needed. is there any relevent syntax that i can use? please advice me...

 

Here’s the example of my data:

 

IF-10.10.1.33/143 [Mu1]

IF-10.10.1.2/112 [v/112]

IF-172.20.11.12/1 [se0/2/1]

IF-172.20.11.25/4 [se0/2/1]

IF-172.20.22.10/7 [se0/2/0]

IF-172.20.22.10/9 [se0/2/0]

FAN-173.20.21.10/1 [fan 1]

IF-173.20.135.10/4 [BR0/2/0]

IF-173.20.136.10/3 [se0/1/0]

IF-173.20.137.10/7 [se0/1/0]

            IF-173.20.22.10/14 [BR2/0:1]

IF-173.20.24.10/5 [BR2/0:2]

IF-173.20.24.10/11 [se0/0/1]

 

IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Quote lockwelle Replybullet Posted: 03 Nov 2009 at 6:30am
is this all one data field?  If so, you can suppress the row/cell as desired or filter the data out in the Report/Selection Formula/Records all using the same basic code...
if instr({table.field},"[se") > 0 then ...
 
HTH
IP IP Logged
lalakeyorai
Newbie
Newbie


Joined: 01 Nov 2009
Online Status: Offline
Posts: 19
Quote lalakeyorai Replybullet Posted: 03 Nov 2009 at 8:00am
Thank you very much for your reply.
 
those data was an example data so that you can get the idea of what im trying to do. there are almost 4000+ data in the actual database. so, since i have a large number of data, can i still using the syntax that you have suggested?
IP IP Logged
lalakeyorai
Newbie
Newbie


Joined: 01 Nov 2009
Online Status: Offline
Posts: 19
Quote lalakeyorai Replybullet Posted: 03 Nov 2009 at 5:51pm

Ohh, sorry... and forgot to mention that those data are fall into one group called 'component name'. besides component name, there where also another columns of group which appeared in one same report.

IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Quote lockwelle Replybullet Posted: 04 Nov 2009 at 6:08am
if you are applying a filter, and you ONLY want records that start se in the [] section, then yes, all other considerations don't matter, as you are getting rid of the records that you don't want.  If you only want to filter inside of a certain value, then you would need to modify the filter to only get rid of the 'bad' records that match the condition.
IP IP Logged
lalakeyorai
Newbie
Newbie


Joined: 01 Nov 2009
Online Status: Offline
Posts: 19
Quote lalakeyorai Replybullet Posted: 04 Nov 2009 at 6:39am
definitely the solution that i was looking for... thank you so much for your help... its really helpful...
 
thank you so verry much for your help...
IP IP Logged
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