Re: help with a query

From: Jorge Castro <joacat_at_crosswinds.net>
Date: Wed, 23 Aug 2000 09:32:49 -0400
Message-ID: <8o0jnp$9h8bd$1@ID-47021.news.cis.dfn.de>

Currently, with this query:

SELECT

  (DECODE(TYPE,1,ID,'')) TYPE1,
  SUM(DECODE(TYPE,1,VALUE,'')) VALUE1,
  (DECODE(TYPE,2,ID,'')) TYPE2,
  SUM(DECODE(TYPE,2,VALUE,'')) VALUE2,
  (DECODE(TYPE,0,ID,'')) TYPE0,
  SUM(DECODE(TYPE,0,VALUE,'')) VALUE0

FROM TABLE1
GROUP BY TYPE,ID; I get this result:

TYPE1|VALUE1|TYPE2| VALUE2|TYPE0|VALUE0
-----|------|-----|-------|-----|------


     |      |     |       |   19|     0

     |      |     |       |   20|     0

     |      |     |       |   21|     0

     |      |     |       |   22|     0

     |      |     |       |   23|   100

     |      |     |       |   24|     0

    0|  5000|     |       |     |
    1|    10|     |       |     |
    2|  2000|     |       |     |
    3|    15|     |       |     |
    7|   200|     |       |     |
    8|   800|     |       |     |
    9|    25|     |       |     |
   10|     0|     |       |     |
   11|   500|     |       |     |
   12|     0|     |       |     |
   13|     0|     |       |     |


     |      |    4| 676,85|     |

     |      |    5|1068,75|     |

     |      |    6|   85,5|     |

     |      |   14|      0|     |

     |      |   15|    456|     |

     |      |   16|     20|     |

     |      |   17|     45|     |

     |      |   18|     45|     |


but in the report that i'm building I need the data in the other way. (I
HAVE to use CrystalReports4.6)

Received on Wed Aug 23 2000 - 08:32:49 CDT