Results 1 to 13 of 13

Thread: Show Fields in Reports Only Which have 0

  1. May 26th, 2005, 06:35 AM #1
    Kernel^Doli
    Kernel^Doli is offline

    Thread Starter
    Junior Member Kernel^Doli's Avatar
    Join Date
    May 2005
    Posts
    22

    Show Fields in Reports Only Which have 0

    Hello Friends!
    I am building a project in which i want to show only those fields in Crystal Reports which have 0 Value.
    I am using: -

    1) Crystal Reports
    2) One Table


    Also attaching my Project so that i got a perfect answer.


    Regards!
    Attached Files Attached Files
    Reply With Quote Reply With Quote
  2. May 26th, 2005, 08:10 AM #2
    Pasvorto
    Pasvorto is offline
    PowerPoster Pasvorto's Avatar
    Join Date
    Oct 2002
    Location
    Minnesota, USA
    Posts
    2,951

    Re: Show Fields in Reports Only Which have 0

    I would create a formula, instead of using the field. then:

    If {fieldname} = 0 then "0" else " "
    Reply With Quote Reply With Quote
  3. May 26th, 2005, 11:21 AM #3
    Kernel^Doli
    Kernel^Doli is offline

    Thread Starter
    Junior Member Kernel^Doli's Avatar
    Join Date
    May 2005
    Posts
    22

    Re: Show Fields in Reports Only Which have 0

    I have so many columns like
    January, February, March... December
    In this case what u will do?
    Reply With Quote Reply With Quote
  4. May 26th, 2005, 11:49 AM #4
    Kernel^Doli
    Kernel^Doli is offline

    Thread Starter
    Junior Member Kernel^Doli's Avatar
    Join Date
    May 2005
    Posts
    22

    Re: Show Fields in Reports Only Which have 0

    We can use here a formula like:
    SelectionFormula = "IIF{Fee.April}{Fee.August}{Fee.December}{Fee.February}{Fee.January}{Fee.July}{Fee.June}{Fee.March}{ Fee.May}{Fee.November}{Fee.October}{Fee.September} = 0 Then "0" Else "Fee Paid"
    But i don't know the correct syntax of this formula.
    Please any brother can guide me.
    I am looking for this formula or any other way to solve this

    Thanks in advance.

    Regards!
    Kernel
    Reply With Quote Reply With Quote
  6. May 26th, 2005, 10:24 PM #5
    kulitag
    kulitag is offline
    Hyperactive Member
    Join Date
    Mar 2005
    Location
    Manila, Philippines
    Posts
    486

    Re: Show Fields in Reports Only Which have 0

    hope this will help
    Attached Files Attached Files
    Reply With Quote Reply With Quote
  7. May 27th, 2005, 05:10 AM #6
    Kernel^Doli
    Kernel^Doli is offline

    Thread Starter
    Junior Member Kernel^Doli's Avatar
    Join Date
    May 2005
    Posts
    22

    Re: Show Fields in Reports Only Which have 0

    Yes brother,
    Thank you very much for help
    But please tell me how you did this?


    Thanks in Advance
    Waiting for ur reply.

    Kernel!
    Reply With Quote Reply With Quote
  8. May 27th, 2005, 05:24 AM #7
    kulitag
    kulitag is offline
    Hyperactive Member
    Join Date
    Mar 2005
    Location
    Manila, Philippines
    Posts
    486

    Re: Show Fields in Reports Only Which have 0

    open my report then under main menu, goto report then select expert
    Reply With Quote Reply With Quote
  9. May 27th, 2005, 09:03 AM #8
    Kernel^Doli
    Kernel^Doli is offline

    Thread Starter
    Junior Member Kernel^Doli's Avatar
    Join Date
    May 2005
    Posts
    22

    Re: Show Fields in Reports Only Which have 0

    I think u did not see my Crystal Report File...
    I tried what u say, but still have some problems
    My Table has 12 coloums in which program must have to check value 0 from these 12 coloums.
    If i put 0 value in 12 coloumns then program show me the result in report, other wise blank. I want that if just a single coloumn have 0 value then the complete 12 columns show me the record.
    Reply With Quote Reply With Quote
  11. May 28th, 2005, 02:46 AM #9
    kulitag
    kulitag is offline
    Hyperactive Member
    Join Date
    Mar 2005
    Location
    Manila, Philippines
    Posts
    486

    Re: Show Fields in Reports Only Which have 0

    the problem is i can not open your report, post your report and the database connecting to it, just the report and the database, not the whole project
    Reply With Quote Reply With Quote
  12. May 28th, 2005, 04:53 AM #10
    Kernel^Doli
    Kernel^Doli is offline

    Thread Starter
    Junior Member Kernel^Doli's Avatar
    Join Date
    May 2005
    Posts
    22

    Re: Show Fields in Reports Only Which have 0

    Here i am attaching my database and report...

    I want if only one Field e.g. "March" have '0' Then the whole row show. If any row don't have '0' value then Now show.


    Thanks for helping.

    Kernel
    Attached Files Attached Files
    Reply With Quote Reply With Quote
  13. May 29th, 2005, 05:37 AM #11
    Kernel^Doli
    Kernel^Doli is offline

    Thread Starter
    Junior Member Kernel^Doli's Avatar
    Join Date
    May 2005
    Posts
    22

    Re: Show Fields in Reports Only Which have 0

    Any Sugession " kulitag " ?

    Waiting for ur reply.
    Reply With Quote Reply With Quote
  14. May 29th, 2005, 05:43 AM #12
    Kernel^Doli
    Kernel^Doli is offline

    Thread Starter
    Junior Member Kernel^Doli's Avatar
    Join Date
    May 2005
    Posts
    22

    Re: Show Fields in Reports Only Which have 0

    Any Sugession " kulitag " ?

    Waiting for ur reply.
    Reply With Quote Reply With Quote
  15. May 29th, 2005, 07:52 PM #13
    kulitag
    kulitag is offline
    Hyperactive Member
    Join Date
    Mar 2005
    Location
    Manila, Philippines
    Posts
    486

    Re: Show Fields in Reports Only Which have 0

    can't really understand but i really try though
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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