Results 1 to 3 of 3

Thread: few questions regarding crystal reports

  1. #1

    Thread Starter
    Hyperactive Member kuldevbhasin's Avatar
    Join Date
    Mar 2008
    Location
    Mumbai, India
    Posts
    493

    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...

  2. #2
    Frenzied Member
    Join Date
    May 2006
    Location
    some place in the cloud
    Posts
    1,886

    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

  3. #3

    Thread Starter
    Hyperactive Member kuldevbhasin's Avatar
    Join Date
    Mar 2008
    Location
    Mumbai, India
    Posts
    493

    Re: few questions regarding crystal reports

    Quote 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
  •  



Click Here to Expand Forum to Full Width