How to pass the User Input values to Parameters

[kavithapedada]

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]

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

http://www.crystalkiwi.com/nlog.htm

 

[kavithapedada]

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}