crosstab

Transpose a set of rows as columns in SQL Server 2000

Is there any facility of transposing rows to columns in SQL Server (it is possible in MS-Access)? I was befuddled because this facility is available in MS-Access but not in SQL Server. Is it by design that this feature has not been included in SQL Server? ...

Crystal Report in VB.net

Im creating a report using crystal report in vb.net. The report contained a crosstab which I have 3 data: 1. Dealer - row field 2. Month - column 3. Quantity Sales - summarize field How can I arrange this by ascending order based on the Quantity Sales - summarize field? thanks ...

Using Linq to create crosstab results

Hi, Im wondering if its at all possible to create crosstab style results with Linq. I have some data that looks like the following: var list = new[] { new {GroupId = 1, Country = "UK", Value = 10}, new {GroupId = 1, Country = "FR", Value = 12}, new {GroupId = 1, Country = "US", Value = 18}, new {G...

Cross Tab Query Required SQL 2000

I have already googled for this I have a Table with following structure in SQL 2000 ID ContactName Designation 1 A CEO 2 B ABC 3 C DEF 4 D GHI I need the Output as follows ContactName1 Contactname2 ContactName3 ContactName4 A CEO B ABC C DEF D GHI Any ...

Crosstab in Cognos

I have a set of data that needs to be displayed as a crosstab in Cognos. Example data includes ID, Month, Year, State 1, 10, 2008, 25 2, 10, 2008, 26 The problem is that in the crosstab, the month column is duplicated for each row instead of using the same column for the month. Example: ID 2008 2008 10 1...

How to create a columnar report in Visual Studio 2008 - Crystal Reports

Hi, I'm trying to summarize data in a crystal report. I'd like to create a columnar view of data in crystal but am not sure how to do it. I was wanting to use a crosstab but when I try to insert, the control never appears. I create a crosstab report but when done, it comes to a blank report. I want it to be like this except columns would...

Jasper Reports Crosstab Query

Hi, I'm using Jasper Reports/iReports crosstabs to create a matrix of student and results. So for example Jim is doing subjects A, B, C and Sally is doing A, C What I want is something like: Subj-A Subj-B Subj-C Jim P M D Sally D D But as my SQL orders by name then subj...

Excel Pivot

Hello, I am an excel newb, wondering if excel has built in functionality to do the following. Turn this data: Name | Activity | Option Bob | Monday Activities | Golf Bob | Tuesday Activities| Kayak Marge | Monday Activities | Spa John | Tuesday Activities| Soccer Liz | Tuesday Activities| Spa Into: Name | Monday A...

'Rotate' data in a WinForms datagrid

Using Winforms .NET 2.0, my client has requested that data in a Datagrid be displayed vertically rather than horizontally. The data layer of the app is built upon NHibernate, so I generally avoid writing raw SQL in favor of HQL. However, this scenario may lend itself to utilizing the 'crosstab' functionality of SQL Server 2005. So f...

Report Matrix filler

I have a matix in my report (VS2005) i would like the matrix to display a default of 12 rows even if no data is available. i have not figured out how to do this so i create a group of rectangles below the grid and each row of these rectangles has is visibility changed based on the row count in the matrix. the problem with this is that t...

Looking for MISSING records

I'm a bit rusty when it comes to MS Access and I am hoping someone can help me out..... I have a list of all items that have been scanned (for purchase) by each store, by UPC for a one month period. I also have a particular group of UPC's that I want data for. What I want to get is the items that DIDN'T get scanned. Obviously, the it...

Cross tab data control for winform.net 2.0

Could anyone suggest me any winforms controls for showing cross tab data in .net? Updates: 1. The control should be editable 2. Binding support will be add-on feature. ...

Sorting a Crystal Reports 2008 Cross-tab in two directions

I have a table that shows a list of doctors, facilities, and charges. I set up a Cross-tab Report in Crystal Reports 2008, putting the doctors on the rows, the facilities on the columns, and the sum of the charges (and a couple of related numbers) as the summary fields. When I did this same report in Excel, I had no trouble sorting by s...

How do you do a crosstab query in Access with a fixed amount of columns

I want to pull data with an MS Access crosstab query so I can bind it to a report. When I load the page I get a Run-time error'3637': Cannot use the crosstab of a non-fixed column as a subquery. I would like a way to get back a fixed grid when I run the query and if the cell is null display a zero. ...

How to write Display String formula for each cell in CrossTab?

Formula scenario: Retrieved data has a status column which its values is (-1, 0, 1, 2, 3), I'd like to use formula to display string based on these values. I use Display String, but it doesn't work. How could I write a formula to work for each cell in crosstab? Any suggestions? ...

Converting Rows to column

Hi, let's assume I have a table with columns such as Cost Rate Repair 12 Repair 223 Wear 1000 Wear 666 Fuel 500 Repair 600 Fuel 450 Wear 400 and I want this data as columns(Repair,Wear,Fuel) as Repa...

Access: "crosstab" query effect for non-numeric data

Hi, I am using Access 2007 and need help creating a query. If this is crazy long, sorry! I figure the more details the better understanding. I am not a programmer--I hope someone will help. I need to know how to collapse/summarize/roll up non-numeric data into a single row that shares a characteristic/value. What I want is like a crosst...

SQL Unique Values Numbering Sequence for Pivot

For reporting purcposes, I need to Pivot results of a query that is unique on each record. My current statement is: SELECT * FROM Sales AS x WHERE (select count(*) from Sales where customer_name=x.customer_name and order_date>=x.order_date)<=5 ORDER BY customer_name, order_date, price; A sample of the Query output is: custo...

MS Access Crosstab Query Question

Is there a way to reference a form's combo/text box within the query like a select query? I usually use something like this in a select query's criteria: like forms!frmMain.qTitleofSomething&* (access adds the brackets for me) but this does not work in a crosstab query?? which i just found out. is there a way to accomplish the same ...

SQL Rows to Columns

Hi, I have a table and want to transpose its rows to columns, similar to a pivot table but without summarising. For example I have the following tables: Question --QuestionID --QuestionText Response --ResponseID --ResponseText --QuestionID Basically I want to be able to create a dynamic table something like: Question 1 Text | Ques...