Stack Overflow
Stack Overflow

Questions tagged [crosstab]

A cross tab, also known as a "pivot table", is a method of summarizing data in tabular form. Typically, these have a category column in the left hand side, and multiple summary columns to the right. Each different category will have its own row. Be sure to also include the relevant language tag (python, R, sql-server etc.) on your question.

Resources:

1549 questions
0
votes
1 answer

How to build a SQL Server 2005 query that combines three tables' data into a single grid output?

I have an Items table with about 30000 records in it, a Groupings table into which my clients are grouped, a Categories table into which my Products are sorted, and a Product_Categories table that stores which Items go into which Categories for…
Frank Bailey
  • 185
  • 2
  • 17
0
votes
1 answer

Postgresql change column to row in a generic way

A key value pair(column name, value) needs to be retrieved from a table with about hundred columns. The following query does exactly what is needed. With dummy AS ( Select 1 as Col1, 2 as Col2 ) SELECT unnest(array['Col1', 'Col2']) AS "Column…
Gopal
  • 1,372
  • 2
  • 16
  • 32
0
votes
1 answer

SQL Server Dynamic Pivot

Hello I have a table that contains employee punch in and punch out data from a timekeeping system. I am looking to dynamically pivot the punch data column and total an employees shift span. However I am having issues with the dynamic pivot. I have…
user2551567
  • 3
  • 1
0
votes
1 answer

Populate an excel crosstab

I'm attempting to populate an excel spreadsheet using Softartisans ExcelWriter (part of Office Writer), it fair easy if you need to "load" only one record, or a tabular table. I need to fill a "Crosstab Table", something like this: …
user2300835
  • 1
  • 1
0
votes
1 answer

Crystal Reports: Add Values from different data records

I have 2 columns, one column that returns a code (a1, a2, a3, etc) and another column that returns a dollar value for each code. Name Code Dollar John a1 1 John a2 2 John a3 2 John b1 4 I want the codes to be their own columns and add similar…
user2410621
  • 1
  • 1
0
votes
1 answer

Find window previously opened by window.open in new tab in chrome

I have the following code (from related) that works for finding a reference to previously opened windows and closing them. var playerUrl = 'http://my.player...'; var popupPlayer= window.open('', 'popupPlayer', 'width=150,height=100')…
Menelaos
  • 23,508
  • 18
  • 90
  • 155
0
votes
0 answers

How to get the Sum in Cross tab in Crystal reports

I am using Cross tab in Crystal Reports for getting dynamic generation of rows and column. And i need the total summary in the summary field. I am not able to find the sum function there. I am using VS 2008 and Crystal report …
Jidheesh Rajan
  • 4,744
  • 4
  • 23
  • 29
0
votes
2 answers

Using a multi-dimensional form to insert data in access

I'm having a rough time creating an ms-access form for my client. Here's the thing: every 3-4 years, my client receives a .pdf from the government and needs to insert that data into their…
user1747281
  • 149
  • 1
  • 13
0
votes
1 answer

Cross tab report in Crystal Report

I am quite new to cross tab type reports in crystal report and I want to show multiple users multiple details. So that I have columns as username and row containing details of the same. Like: User1 User2 User3 User4 …
Incredible
  • 3,495
  • 8
  • 49
  • 77
0
votes
1 answer

Jasper Report Date Format

In Jasper Reoprt, crosstab, I have displayed my date as like "2012-09-13". Is there a way to display it in reverse as "13-09-2012" using any String methods? And another thing is that I retrieve the date from SQL dB. Thanks in advance!
Yuvaraj
  • 31
  • 1
  • 6
0
votes
2 answers

Oracle SQL creating crosstab using merge

I need help creating crosstab. I was told that it can be done using Merge statement, but I feel quite confused about it. Maybe someone had expirience in using merge statement to create crosstab. Here is the initial table: (there can be many persons…
user2253044
  • 1
  • 1
0
votes
1 answer

SQL Query to retrieve table value as column

I have a table view as below: (SELECT * FROM session_log_detail) ![Raw Data from table session_log_detail][1] attr_name attr_value timestamp A 123 1:20:45 B 234 1:20:45 C 567…
user1564173
  • 31
  • 3
  • 7
0
votes
2 answers

SQL query to transform combination of values into a column

I have a table like this: user_id, gender, sent 1 M 100 1 F 120 2 M 20 2 F 30 I want a table like this from the above: user_id, male_sent, female_sent, total_sent 1 100 120 …
jason
  • 3,471
  • 6
  • 30
  • 43
0
votes
1 answer

Crystal Report cross-tab row column cannot grow

I have been using cross tab Crystal report to generate the subtotals to Analyse which company use less cost for purchasing materials. Due to the software constraints provided by Crystal Report, crosstab can only be created in the report header. In…
Jeff Bootsholz
  • 2,971
  • 15
  • 70
  • 141
0
votes
1 answer

Jasper Report: List as Cross Tab column

Is there a way I could use a parameter of List as my crosstab column?
user2147589
  • 1
  • 1
1 2 3
…
99 100