<div>
Not quite sure I understand.<br />
<br />
You're grouping the data by week number but want to label it with day name?<br />
<br />

</div>


<div>
chrismc,<br />
yes, I'm grouping the data by week successfully, I just can't get the label to display correctly. &nbsp;I will like the label to display the first day of that week no.<br />
thanks.
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
I am generating a report that displays trend data on a week by week basis. &nbsp;I grouped my data set on the completion date by weeks: &nbsp;Format(&quot;ww&quot;,Fields!Quantit<wbr />y.Value). &nbsp;Now that I have the week number for the groups, I would like to display the chart using the Monday(or Friday) as the X axis label. &nbsp;Is there a way to do this? &nbsp;I'm using SQL Reporting Services 2005.<br />
Thanks in advance! 
</div>
</div>


Hi,
I am generating a report that displays trend data on a week by week basis.  I grouped my data set on the completion date by weeks:  Format("ww",Fields!Quantity.Value).  Now that I have the week number for the groups, I would like to display the chart using the Monday(or Friday) as the X axis label.  Is there a way to do this?  I'm using SQL Reporting Services 2005.
Thanks in advance! 

Not quite sure I understand.

You&#39;re grouping the data by week number but want to label it with day name?



chrismc,
yes, I&#39;m grouping the data by week successfully, I just can&#39;t get the label to display correctly.  I will like the label to display the first day of that week no.
thanks.

Converting Week Number to Date

Hi,
I am generating a report that displays trend data on a week by week basis.  I grouped my data set on the completion date by weeks:  Format(&quot;ww&quot;,Fields!Quantity.Value).  Now that I have the week number for the groups, I would like to display the chart using the Monday(or Friday) as the X axis label.  Is there a way to do this?  I&#39;m using SQL Reporting Services 2005.
Thanks in advance! 

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.