English 中文(简体)
未运行和内选的晶报告
原标题:Crystal reports with not in function and inner select

我的问题是,有这种疑问,并计划这样做。 我的问题是,如何在内部选择报告时不这样做?

   select prop_acct_no,land_book_value, impr_Book_value,current_book_value,lat_appr from prop_acct 
    where
    PROP_ACCT.PROP_STATUS =  CON  and 
    PROP_ACCT.SUBSTATUS in ( AFS ,  FAS ) and
    PROP_ACCT.IL_STATUS = N  and 
    PROP_ACCT.PROP_ACCT_NO  not in 
    (select PROP_ACCT_NO from SP_DETL, SP_MAST where SP_DETL.SP_NO = SP_MAST.SP_NO and STATUS =  Approved )

很多 感谢!

问题回答

你可以提出这种意见/程序,并具体利用这种观点/程序。 更好地利用储存程序。 从我与它合作的经验来看,很难撰写复杂的问题。

利用“附加指挥部”报告办法(在连接点上发现一个活跃的数据库文档或ODBC数据来源),在该报告中添加你的询问。





相关问题
1099r IRS form instal Report

我们需要从申请中产生1099r份IRS报告,我们已决定用晶报告编写这份报告。 很奇怪的是,任何人都这样做了,如果是,可以......

How to split a Crystal Reports subreport across a page break?

I m using Visual Studio 2005 and writing in VB.NET. I have a subreport in a Crystal Reports report consisting of a list of log entries. Sometimes the list of log entries is long enough that it would ...

Adding Crystal Reports support into LAMP product

We have a newly documented feature request, from sales and support, to integrate Crystal Reports into our LAMP product. (It s more like LAPP, really, with Postgres and PHP.) I have to admit, ...

Crystal Report value Convertion?

i have to crystal report made from Dataset,and we have to one formula field i wrote Add() but that formula field show cancatination like 10+20=1020 i realize they need to convert that field in sight ...

How to Hyperlink to a Business Objects Report in Infoview

Is there a way to craft a hyperlink that connects to a Crystal Report or Webi within Infoview? Ideally, unauthenticated users would be challenged with Infoview security and then redirected to the ...

Crystal Report XI trouble with big XML data file

I have a big xml file (65 Mo) that I need to feed to a Crystal Report XI. My problem is that I tried running the report and it takes forever to display a single page (about 15 minutes a page). I still ...

Transferring Crystal report

I have created a crystal report in VS 2005 using the wizard. In the report I have created an OLE DB connection to a server which has a database student . Now I need to run this report on another ...

热门标签