[FONT=Tahoma]

Hi,

I am novice in crystal reporting. I have a MSSQL 2008 database in backend and i can generate simple reports. but when any function/user supplied parameter are in operation, i failed to generate any report. would appreciate anyone feedback in earliest convenience.

sample report is attached here. I want to select values which are
"External"
"Inbound" &
12/24/2011 10:00:00 AM to 12/24/2011 04:00:00 PM
http://www.sendspace.com/file/pwkpcb

Regards.

Edited by didar.sust - 02 Jan 2012 at 7:36pm

Hi,

Thanks for your reply. I'm a bit confused where should to put this expression.

In Formula Fields I have created two fields named 1. CallDirection 2. CallType

and from selection expert below formula is added:

{@CallType}="External" and
{@CallDirection}="Inbound"

DateTime field will be supplied by the user when (s)he generates the report. Now i'm stuck in here which fields should i put in the report and how Id will be selected based on DateTime.

Thanks.

1) I wouldn't put this in a formula, I would put it in the Report/Selection Formulas/Record, so that only the records that meet the criteria are allowed on the report (unless that is not the intent).