SAP (Documents/Screen shots/Complete Solution): RE:[visualbasic-l] Crystal Report Record Selection Not Working Properly

Reply from aghoo on Jun 11 at 2:17 AM

thanks for your reply..

i just set a new formula field with nama 'UnitDate' with just 'prindate' inside that formula field.

---------------Original Message---------------
From: aghoo
Sent: Wednesday, June 06, 2012 2:38 AM
Subject: Crystal Report Record Selection Not Working Properly

Hi everyone,

please help me, I have no idea anymore what to do.
the situation is like this:-

i have to create a report where the selection data is within 1 month only based on month and year of prindate.
so I create a new formula to set prindate with name (UnitDate).

i tried use the record selection formula like this

{EVENT.date} > (DateSerial(Year({@UnitDate}), Month({@UnitDate}) + 0, 1-1))
AND
{EVENT.date} <= (DateSerial(Year({@UnitDate}), Month({@UnitDate}) + 1, 1-1))

or

Month({EVENT.date}) = Month({@UnitDate})
AND
Year({EVENT.date})= Year({@UnitDate})

both of this formula was successful to display the record in local machine..but the problem is when I deploy the record to the weblogic server, crystal report will display all the data not only 1 month..

what should I do? do my formula is wrong or maybe I need to setting somewhere?
please help me.

Thanks.

Reply to this email to post your response.

__.____._

Manage Settings | Unsubscribe | Create FAQ | Send Feedback