<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />Dear All,
Here i get a table from a access file with the following JSL and perform the further analysis like control chart. I perfer to make the table invisible after i get the control chart. Can i realize it. Thank you in advance.
dt =Open Database("DSN=MS Access Database;DBQ=F:\满易冻干坪效管理系统.accdb;DefaultDir=F:\;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;UID=admin;","SELECT * FROM `Q QC Internal Lead Time`");
New Column( "QC L/T", 数值型, 连续型, 格式( ":day:hr:m", 14, -1 ), 输入格式(":day:hr:m", -1), 公式( :QC报告日期 - :QC接单日期 ) );
r = dt << Select Where(:品名 == "注射用盐酸氨溴索" );
r << Colors( "Red" );
r = dt << Select Where(:品名 == "注射用盐酸克林霉素" );
r << Colors( "blue" );
dt<< Control Chart(
Sample Label( :QC接单日期 ),
Group Size( 1 ),
KSigma( 3 ),
Show Limits Legend( 0 ),
Chart Col(
:Name( "QC L/T" ),
Individual Measurement( Show Center Line( 0 ), Show Control Limits( 0 ) )
),
SendToReport(
Dispatch(
{"“QC L"},
"2",
ScaleBox,
{Format( ":day:hr:m", 14, -1 ), Min( -2000000 ), Max( 11000000 ),
Interval( "Month" ), Inc( 1 ), Minor Ticks( 0 )}
),
Dispatch(
{"“QC L"},
"IR Chart of IM",
FrameBox,
{Frame Size( 574, 327 ), Grid Line Order( 1 ), Reference Line Order( 2 )
}
)
)
);
