如何在SQL Server Reporting Services中的每个组之后绘制线条 [英] How to draw line after every group in SQL Server Reporting Services

问题描述

我在一个产品中创建了2组1产品ID和2产品名称

它们可以是多个项目

其物料清单

产品名称项目批量大小批量UOM 
 ID和描述
项目名称
 101001旁遮普达尔塔德卡100 KGS 
 302010 Paneer 
 101002 Lucknowi Rajma Masala 220 KGS 
 301009 Rajma 
 302001向日葵精油
 302007牛奶
 302007牛奶
 303001 Ajwain 
 303004豆蔻（大/黑）

所以我想在每个产品ID结束后插入或画一条线

 = Iif（Fields！productid .Value = Previous（Fields！productid.Value）OR Fields！productid.Value = First（Fields！productid.Value，  MYD ataset）， 无，   Solid）
i尝试了但是没有得到正确的结果

我得到了此错误

文本框'prod_name'的BorderStyle表达式具有对聚合函数无效的作用域参数。 scope参数必须设置为一个字符串常量，该常量等于包含组的名称，包含数据区域的名称或数据集的名称。

解决方案

您需要使用数据集名称; mydataset 可能是复制粘贴错误：

 = Iif（Fields！productid.Value = Previous （Fields！productid.Value）OR Fields！productid.Value = First（Fields！productid.Value， mydataset ），None，Solid）

I have created 2 group 1 Product Id and 2 prodct name
in one product their can be multiple Items
its Bill of material

PRODUCT PRODUCT NAME ITEM                              BATCH SIZE   BATCH UOM
ID      AND          DESCRIPTION
        Item Name
101001  Punjabi Dal Tadka                                      100 KGS
        302010      Paneer
101002  Lucknowi Rajma Masala                                  220 KGS
        301009      Rajma
        302001      Sunflower Refind oil
        302007      Milk
        302007      Milk
        303001      Ajwain
        303004      Cardamom (Big/black)

so i want to put or draw a line after each product id ends

=Iif(Fields!productid.Value = Previous(Fields!productid.Value) OR Fields!productid.Value = First(Fields!productid.Value, "mydataset"),"None","Solid")
i tried but its not getting proper result

I get this error

The BorderStyle expression for the text box ‘prod_name’  has a scope parameter that is not valid for an aggregate function.  The scope parameter must be set to a string constant that is equal to either the name of a containing group, the name of a containing data region, or the name of a dataset.

解决方案

You need to use your dataset name; "mydataset" may be a copy-paste error:

=Iif(Fields!productid.Value = Previous(Fields!productid.Value) OR Fields!productid.Value = First(Fields!productid.Value, "mydataset"),"None","Solid")

这篇关于如何在SQL Server Reporting Services中的每个组之后绘制线条的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！