Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Tips and Tricks
Message Icon Topic: Remove Rows That feild is Empty Post Reply Post New Topic
Author Message
arminkhodaei
Newbie
Newbie


Joined: 30 Aug 2012
Online Status: Offline
Posts: 5
Quote arminkhodaei Replybullet Topic: Remove Rows That feild is Empty
    Posted: 30 Aug 2012 at 6:36pm
Hello All;
First of all, Excuse me for my bad english :)
 
I Have A report from access DB. From 1 week ago, suddenly My Report get Two additional Record.
 
in all of my reports this two record shown.
 
so, i remove this records from my Database. But dont remove from my Reports !
 
This two record always showed in ID 1 and 2 !
 
is like This :
 
 
ID               Name               Family
1                 Joe                  x
1                 Mark                y
2                 Steev               h
2                 Mark                y
3
4              --Other is Good--
6
 
 
 
Plaese Help Me ....
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 31 Aug 2012 at 4:07am
Please do not cross-post.  I have answered your question here: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=17468
-Dell
IP IP Logged
zanyar-Jalal
Newbie
Newbie
Avatar

Joined: 06 Sep 2012
Location: Iraq
Online Status: Offline
Posts: 12
Quote zanyar-Jalal Replybullet Posted: 12 Sep 2012 at 8:13pm
Dear arminkhodaei :

First: you should proud yourself because you try to speak English, no matter how is your English the most important thing is that you are try.

Second: what edit ever you do on crystal report does not influence your data base that is why when you delete those rows in your database it is not deleted on your report,

Third: you can solve this problem in a very simple way.

Forth: Right click on name field -> format field ->select common tab -> chose suppress then click on X-2 , write this code:

{Name}='Mark'
then press OK.


do this again for Family field.

you can see this image:

      [IMG]http://www.google.iq/imgresq=field+editor+in+crystal+reports&num=10&hl=en&biw=1366&bih=667&tbm=isch&tbnid=jvplrlEJ6W1SMM:&imgrefurl=http://www.exea.nl/Docs/DocViewx%3FDocumentID%3D%257Bc749b25a-5c07-4081-8949-8a0eb1ce9f03%257D%26noheader%3D1%26nosubject%3D1&docid=k2yI7dJ_Zd-tIM&imgurl=http://www.exea.nl/Docs/DocBinBlobx%253FID%253D%25257Be7f16848-ba7d-46bb-aa5d-aed0bac9d6a9%25257D&w=445&h=546&ei=andRULHALonmtQaF-oDYBQ&zoom=1&iact=hc&vpx=259&vpy=160&dur=3087&hovh=249&hovw=203&tx=78&ty=126&sig=105888902109916711805&page=3&tbnh=145&tbnw=118&start=42&ndsp=25&ved=1t:429,r:14,s:42,i:253" />

Edited by zanyar-Jalal - 12 Sep 2012 at 8:19pm
IP 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.016 seconds.