Adding additional parameters

[cbolton652]

I am using Crystal v9. I am trying to add a new criteria to prompt users when the report is run. Users are currently prompted for the date and I want to add a prompt for product. I went the insert>field object>and added the new parameter however it still does not show in the prompt. I also added this to the select expert and still no prompt. HELP!!!!!!!

 

[kchaudhry]

Are you able to see it under the paramaters in the field explorer? Secondly please share your formula you have used for the parameter. You might also want to show the expected output and some sample data.

Kchaudhry

 

[cbolton652]

Thanks for your reply. And also, I am on 8.5 not 9. But yes I can see it under field explorer > parameter field. This is how my SQL view looks. The date prompts but not the product id

WHERE
vwNCTA_ExpoRevenueByCompany.OrderDate >= {ts '2004-03-11 00:00:00.00'} AND
vwNCTA_ExpoRevenueByCompany.OrderDate < {ts '2004-03-12 00:00:00.00'} AND
vwExpos.ProductID > 0

 

[bdreed35]

Please post your Record Selection Criteria by copying and pasting the code under Report, Edit Selection Formula, Record.

My guess is that you haven't actually included the Product parameter in the selection criteria.

It should be something similar to this:

{vwNCTA_ExpoRevenueByCompany.OrderDate} = {?DateParm}
AND
{vwExpos.ProductID} = {?ProductParm}

~Brian

 

[cbolton652]

Thanks Brian, here it is. I used >0 to prompt for any code

Record Selection Formula Editor view.

{vwNCTA_ExpoRevenueByCompany.OrderDate} >= {?StartDate} and
{vwNCTA_ExpoRevenueByCompany.OrderDate} <= {?AsOfDate} and
{vwExpos.ProductID} > 0

 

[kchaudhry]

You are referencing the field name not the parameter. You might want to try what Brian suggested in his post.

{vwNCTA_ExpoRevenueByCompany.OrderDate} >= {?StartDate} and
{vwNCTA_ExpoRevenueByCompany.OrderDate} <= {?AsOfDate} and
{vwExpos.ProductID} = {?ProductParm}

Please try this and post your results.

Kchaudhry