Skip to Content
0

Using a Parameter in place of a PLACEHOLDER in Crystal Reports

Jun 06, 2017 at 10:56 AM

53

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Dell Stinnett-Christy Jun 08, 2017 at 03:58 PM
1

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

Share
10 |10000 characters needed characters left characters exceeded
Ian Waterman Jun 06, 2017 at 02:55 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded