INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...I frequent other newsgroups, too, and am MOST IMPRESSED with the lack of smart a-- and presence of genuine desire to help anyone of any skill level..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > Reporting Solutions > Business Objects: Crystal Reports 1 Formulas Forum

How to pass the User Input values to Parameters

Read More Threads Like This One

kavithapedada (Programmer)

1 May 12 21:39

Dear All,

I have one urgent issue ,
Exmaple: user passes the YEAR = 2012 and Period = 5 (May)then
In one Colunm i want to Year value and Period = 5(May)-4(April) and onemore Colunm 4(April)-3 (March) like need to subract it.

Could you please help me how to archive it.

Regards.

crystalkiwibruce (Programmer)

1 May 12 23:40

Create a Formula of
Date({?Year},{?Period},1) and format it as MMM-yyyy

For the previous month
if {?Period}=1
then Date({?Year}-1,12,1)
else Date({?Year},{?Period}-1,1)

A Date Heading could then be
ToText({@This Period},"MMM") + "-" + ToText({@Previous},"MMM")

Bruce Ferguson
www.crystalkiwi.com/nlog.htm

kavithapedada (Programmer)

2 May 12 0:18

Hi Bruce,
Many thansk for the replay ,

"If users Enter the Parameters Year = 2012 And Period = 5"

1. Coulnm It should show the value field with Year = 2012 and Period{( 5(May) - 4(April)} and
2.Second colunm need show value field information with Year = 2011 and Period = { (May) -( April)}
3.Third one coulnm need to show the Year = 2012 and Period = { April - March}
4. Four Coulnm Need to Show the Year = 2011 and Period = { April - March}

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Business Objects: Crystal Reports 1 Formulas