Crystal Report公式字段可检索数据库值 [英] Crystal Report formula field to retrieve Database Value

问题描述

在我的ASP.NET应用程序中，我正在使用Crystal Report向用户显示报表数据.

我的客户有将近10个分支机构.因此，我使用每个报表的公式字段来检索基于BRANCH ID的分支名称作为报表标题(我已经在每个表中都拥有了).
喜欢.

Hi,

In my ASP.NET application, I am using Crystal Report for showing Report data to Users.

My client having nearly 10 branches. Hence i use formula field for each report to retrieve BRANCH NAME as report title based on the BRANCH ID(I am already having for each table).
Like.

if (BranchID = 'BR001')
'xxxxx'
else if(BranchID= 'BR002')
'yyyy'
......
,,,,,,
......So on

现在的问题是，将来如果我需要更改任何一个分支名称，那么我需要为所有包含公式的报告更改分支名称.

还有其他方法可以根据BRANCH ID从Crystal报表访问BRANCH TABLE吗?
如果是这样，那么我可以简单地更改分支表中的分支名称影响所有报告.

希望你理解我的问题.

请帮帮我.

Now problem is, in future if i need to change any one Branch name, then i need to change the BRANCH NAME for all the reports containing formulas.

Is there any other way to reach the BRANCH TABLE from the Crystal report based on the BRANCH ID ??
If so, then i can simply change the branch name in branch table affects all the reports.

Hope you understand my question.

Please help me out.

推荐答案

是的，参数字段可以解决问题
C#Crystal Reports字符串参数 [ C#Crystal Reports整数参数 [

Yep, Parameter fields will do the trick
C# Crystal Reports String parameter[^]
C# Crystal Reports Integer parameter[^]

此文章-[在使用ASP.Net的Crystal Reports]/a> [

This article-[Set Parameter in Crystal Reports using ASP.Net]/a>[^] might help you.

这篇关于Crystal Report公式字段可检索数据库值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！