开发者

How to migrate the Conditional Running Total Field in Crystal Report to MS SQL Server Reporting Service

开发者 https://www.devze.com 2023-01-24 22:05 出处:网络
For example, there is a DB view named as View_NegAsset with fields: Equity_Percent L_PD_MTH HKD_BAL Inside the Crystal Report [Edit Running Total Field], we have:

For example, there is a DB view named as View_NegAsset with fields:

  1. Equity_Percent
  2. L_PD_MTH
  3. HKD_BAL

Inside the Crystal Report [Edit Running Total Field], we have: Field to summarize: HKD_BAL Type of summary: sum Use a formula: {View_NegAsset.Equity_Percent} <= 60 and {View_NegAss开发者_运维技巧et.L_PD_MTH} = 1

Please kindly advise what will be the corresponding SSRS expression?

Thank you very much.

BRs, William

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号