帮助创建公式 [英] Help in creating a formula

问题描述

我正在创建一个应收帐款报表
，其中我使用来自Access数据库的选择查询和
vb.net 2005作为我的前端应用程序。现在，在查询中有
字段PatientName和Company.Basically，一个患者将有一个
公司承担他/她的费用，但在某些情况下
没有，所以收费将是使用这个
场景，我按照公司名称按升序
对报告进行了分组，并创建一个名为@Patient的公式字段，其代码如下：
Crystal Report Code：

I am on creating an Accounts Receivable report wherein I am using a Select Query coming from my Access database and vb.net 2005 as my front end application.Now, on the query there were fields PatientName and Company.Basically, a Patient would have a Company that would shoulder his/her charges, but on some occasions there was none so the charges would be named to themselves.Using this scenario, I made my report grouped by Company's name in ascending order and make a formula field named @Patient with the code goes like this:
Crystal Report Code:

if {AccountReceivable.Company} =""然后{AccountReceivable.PatientName} else {AccountReceivable.Company}

if {AccountReceivable.Company}="" then {AccountReceivable.PatientName} else {AccountReceivable.Company}

推荐答案

数据库中存储的公司字段的值是多少。如果数据库中的值实际为空，则检查空字符串可能不起作用。

What is the value being stored in the database for the Company field.  Checking for an empty string may not work if the value in the database is actually null.

这篇关于帮助创建公式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！