Thread: Selecting different views from a Boolean expression

Selecting different views from a Boolean expression

From
"Wilkinson, Jim"
Date:
<p align="LEFT"><span lang="en-ca"><font face="Arial" size="2">Hi there,</font></span><span lang="en-ca"></span><span
lang="en-ca"></span><p align="LEFT"><span lang="en-ca"><font face="Arial" size="2">I have a web based reporting system
thatI am coding.  I need to be able to view statistics by the calendar year or the fiscal year</font></span><span
lang="en-ca"></span><spanlang="en-ca"> <font face="Arial" size="2">depending</font></span><span
lang="en-ca"></span><spanlang="en-ca"><font face="Arial" size="2"> on what the user selects.</font></span><p
align="LEFT"><spanlang="en-ca"><font face="Arial" size="2">My issue is how do I change y select statements
to</font></span><spanlang="en-ca"></span><span lang="en-ca"> <font face="Arial" size="2">change</font></span><span
lang="en-ca"></span><spanlang="en-ca"><font face="Arial" size="2"> the column</font></span><span
lang="en-ca"></span><spanlang="en-ca"> <font face="Arial" size="2">output?</font></span><span lang="en-ca"></span><span
lang="en-ca"></span><palign="LEFT"><span lang="en-ca"><font face="Arial" size="2">Example</font></span><p
align="LEFT"><spanlang="en-ca"><font face="Arial" size="2">Incident                Jan     Feb     Mar     Apr    
May    June    July    Aug    </font></span><span lang="en-ca"></span><span lang="en-ca"> <font face="Arial"
size="2">Sep    Oct     Nov     Dec</font></span><p align="LEFT"><span lang="en-ca"><font face="Arial" size="2">=======
===    ===     ===     ====    ===     ====    ===     ====    ====    ====    ====    ====</font></span><span
lang="en-ca"></span><spanlang="en-ca"></span><p align="LEFT"><span lang="en-ca"><font face="Arial" size="2">Falls  
       1       1       0       0       0       0       0       0       0       0       0       0</font></span><p
align="LEFT"><spanlang="en-ca"><font face="Arial" size="2">Overdose        0       1       0       1       1      
1      0       0       0       1       1       0</font></span><span lang="en-ca"></span><span lang="en-ca"></span><br
/><br/><p align="LEFT"><span lang="en-ca"><font face="Arial" size="2">But if</font></span><span
lang="en-ca"></span><spanlang="en-ca"> <font face="Arial" size="2">the user selects fiscal year</font></span><span
lang="en-ca"></span><spanlang="en-ca"> <font face="Arial" size="2">the output could</font></span><span
lang="en-ca"></span><spanlang="en-ca"> <font face="Arial" size="2">be:</font></span><span lang="en-ca"></span><span
lang="en-ca"></span><br/><p align="LEFT"><span lang="en-ca"><font face="Arial" size="2">Incident               
J</font></span><spanlang="en-ca"></span><span lang="en-ca"><font face="Arial" size="2">un</font></span><span
lang="en-ca"></span><spanlang="en-ca"><font face="Arial" size="2">    </font></span><span lang="en-ca"></span><span
lang="en-ca"><font face="Arial" size="2">Jul</font></span><span lang="en-ca"></span><span lang="en-ca">    </span><span
lang="en-ca"></span><spanlang="en-ca"> <font face="Arial" size="2">Aug</font></span><span lang="en-ca"></span><span
lang="en-ca">    </span><spanlang="en-ca"></span><span lang="en-ca"> <font face="Arial"
size="2">sept</font></span><spanlang="en-ca"></span><span lang="en-ca">   </span><span lang="en-ca"></span><span
lang="en-ca"><font face="Arial" size="2">Oct</font></span><span lang="en-ca"></span><span lang="en-ca">    </span><span
lang="en-ca"></span><spanlang="en-ca"> <font face="Arial" size="2">Nov</font></span><span lang="en-ca"></span><span
lang="en-ca">    </span><spanlang="en-ca"></span><span lang="en-ca"> <font face="Arial" size="2">Dec</font></span><span
lang="en-ca"></span><spanlang="en-ca">    </span><span lang="en-ca"></span><span lang="en-ca"> <font face="Arial"
size="2">Jan</font></span><spanlang="en-ca"></span><span lang="en-ca">    </span><span lang="en-ca"></span><span
lang="en-ca"><font face="Arial" size="2">Feb</font></span><span lang="en-ca"></span><span lang="en-ca">    </span><span
lang="en-ca"></span><spanlang="en-ca"> <font face="Arial" size="2">Mar</font></span><span lang="en-ca"></span><span
lang="en-ca">    </span><spanlang="en-ca"></span><span lang="en-ca"> <font face="Arial" size="2">Apr</font></span><span
lang="en-ca"></span><spanlang="en-ca">    </span><span lang="en-ca"></span><span lang="en-ca"> <font face="Arial"
size="2">May</font></span><spanlang="en-ca"></span><span lang="en-ca"></span><p align="LEFT"><span lang="en-ca"><font
face="Arial"size="2">======= ===     ===     ===     ====    ===     ====    ===     ====    ====    ====    ====   
====</font></span><spanlang="en-ca"></span><span lang="en-ca"></span><p align="LEFT"><span lang="en-ca"><font
face="Arial"size="2">Falls           1       1       0       0       0       0       0       0       0       0      
0      0</font></span><p align="LEFT"><span lang="en-ca"><font face="Arial" size="2">Overdose        0       1      
0      1       1       1       0       0       0       1       1       0</font></span><span lang="en-ca"></span><span
lang="en-ca"></span><br/><p align="LEFT"><span lang="en-ca"><font face="Arial" size="2">I have created select views for
eachmonth</font></span><span lang="en-ca"></span><span lang="en-ca"> <font face="Arial"
size="2">possibility,</font></span><spanlang="en-ca"></span><span lang="en-ca"><font face="Arial" size="2"> but I
don</font></span><spanlang="en-ca"></span><span lang="en-ca"><font face="Arial" size="2">’</font></span><span
lang="en-ca"></span><spanlang="en-ca"><font face="Arial" size="2">t</font></span><span lang="en-ca"></span><span
lang="en-ca"><font face="Arial" size="2">know</font></span><span lang="en-ca"></span><span lang="en-ca"><font
face="Arial"size="2"> how to</font></span><span lang="en-ca"></span><span lang="en-ca"> <font face="Arial"
size="2">select</font></span><spanlang="en-ca"></span><span lang="en-ca"><font face="Arial" size="2"> the view I need
froman IF/Then/else</font></span><span lang="en-ca"></span><span lang="en-ca"> <font face="Arial"
size="2">statement!!</font></span><spanlang="en-ca"></span><span lang="en-ca"></span><p align="LEFT"><span
lang="en-ca"><fontface="Arial" size="2">Any help would be</font></span><span lang="en-ca"></span><span lang="en-ca">
<fontface="Arial" size="2">appreciated</font></span><span lang="en-ca"></span><span lang="en-ca"><font face="Arial"
size="2">.</font></span><palign="LEFT"><span lang="en-ca"><font face="Arial" size="2">Thanks</font></span><span
lang="en-ca"></span><spanlang="en-ca"></span><p align="LEFT"><span lang="en-ca">       </span><span
lang="en-ca"></span><spanlang="en-ca"> </span>