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

Crosstab query with selected range of copyright year as column heading

This is another question that is related to my previous post at my post here but with different problem. In my previous post, I ask on how I can create a crosstab query that will output a column based on 4 year range of copyright year. The answer…
jaypabs
  • 1,519
  • 10
  • 43
  • 62
0
votes
2 answers

How to perform Fisher test in every subgroup

I have a dataframe with following data: age.cat ds.cat finalstate <65 AGN dead <65 AGN alive <65 PC alive 65+ AMI alive 65+ PC dead <65 AMI alive For every level of ds.cat factor variable I need to…
boris
  • 13
  • 5
0
votes
1 answer

Can i do this Report withe BIRT

I am new in BIRT and i try to do a report from a DB , This is a overview of my DB, in the end I want to have something Like this for one person it's possible or not?
user2131519
  • 1
0
votes
1 answer

supress zero rows in crosstab crystal reports

I have crosstab looks like this Jan Feb Emp1 500 600 Emp2 600 700 Emp3 0 0 I want to hide the row3 as it has zero values. I have seen in crosstab expret to supress empty rows but…
Tassadaque
  • 8,129
  • 13
  • 57
  • 89
0
votes
0 answers

How to trap click/dbl-click in a Subform whose SourceObject is a Query

Access 2007 Hello I'm asking the same question asked here Form has a query sourceobject but i want to catch the click/double click event This is a followup from my previous question, when i change from one field to another in the same record the…
Jose R
  • 738
  • 2
  • 10
  • 26
0
votes
1 answer

postgres crosstab / transpose

I would like to ask for help.. I have this table user_id | Metric_1 | Metric_2 | Metric_3 ------------------------------------------ 1 | Jan | 10 | yes 2 | Feb | 10 | No 3 | Mar | 20 | No 4 …
toink
  • 255
  • 4
  • 11
  • 30
0
votes
2 answers

MS Access Double click event on query

MS Access 2007, Win 7 32-bits Is there a way where I can access an open query in datasheet view in access to get the current field value and current field name? I won't put it into a form since it is a crosstab query and i'd have to generate and get…
Jose R
  • 738
  • 2
  • 10
  • 26
0
votes
1 answer

Access 2007 - 'rotating' data without using a crosstab query

I have a query that returns data like this: Store Product CasesPerStore Bob's Original 2 Bob's Super 1 Tom's Original 5 Pete's Original 9 Pete's Super 2 And I want to join it to another query…
Wilskt
  • 337
  • 2
  • 9
  • 24
0
votes
1 answer

Cross tab query with boolean fields as row headers

I currently have a table structure that looks something like this(some details omitted): ColumnName || Type Date_Of_Job DateTime Reparied_Service Boolean Disconnect_Service Boolean Relayed_Service Boolean…
Nathan W
  • 54,475
  • 27
  • 99
  • 146
0
votes
2 answers

Converting numbers to MM:SS format in Cross-tab

I'm trying to convert a value in Cross-tab of Crystal report into a MM:SS format. I used the following steps: Right-click summary > Format Field > Display String > x+2 WhilePrintingRecords; NumberVar curr := CurrentFieldValue; NumberVar mins :=…
bcmacariola
  • 106
  • 2
  • 15
0
votes
1 answer

mysql group_concat output as the another query column list

I want to generate a cross tab query in MySQL. I used group_concat, but it is not working. I issued the following query to generate the year list: set @v1 = (SELECT GROUP_CONCAT(DISTINCT CONCAT('\\nsum(CASE WHEN myear=\"', myear ,'\" THEN amount…
user1480032
  • 45
  • 1
  • 2
  • 11
0
votes
1 answer

Transform a XML file using attribute values from one node and merging with another node

I have written below XSLT to achieve translation required for my reporting requirement. Though, Input and Output XML are self-explanatory, but in short, requirement is to build a new XML from an existing XML by merging different pair of nodes,…
Fun2Learn
  • 33
  • 1
  • 2
  • 6
0
votes
1 answer

Formula in crystal reports cross tab or chart

I'm building a report which should include a chart with the percentage of orders that contains a specific item per customer. In plain report form I can easily accomplish this by grouping by customer and then using two running fields—one for distinct…
LapplandsCohan
  • 706
  • 4
  • 13
  • 29
0
votes
1 answer

using cross tab and pivot table function

Possibility of using cross tab and pivot table function in postgres 8.3 version I know it is possible with postgres 9.x version, but wanted to know by any chance we can use it with the older versions of postgres. I am using hibernate for the…
Gokul Potluri
  • 262
  • 4
  • 16
0
votes
1 answer

Converting Access PIVOT query to Oracle 11g

I have an MS Access PIVOT query which needs to be migrated to Oracle 11g. TRANSFORM Format(Sum(tblOrderLine.ItemQtyCur), '#0.0') AS [The Value] SELECT tblOrderLine.OrderStatus, tblOrderLine.OrdNo, tblOrderLine.OrdlNo,…
niklodeon
  • 1,320
  • 5
  • 20
  • 51
1 2 3
…
99 100