<div>
hey peter, thanks for the input<br />
<br />
<br />
You just saved me a load of hassles!<br />
<br />
Cheers
</div>


hey peter, thanks for the input


You just saved me a load of hassles!

Cheers

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
Is it possible to change a crystal reports query at design or runtime?<br />
<br />
for example, I have a single report which can be used for a multitude of reports, with just the change of on parameter. &nbsp;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...<br />
<br />
I am using MS Access as the datasource in a c#2010 winforms application<br />
<br />
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?<br />
<br />
Cheers<br />
<br />
CD
</div>
</div>


Hi

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?

Cheers

CD

Change a query on a crystal report at design or runtime

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.