Print Page | Close Window

CR 11, MySQL command and parameters Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2022 Forum Name: Data Connectivity Forum Discription: How to connect to data sources and export reports URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=20034 Printed Date: 20 Apr 2025 at 6:50am Topic: CR 11, MySQL command and parameters Posted By: kevlray Subject: CR 11, MySQL command and parameters Date Posted: 18 Sep 2013 at 8:31am I am attempting to use a command in CR 11 that has MySQL as a data source.  The issue is that I cannot seem to find the correct syntax for adding a parameter in the SQL.  I have tried enclosing with singe quotes ('{?Start Date'}"), no quotes and quotes with an percent sign ('%{?Start Date}%').  I get a variety of syntax errors. Replies: Posted By: kostya1122 Date Posted: 23 Sep 2013 at 6:57am if you are using a command and create the parameter inside the command it should be as simple as where table.field = {parameter}

Print Page | Close Window