<style>.PTCC {background-color:white;border-top:white;border-bottom:white;border-left:white;border-right:white}</style>
use full for the prompt constraint from first to second
--------------------------------------------------------
time
code:
SELECT
case when 0= 1 then "Time"."Per Name Week" else 'Year' end
FROM "D-P Sales" union all SELECT case when 0= 1 then
"Time"."Per Name Week" else 'Month' end FROM
"D-P Sales"
Period
code:
SELECT
case when '@{Time}' = 'Month' then "Time"."Per Name Month"
when '@{Time}' = 'Year' then "Time"."Per Name Year" else
'N/A' end FROM "D-P Sales"
Code for vertical lines between words
'<table cellspacing="-0" border="0"
cellpadding="1"> <tr valign="top"
align="center"> <td width="306"><p>Sales
Store</p></td> <td width="-0"
bgcolor="#8B8989"><BR></td> <td
width="300" valign="top" align="center">
<p>Sales Index (Store)</p> </td>
</tr> </table>'
