Change a query on a crystal report at design or runtime
Posted on 2013-01-31
Is it possible to change a crystal reports query at design or runtime?
for example, I have a single report which can be used for a multitude of reports, with just the change of on parameter. Like, employee birthdays, if I want to get all employees who have a DOB in january, the query is the same for every other month aside from the date...
I am using MS Access as the datasource in a c#2010 winforms application
I tried using [month] in the query as a parameter, but that accepts a numeric value.. which is ok, but I would prefer for the user to have a dropdown list of months with January, February and so on... and for the query to feed from that... can this be done?