CROSSTAB报告 我有2种模式,想要在列中出现字符总和 我想要如下所示的交叉表报告, 我已经创建了它,但问题是, 当0我要显示*和1然后''a'' 和每行的最后总数''a''栏目
CROSSTAB Report I have 2 modes and want sum of occurrence of character in column I want cross tab report like below, I have already create it but problem is, when 0 I want to display * and 1 then ''a'' and last total of ''a'' for each row & column
name Mode 1 2 3 Total ------------------------ a * * a 1 b a * a 2 c a a * 2 ------------------------ total 2 1 2 -推荐答案
希望它对我们有用他们有同样的问题, 这不是直接可能的,你可以按照以下步骤输出相关的输出。 i创建公式@mode, Hope it will useful to them who have same problem, It''s not directly possible, you can follow below steps for output like given in question. i have create formula @mode, iif({table.mode}=0,"*","a")
ad下面的新部分报告页脚 现在,你有2个报告页脚 1.报告页脚a(设置参数以下部分= true) 2.报告页脚b now报告页脚a, 创建交叉表报告集col&行并在汇总字段中添加 @mode (摘要操作= @mode模式)现在,压制总计 将其粘贴到报告页脚b中, 选择夏季字段更改它的汇总字段= {table.mode} , (摘要操作= {table.mode}的总和) 现在,不要抑制此交叉表报告的总数 并且不显示交叉表报告中的网格线 - 2 注意,设置左上方的高度宽度等两个报告相同 它会给出欲望输出 (字符串col但数字总数) 快乐编码! :)
ad new section below report footer now, you have 2 report footer 1. Report footer a (set underlay following section = true) 2. report footer b now In report footer a, create crosstab report set col & row and add @mode in summarized field (summary operation = mode of @mode) now, suppress totals copy paste it in report footer b, select summery field change it''s summary field = {table.mode} , (summary operation = sum of {table.mode}) now, do not suppress total for this crosstab report and do not display grid lines in crosstab report - 2 note, set top left height width etc same for both report it will give desire output (string col but totals in numbers) Happy Coding! :)
更多推荐
交叉表var
发布评论