Parameter Field

[campbere]

I am using CR 6. Is it possible to base a query off of parameter values? I have a report based on a query. However I need the query to be based on the users date values that are entered.

Can this be done?

 

[dcm]

Yes. In the SQL Designer create a parameter as part of the query (Edit on the menu). Then recreate the parameter in your report and the response will be passed to your query David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Crystal Decisions Enterprise Partner

 

[campbere]

Ok I am not sure how to create a parameter as part of the query.

This is my sql statement:

select name,
count(distinct label) CDS,
count(issn) ISSUES
from issue_tracker
where TASK_END is not null
and NAME is not null
and LABEL != 'NONE'
group by name

How do I create the parameter part in my query? I want parameters that ask for a start date and end date. Basically the user is determining a reporting time. So I would like the report numbers to be based on task_end >= Start Date and task_end <= End Date.