<div>
You might also consider upgrading to a newer version of SQL Server with the Pivot function in T-SQL. You need not even pay - get a copy of SQL Server Express and use it as a report server ...<br />
<br />
Mike
</div>


You might also consider upgrading to a newer version of SQL Server with the Pivot function in T-SQL. You need not even pay - get a copy of SQL Server Express and use it as a report server ...

Mike

<div>
Thank you we are in the process of upgrading, now...but its a entire ERP system update, so we are looking at 6 months. &nbsp;At least the managers are shooting for that.
</div>


Thank you we are in the process of upgrading, now...but its a entire ERP system update, so we are looking at 6 months.  At least the managers are shooting for that.

<div>
<div class="content wysiwyg-content">
We are trying to create a report that will pivot the output of a query. &nbsp; The query have multipule fields, but they want it broken out by month/year. &nbsp; We also use crystal reports 9. &nbsp;The inv_datem is the month number while the datey is the year. &nbsp;The goes back one year...Thanks<br />
<br />
select &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;inv_Datem,<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;inv_Datey,<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;item,<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;rollup,<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;matlcode,<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cert_desc,<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; size,<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; type,<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;whse,<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; inv_amt,<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;qty_openOrders,<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;cur_sales,<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;avg_pricelb &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
from &nbsp; rollupsales
</div>
</div>


We are trying to create a report that will pivot the output of a query.   The query have multipule fields, but they want it broken out by month/year.   We also use crystal reports 9.  The inv_datem is the month number while the datey is the year.  The goes back one year...Thanks

select 	inv_Datem,
		inv_Datey,
		item,
		rollup,
               matlcode,
                cert_desc,
                size,
                type,
		whse,
                inv_amt,
		qty_openOrders,
		cur_sales,
               avg_pricelb		
from   rollupsales

Pivot data from sql 2000

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.