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
0 answers

Can you use Pivot View to enter data in Microsoft Access

I have an application that is currently using Microsoft SQL Server Lite, however I'm building a Microsoft Access database to replace the SQL Server Lite so that I can use Pivot Table Queries. For the time being, I'm working in Microsoft Access until…
PAUL DUFRESNE
  • 348
  • 3
  • 4
  • 11
0
votes
1 answer

Cross tab .jasper file error when running

I am getting the following error when i tried to call .jasper file in servlet. The .jasper is having crosstab, which run perfectly in design IDE in ireport 4.5 net.sf.jasperreports.engine.JRException: Error loading object from InputStream at…
visitaruna
  • 1
  • 1
0
votes
1 answer

IReport: Crosstab: adding row group

I have this Jasper Report that have a Crosstab placed on the Summary band. Though the Crosstab's dataset is based from the Query of the file, I need to add a third row group to it. The question is how? I may have sucessfully added the third row by…
David B
  • 3,269
  • 12
  • 48
  • 80
0
votes
1 answer

Using DynamicJasper API: Getting empty report with crosstab

I try to create dynamic crosstab. When I try, I have an error java.lang.ClassCastException Jasper Report Crosstab than I solved it. But my report is empty. I don't get it why. I check my result set is empty or not. But it does not empty. Here is my…
Ayşegül Y
  • 53
  • 9
0
votes
1 answer

Oracle SQL summary/pivot table

I have a data set that looks like this: ID Description Team A Missing Name; Missing Gender Team1 B Missing Gender Team1 C Missing Name Team2 D …
bawpie
  • 467
  • 4
  • 12
  • 27
0
votes
1 answer

MySQL Crosstab in a view

I have the following data. RecordID |RecValue1 |RecValue2 |RecValue3 |Fields 1072 |130227 |0 | |Document_Number 1072 |1241388 |0 | …
user1236443
  • 549
  • 2
  • 8
  • 19
0
votes
1 answer

iReports: Creating charts using crosstab "total variables"?

Is it possible to use variables ,that are defined in crosstab like total measure variables etc in the formation of charts in iReports... Like I need chart of percentage of certain measure which in crosstab I calculated using total variable. How to…
Dhruv
  • 10,291
  • 18
  • 77
  • 126
0
votes
1 answer

How to group in cross-tab report

I created a cross tab that shows the number of hours that employees worked each week. but I want to group them by their team leaders.
wben
  • 247
  • 2
  • 7
  • 20
0
votes
1 answer

SQL 2000 TSQL - Creating Pivot Table

I am really struggling with figuring out how to convert a MS Access CrossTab query into T-SQL to run on SQL2000 or into Linq-to-SQL. What I have is a query that looks like this in Access: And produces this: The query basically groups by ItemID…
GJGerson
  • 211
  • 1
  • 9
  • 20
0
votes
1 answer

How to tabulate rating or categorical data in R?

I have data from a survey. I have data from several Likert-type questions. For example: "To what extent did the following factors contribute to your decision to enroll in a PhD program?" with 4 categories: 1: Not at all; 2: To a small extent; 3: To…
Bartolome Salom
  • 103
  • 2
  • 5
0
votes
1 answer

Total field in Crosstab query in SQL Server 2008

I have got this result with the answer given by bluefeet Equipt BSL AQ TFP 3 2 TM 1 0 VCB 18 6 VCD 5 8 Query script was SELECT Equipt, [BSL] AS BSL, [AQ] AS AQ FROM ( SELECT Equipt, Shed FROM…
user1235981
  • 21
  • 2
  • 7
0
votes
1 answer

Cross Tab query in SQL Server 2008

I have a SQL table with following fields ID, Rly, Shed, Loco_no, shed, Date_failure, Equipt I am using a cross tab query in access using the following script in MS Access 2007 TRANSFORM Count(Sheet1.[sno]) AS CountOfsno SELECT Sheet1.[Equipt],…
user1235981
  • 21
  • 2
  • 7
0
votes
1 answer

postgres crosstab query with $libdir/tablefunc crosstab_hash function

My crosstab query (see below) runs just fine. However, I have to generate a large number of such queries, and - crucially - the number of column definitions will vary from day to day. If the number of output columndefs does not match that of the…
aag
  • 680
  • 2
  • 12
  • 33
0
votes
1 answer

Group by Week with Columns for each day of week

I'm trying to created a report for my asp.net application which will show the quantity of each item in combination with unit that was ordered for each day of the week. The days of the week are columns. To be more specific: I have two table, one is…
boruchsiper
  • 2,016
  • 9
  • 29
  • 53
0
votes
1 answer

postgres tablefunc module using hql hibernate queries?

Would you know how to use the postgres crosstab (tablefunc) function in a HQL query? Do you need to register the function with Hibernate? This is the error I'm getting: unexpected token: CROSSTAB near line 1, column 34 [SELECT * from…
giorgioca
  • 713
  • 1
  • 8
  • 21
1 2 3
…
99
100