关于.rpt: view或schedule时的连接界面及Prompts是否显示的设置

发布时间:2020-08-07 02:45:50 作者:xiangjinling
来源:ITPUB博客 阅读:176

BVM修改DC参数

[@more@]

通过BVM设置DC(即当前rpt所所用的DC):

关于.rpt: view或schedule时的连接界面及Prompts是否显示的设置

结果:

关于.rpt: view或schedule时的连接界面及Prompts是否显示的设置

没有设置的情况下:

关于.rpt: view或schedule时的连接界面及Prompts是否显示的设置

有一个连接参数输入界面,如上图。出现prompts,如下图:

关于.rpt: view或schedule时的连接界面及Prompts是否显示的设置

修改后:

关于.rpt: view或schedule时的连接界面及Prompts是否显示的设置

SDN论坛参考:

Dynamic Parameters. You'll want to get all your report designers up on this topic.

When you create a dynamic parameter in a Crystal Report, and then publish it to the Enterprise, you are creating a Business View, with all it's underlying necessary layers. Dynamic Parameters exist to be able to use the same LOV (a list of current customers) from a database for more than one report. These dynamic parameter LOVs act like a mini report that runs against the database and gets the current values for selection, then the selection(s) are used to run the overall report.

So I create a report, and in it I create a dynamic Customer LOV. When I save it, the Enterprise creates a Data Connection (DC), Data Foundation (DF), Business Element (BE), Business View (BV), and the list of values is built on the Prompt Group. So, my Business View Manager, Repository Explorer will show (in the default Dynamic Cascading Prompts folder):
Customer_DC
Customer_DF
Customer_BE
Customer_BV
Customer - Prompt Group
Customer (the LOV)

The idea is that next time I create a report and need a customer parameter, I select the existing dynamic group. If the report designer is unaware of this, and next time they create a new report that needs a customer LOV, they creates a new dynamic LOV "Customer", when saved to the Enterprise, it repeats the above. Since repository objects must have unique names, you will now have additional items something like:
Customer 2_DC
Customer 2_DF
Customer 2_BE
Customer 2_BV
Customer 2 - Prompt Group
Customer 2 (the LOV)

So you can see how that folder will get filled with duplicates pretty quickly. Which ones were created and used in which reports? Have to open the report in Crystal Reports, open the parameter for Edit and verify the LOV name (_2, _3, _4, etc). If you do in fact discover there are dupes, you can change it to a single one for all reports using a dynamic LOV, re-save them to the Enterprise, then delete the dupes in the BVM.

You've already discovered how to use the BVM to update the data connection to include/save the database credentials. The only other common issue is sometimes the LOV rights need to be changed in order to allow users to "Edit" the LOV (select different values in the LOV). You'd have to run the report as an end user, not the admin account or the report designer account to verify that works.

Another item of note is that these dynamic LOVs are run by the Report Application Server (RAS), regardless of which viewer you are using.

The Business View Manager administration guide has more information on the subject.
推荐阅读:
  1. Redis数据库备份与恢复
  2. centos7安装redis并设置开机启动

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

schedule 关于

上一篇:遇见Linux系统CPU使用率过高怎么办?

下一篇:VS2013解决error LNK2019: 无法解析的外部符号 mfcs120ud.lib

相关阅读

您好,登录后才能下订单哦!

密码登录
登录注册
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》