Skip to Content

Using a Parameter in place of a PLACEHOLDER in Crystal Reports

Hi All

I am trying to use a parameter in command based on a Data model (AgingQuery).

I want the user to choose the date, so I created a date parameter. I have tried different ways in using this parameter with the PLACEHOLDER, but its not working.

Is it possible to do this? If so, any idea on how?

Thank you.
Jerusha

crystal-report.jpg (36.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jun 08, 2017 at 03:58 PM

    For more information about how to use parameters in commands, please see my blog post here: https://blogs.sap.com/2015/04/01/best-practices-when-using-commands-with-crystal-reports/

    -Dell

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 06, 2017 at 02:55 PM

    Your SQL syntax looks odd.

    You need to modify query to use a where clause something like

    Where Appropriate datefield = {?Date1}

    Make sure the datefield is a date rather than a datetime. If it is a datetime cast or convert to date.

    Ian

    Add comment
    10|10000 characters needed characters exceeded