crosstab

Crystal Report with mutliple row columns.

I'm not sure if the title properly explains what I'm trying to do. I'm trying to move from using SQL Reporting Services to a Crystal Reports Web App. I've gotten some reports to design properly because they are simple cross-tab reports that require nothing special. I'm running into a little problem of a user matrix report. Here's how the...

PostgreSQL Crosstab Query

Hi all, Does any one know how to create crosstab queries in PostgreSQL? For example I have the following table: Section Status Count A Active 1 A Inactive 2 B Active 4 B Inactive 5 I would like the query to return the following crosstab: Section Active Inactive A 1 ...

asp.net free webcontrol to display crosstab or pivot reports with column and row grouping, subtotals and totals or different approach

Hello, I want to develop some crosstab also know as pivot reports in Asp.net with x-axis and y-axis being dynamics, allowing grouping by row and column, for example: have products in y-axis and date in x-axis having in body number of sells of a given product in a given date, if date in x-axis are years, i want subtotals for each month ...

sql crosstab problem

Here's the very detail prob: this date belongs only to 1 table custcode address cust1 capitol, cebu city cust1 gen. maxilom, cebu city cust1 guadalupe, cebu city cust2 paknaan, mandaue city cust2 basak, mandaue city cust3 lapu-lapu city In my report I want to have this fields in my reportviewer customer nam...

How to implement and bind crosstab data using Entity Framework/Winforms?

Hi, I want to keep some timesries data in my database. Raw data are something like below: Time Col1 Col2 Col3 8:00 12 18 20 8:30 14 12 13 9:00 17 15 14 Where number of columns and time steps are undetermined. So I created three tables like this: TimeStamp(ID,Time) Columns(ID,Name) Values(ID,TimeStampID,Colum...

Advanced CrossTab Query

Hi all, I have this rows in my data base "ExamTable" How can I make the above rows like this ..? Could any expert tell me what I should to do in this case ? DataBase: SqlServer2005 Pages: C# ...

SQL - Is there a command to do this? Thanks!

I have a table that currently is a long list of devices and information about when they were sold. I need to take the table which would look something like this: Item | Time Sold -------------------- A 05/2010 B 04/2010 C 03/2010 A 04/2010 A 05/2010 And then have a table with the item a...

How to create contigency tables (crosstabs) in R for a subset of columns with categorical data?

I have a table whose header looks like this (I've simplified it): id, a1, a2, a3, a4, a5, a6, a7, a8, a9, a10 where each row, except for id, is a categorical variable. Let's name the categories A, B, C, D, E. I would like to create a contingency table for some of the columns, such as below (for brevity, I have not put sample numbers ...

Adding serial no in crystal report cross tab report.

How to add serial number in a crystal report cross tab report? I am using dataset as a datasource. ...

Convert rows to columns allowing duplicates

Consider the following table and rows: Listing A. ID, name, event, type 1, 'John Doe', '2010-09-01 15:00:00.000', 'input' 1, 'John Doe', '2010-09-03 11:00:00.000', 'input' 1, 'John Doe', '2010-09-04 17:00:00.000', 'input' 1, 'John Doe', '2010-09-02 15:00:00.000', 'output' 1, 'John Doe', '2010-09-03 16:00:00.000', 'output' 1, 'John Doe'...

Using single query to retrieve multivalued attribute by joining two tables without causing duplication of fields in mysql

Table 1 : QUERY: Create table client ( applicationNo int primary key, name varchar(20) ); Insert statement: Insert into client values (1,'XYZ'),(1,'ABC'),(1,'DEF'); applicationNo | name 1 | XYZ 2 | ABC 3 | DEF Table 2: Query : Create table client ( applicationNo int, ...

Complicated Crosstab Query Question

I have the following 2 tables: 1) Companies ID CompanyName Abbreviation Notes 1 CompanyA CA ... 2 CompanyB CB ... 3 CompanyC CC ... 2) PlannedDeployments ID CompanyID TypeID DepDate NumDeployed 1 1 ...

Converting an Access crosstab query to SQL Server 2005

Hi, I am attempting to convert an access cross tab query to SQL, and am hoping someone here can help me in the process. The access query is: TRANSFORM First(tbl_Proj_Budget.BUGDET_LINE_BURDENED_COST) AS FirstOfBUGDET_LINE_BURDENED_COST SELECT tbl_Proj_Budget.PROJ_ID, First(tbl_Proj_Budget.BUSDET_LINE_BURDENED_COST) AS [Total Of BUGDE...