INFORMIX - Pivot Table

Question

I have a problem with informix database,

I have a log table, like this

name     datetime     event
 A        08:00         1
 B        03:00         2
 A        04:00         3
 C        05:00         4
 V        06:00         1
 A        11:00         7
 etc

NOTE : 1 => LOGIN
       7 => LOGOUT

I want generate a report, like this

name    login     logout
 A      08:00     11:00
 A      11:09     12:00
 etc

I need a query to solved My problem.

score 0 · Answer 1 · answered Mar 12 '14 at 04:23

0

First Group by name

create text feilds Login and Logout and place those in group header.

Now in detail add below formulas for login and logout.

login

if event=1
then datetime

Place in detail fo login

logout

if event=7
then datetime

Place in detail of logout

supress group footer

answered Mar 12 '14 at 04:23

Siva

9,043
12
40
63

I want generate a query for that output, what kind of query can solved that – harits nurrois Mar 12 '14 at 07:16
Just follow the steps in crystal report and then go to **Database tab---> Show SQL query** you get the query – Siva Mar 12 '14 at 08:22

score 0 · Answer 2 · edited May 23 '17 at 10:33

0

have a look below link.

Dynamic PIVOT using C# Linq

use parameter as you want to pivot the data.

edited May 23 '17 at 10:33

Community

1
1

answered Mar 12 '14 at 10:02

J R B

2,069
4
17
32

INFORMIX - Pivot Table

2 Answers2