<p><span style="font-family:tahoma, geneva, sans-serif;">Hi,</span></p>
<p> </p>
<p><span style="font-family:tahoma, geneva, sans-serif;">I want to create a dataset query OR any other query item, <span style="color:#800000;"><strong>qryPeriod </strong></span>like the following:</span></p>
<p> </p>
<p><span style="font-family:tahoma, geneva, sans-serif;">If <strong>param</strong>='<span style="color:#0000ff;"><em>Year</em></span>' Then (database.schema.table.YEAR)</span></p>
<p><span style="font-family:tahoma, geneva, sans-serif;">Else if <strong>param</strong>='<span style="color:#0000ff;"><em>Quarter</em></span>' Then (database.schema.table.QUARTER)</span></p>
<p><span style="font-family:tahoma, geneva, sans-serif;">Else if <strong>param</strong>='<span style="color:#0000ff;"><em>Month</em></span>' Then (database.schema.table.MONTH)</span></p>
<p><span style="font-family:tahoma, geneva, sans-serif;">End</span></p>
<p> </p>
<p><span style="font-family:tahoma, geneva, sans-serif;">Note: </span></p>
<p><span style="font-family:tahoma, geneva, sans-serif;">1) My database is SQLSERVER and the fields YEAR, QUARTER and MONTH have different values.</span></p>
<p><span style="font-family:tahoma, geneva, sans-serif;">2) Where <strong>param </strong>is a report parameter having its static values as <span style="color:#0000ff;"><em>Year</em></span>, <span style="color:#0000ff;"><em>Quarter </em></span>and <span style="color:#0000ff;"><em>Month</em></span>.</span></p>
<p> </p>
<p><span style="font-family:tahoma, geneva, sans-serif;">I want to now place <span style="color:#800000;"><strong>qryPeriod </strong></span>in crosstab row/columns field. When I run the report, when I enter <strong>param </strong>= <span style="color:#0000ff;"><em>Year</em></span>, the crosstab measures should get sliced on Year. If I select <strong>param </strong>= <span style="color:#0000ff;"><em>Quarter</em></span>, then my crosstab measures should get sliced on Quarter.</span></p>
<p> </p>
<p><span style="font-family:tahoma, geneva, sans-serif;">Any suggestions for this?</span></p>
<p> </p>
<p><span style="font-family:tahoma, geneva, sans-serif;">Best Regards</span></p>
