Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Report selection Post Reply Post New Topic
Author Message
araldo200
Newbie
Newbie
Avatar

Joined: 03 Aug 2007
Location: Philippines
Online Status: Offline
Posts: 5
Quote araldo200 Replybullet Topic: Report selection
    Posted: 22 Oct 2007 at 1:07am

Hi to every body on the house!

Especially to the expert and sir brian.

I am too far from your knowledge about crystal report that's why I'm not hesistant to ask you this question or share my problems in CR 10.  I'm hoping that one of you guys could help me.

This is it. In my report I want to display one database field called ACCOUNTNAME in two colums for example :

given: ACCOUNTNAME = contribution

          ACCOUNTNAME  = loan

In such a way the report looks like this:

     Name                contribution       loan

     Richard              P200.00            P500.00

I'm making two parameters to select the two accountname but it didn't work.  Can you help me please.

thanks and more power

araldo200, Philippines

 

 
denrcenro
IP IP Logged
jkwrpc
Senior Member
Senior Member


Joined: 19 Jun 2007
Location: United States
Online Status: Offline
Posts: 432
Quote jkwrpc Replybullet Posted: 22 Oct 2007 at 7:26am
You should be able to create two formulas that display the datafield AccountName. Name them something meaningful to you such as AccntNameContribution and AccntNameLoan.
 
Start with AccntNameContribution,  format the field and select suppress using formula (the X-2) button. Enter for the contribution information:
 
AccountName<> "Contribution"
 
In the second formula,AccntNameLoan, do the same but enter for the Loan information:
 
AccountName<> "Loan"
 
Since suppression works when something is true, it should only show values you want.
 
Hope this helps.
 
Regards,
 
John W.
IP IP Logged
araldo200
Newbie
Newbie
Avatar

Joined: 03 Aug 2007
Location: Philippines
Online Status: Offline
Posts: 5
Quote araldo200 Replybullet Posted: 22 Oct 2007 at 9:29pm
Thank you sir John W. for your advise I will try it sir.
 
araldo200, Philippines
denrcenro
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.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.