Announcements
 Crystal Reports Forum : General Information : Announcements
Message Icon Topic: Parameter setup query Post Reply Post New Topic
Author Message
Gerard Boyle
Newbie
Newbie
Avatar

Joined: 03 May 2013
Location: Ireland
Online Status: Offline
Posts: 1
Quote Gerard Boyle Replybullet Topic: Parameter setup query
    Posted: 06 May 2013 at 10:40pm
I am new to Crystal Reports and have a query as to how I resolve an issue that I have with a report. I need to be able to run the report in 2 different ways and want to be able to allow this to be controlled by a parameter. I have a field in a table acctrans.outsbal which contains the outstanding balance on a customers account. I want to be able to run this report to select the customers either when the outsbal is = 0 or when it is <> 0.
How can I create a parameter to allow me to select which way I want the report to run.
IP IP Logged
Abhi
Newbie
Newbie


Joined: 23 Jul 2012
Online Status: Offline
Posts: 12
Quote Abhi Replybullet Posted: 09 Jun 2013 at 6:36am
Hi Boyle

Well you can do this

Step 1: create a static parameter {?balance} with two user input values as balance zero and balance not zero.

Step 2: Goto report selection formula now and write this below code.

if {?balance} = "balance zero" then
acctrans.outsba = 0
else
{?balance} = "balance not zero" then
acctrans.outsba <> 0

Note: All you you need to make sure that DB field outsba is Key figure.

Thanks
Abhi
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.063 seconds.