Selecting different views from a Boolean expression

Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 34CD19FB35A for ; Mon, 26 Mar 2007 11:04:11 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 45465-03 for ; Mon, 26 Mar 2007 11:03:45 -0300 (ADT) X-Greylist: delayed 00:27:16.782869 by SQLgrey-1.7.4 Received: from mail103.cra-arc.gc.ca (mail103.cra-arc.gc.ca [198.103.184.26]) by postgresql.org (Postfix) with ESMTP id 521AF9FA616 for ; Mon, 26 Mar 2007 11:03:51 -0300 (ADT) Received: from SD01ITMB02.PROD.NET (unknown [7.32.10.168]) by mail103.cra-arc.gc.ca (mail) with ESMTP id 47BA793EKK for ; Mon, 26 Mar 2007 09:36:32 -0400 (EDT) Received: from SD01ITMV12.PROD.NET ([7.32.10.12]) by SD01ITMB02.PROD.NET with Microsoft SMTPSVC(6.0.3790.2499); Mon, 26 Mar 2007 09:36:10 -0400 x-mimeole: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C76FAB.B709C565" Subject: Selecting different views from a Boolean expression Date: Mon, 26 Mar 2007 09:36:10 -0400 Message-ID: <7CCC5BEF5E72394C963E529B54EB4A642A198C@SD01ITMV12.PROD.NET> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Selecting different views from a Boolean expression Thread-Index: Acdvq7cBXiULlRFyQUCvfcPBV35TsQ== From: "Wilkinson, Jim" To: X-OriginalArrivalTime: 26 Mar 2007 13:36:10.0582 (UTC) FILETIME=[B720CF60:01C76FAB] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/306 X-Sequence-Number: 27944 This is a multi-part message in MIME format. ------_=_NextPart_001_01C76FAB.B709C565 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi there,=20 I have a web based reporting system that I am coding. I need to be able to view statistics by the calendar year or the fiscal year depending on what the user selects. My issue is how do I change y select statements to change the column output? Example Incident Jan Feb Mar Apr May June July Aug Sep Oct Nov Dec =3D=3D=3D=3D=3D=3D=3D =3D=3D=3D =3D=3D=3D =3D=3D=3D =3D=3D=3D=3D = =3D=3D=3D =3D=3D=3D=3D =3D=3D=3D =3D=3D=3D=3D =3D=3D=3D=3D =3D=3D=3D=3D =3D=3D=3D=3D =3D=3D=3D=3D Falls 1 1 0 0 0 0 0 0 0 0 0 0 Overdose 0 1 0 1 1 1 0 0 0 1 1 0 But if the user selects fiscal year the output could be: Incident Jun Jul Aug sept Oct Nov Dec Jan Feb Mar Apr May =3D=3D=3D=3D=3D=3D=3D =3D=3D=3D =3D=3D=3D =3D=3D=3D =3D=3D=3D=3D = =3D=3D=3D =3D=3D=3D=3D =3D=3D=3D =3D=3D=3D=3D =3D=3D=3D=3D =3D=3D=3D=3D =3D=3D=3D=3D =3D=3D=3D=3D Falls 1 1 0 0 0 0 0 0 0 0 0 0 Overdose 0 1 0 1 1 1 0 0 0 1 1 0 I have created select views for each month possibility, but I don't know how to select the view I need from an IF/Then/else statement!! Any help would be appreciated. Thanks =09 ------_=_NextPart_001_01C76FAB.B709C565 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Selecting different views from a Boolean expression

Hi = there, =

I = have a web based reporting system that I am coding. I need to be = able to view statistics by the calendar year or the fiscal = year = depending on what the user selects.

My = issue is how do I change y select statements to change the = column = output?

Example

Incident = Jan = Feb Mar = Apr May = June July = Aug Sep Oct = Nov Dec

=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D = =3D=3D=3D =3D=3D=3D = =3D=3D=3D=3D =3D=3D=3D = =3D=3D=3D=3D =3D=3D=3D = =3D=3D=3D=3D =3D=3D=3D=3D = =3D=3D=3D=3D =3D=3D=3D=3D = =3D=3D=3D=3D

Falls = = 1 = 1 = 0 = 0 = 0 = 0 = 0 = 0 = 0 = 0 = 0 0

Overdose = 0 1 = 0 = 1 = 1 = 1 = 0 = 0 = 0 = 1 = 1 0

But = if the user selects fiscal year the output could be:

Incident = Jun = Jul Aug sept Oct Nov Dec Jan Feb Mar Apr May

=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D = =3D=3D=3D =3D=3D=3D = =3D=3D=3D=3D =3D=3D=3D = =3D=3D=3D=3D =3D=3D=3D = =3D=3D=3D=3D =3D=3D=3D=3D = =3D=3D=3D=3D =3D=3D=3D=3D = =3D=3D=3D=3D

Falls = = 1 = 1 = 0 = 0 = 0 = 0 = 0 = 0 = 0 = 0 = 0 0

Overdose = 0 1 = 0 = 1 = 1 = 1 = 0 = 0 = 0 = 1 = 1 0

I = have created select views for each month possibility, but I don’t know how to select the view I need from an IF/Then/else statement!!

Any = help would be appreciated.

Thanks

------_=_NextPart_001_01C76FAB.B709C565--