Okay, so you know that Crystal Reports is not a good place to make it do much more than present your data. However, you mention pivot, and then just show us some data, and expect us to read your mind as to what you actually mean? If the data is that simple, what kind of "pivot" are you talking about, and more importantly, why? Chances are, no one has responded until now because there doesn't really appear to be any specific question in what you've posted. Also, if you're going to post data, please take the time to post it in a consumable form, which means creating CREATE TABLE and INSERT statements that any given person viewing the post can just copy and paste into SQL Server Management Studio and then be able to work on the problem you post. You should also include any code that you've tried so far, and describe what, if any, problems you are experiencing.