Automatically selecting the Month Prior

[Palmbak]

I am posting reports to Crystal Enterprise, is there any formula that I can use that will select the prior month for reporting purposes.

At the month end, we have 30 or so reports with parameters, is there any way I can use a formula instead of a parameter?

Regards,
Jon

 

[mbarron]

The following will bring back last month's data:

datediff("M",{your.date.field} ,currentdate)=1 Mike

 

[cmpgeek]

i do not know what Crystal Enterprise is; will this also work in Crystal 8.5?

 

[mbarron]

It should. I'm using CR8 Mike

 

[Palmbak]

Crystal Enterprise is a Web Based method to deliver your Crystal Reports.

If you want some info regarding Crystal Enterprise go to
(

http://www.crystaldecisions.com/products/crystalenterprise/overview.asp)

Cheers,

Jon

PS. Thanks for responding Mike!!

 

[mbarron]

Does it work? Mike

 

[cmpgeek]

Thanks for the URL Jon! I will check it out ASAP.

ShannonLea

 

[Palmbak]

Mike,

Not yet, but it will, you see, I am not writing it against a SQL Database, I am actually writing against a UniVerse Database. The parameters I wish to replace with formulas are {?Year} and {?Month}.

Example:
if {?Month}="1"
then {AT_CLIENT.HRSH_WKD_THRU_MTH1}
else if {?Month}="2"
then {AT_CLIENT.HRSH_WKD_THRU_MTH2}
else if {?Month}="3"
then {AT_CLIENT.HRSH_WKD_THRU_MTH3}
else if {?Month}="4"
then {AT_CLIENT.HRSH_WKD_THRU_MTH4}
else if {?Month}="5"
then {AT_CLIENT.HRSH_WKD_THRU_MTH5}
else if {?Month}="6"
then {AT_CLIENT.HRSH_WKD_THRU_MTH6}
else if {?Month}="7"
then {AT_CLIENT.HRSH_WKD_THRU_MTH7}
else if {?Month}="8"
then {AT_CLIENT.HRSH_WKD_THRU_MTH8}
else if {?Month}="9"
then {AT_CLIENT.HRSH_WKD_THRU_MTH9}
else if {?Month}="10"
then {AT_CLIENT.HRSH_WKD_THRU_MTH10}
else if {?Month}="11"
then {AT_CLIENT.HRSH_WKD_THRU_MTH11}
else if {?Month}="12"
then {AT_CLIENT.HRSH_WKD_THRU_MTH12}

 

[cmpgeek]

just to bug yall again... will it work against an oracle 8.1 database?

( i swear i am going to learn more about the back side of things when / if this side of things calms down...)

shannon

 

[Palmbak]

Will what work against Oracle 8.1? =)
Enterprise or formula?


Jon

 

[cmpgeek]

lol... how about both?

 

[Palmbak]

Enterprise will, but the cost is phenomenal ($45,000) for a server license. If you need a cheap way of emailing out your reports, let me know. (jppalmbak@llgm.com)

The formula looks pretty standard, I believe that will work as well; if I am incorrect in my assumption, please step in.

 

[synapsevampire]

There are numerous third party products for viewing and distributing Crystal Reports, check out:

http://www.kenhamady.com/bookmarks.html

-k

 

[Palmbak]

Yup, Ido Millet has an application called "Visual CUT" which is real cheap and an all around "awesome" product.

http://www.milletsoftware.com

Highly recommended!!!!!


Cheers,

Jon

 

[cmpgeek]

i just came across something... there is a function in Crystal for this exact purpose which is alot simpler... next time you are trying something where you need the complete month prior... all you have to do is type in something like this example:

{case.casedate} in LASTFULLMONTH

this has been a God send to me as we also have around 30 reports to run at month end - and even more at quarter end and so on...

hope this helps someone ShannonLea