|
-
Apr 27th, 2008, 05:16 AM
#1
Thread Starter
Hyperactive Member
few questions regarding crystal reports
hi i am new to vb.net 2003 and crystal reports i have some questions would love someone answering...and would b really greatful for the replies...
i am using vb.net 2003 and ms-access
my prob. is
1. i have a amt. field in the table and in the report i would like to have that if the actype in the table is D then the col. of the amt field should b Debit Amt other wise credit amt. what i have done is create 2 formula fields dramt and cramt and show it respectivly...but my prob is i have to give it as
Code:
iif(actype = "D",amt,0)
and the opp. for "C" but i have to put both the field so it shows 0 in dr. or cr. and the other col shows the amt. is there any way to not show 0
2. i have 5 lines for details which i am showing in the report but mostly only the 1st 2 lines r filled....but then too i have to leave the space for the rest 3 lines...andway that the lines would b completly omitted...
i hope i am making myself clear...
would b highly obliged for ur replies....thankx in advance...
-
Apr 28th, 2008, 02:44 PM
#2
Re: few questions regarding crystal reports
For 1.- Format Field / Customize / Check Supress If Zero
For 2.- Try Section Expert / Select desired Section / Check Keep Together
-
Apr 28th, 2008, 05:24 PM
#3
Thread Starter
Hyperactive Member
Re: few questions regarding crystal reports
 Originally Posted by jggtz
For 1.- Format Field / Customize / Check Supress If Zero
For 2.- Try Section Expert / Select desired Section / Check Keep Together
thankx for ur reply jggtz....but can u pls. describe in detail....i am totally new to vb.net 2003 and crystal reports....
thankx once again....
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|