使用crystal report在SQL Server中提取数据 [英] Extracting data in SQL server using crystal report

问题描述

大家好，


我是sql server的新手。我正在使用Sql server 2000，它有包含客户详细信息的表

。我的问题是：


有没有办法使用Crystal Reports提取Sql server数据库中的数据。我知道如何使用Crystal报表进行报告而不是提取。因为我的公司将来不会有任何sql程序员，他们计划这样做。这可能吗？

Hi All,

I am new to sql server. I am working with Sql server 2000 which has tables
containing customer details. My question is :

Is there any way to extract the data in Sql server database using Crystal Reports. I know how to use Crystal report for reporting purpose but not for extraction.Since my company will not have any sql programmer in future they are planning to do this way. Is this possible?

推荐答案

当你说提取时，你的意思是什么？


你可以使用CR查询数据库并根据您的要求构建报告。

What do you mean, exactly, when you say "extract?"

You can use CR to query a database and build reports from that, if that is what you are asking.

你是什么意思，确切地说，当你说提取？


你可以使用CR查询数据库并从中构建报告，如果这是你要求的。

What do you mean, exactly, when you say "extract?"

You can use CR to query a database and build reports from that, if that is what you are asking.

是的。我有一个包含客户详细信息的表。例如，


我必须提取年龄大于20的客户的所有详细信息。如何在CR中执行此操作。

Yes. I have a table that contains details of Customers. For ex,

I have to pull all the details of customers whose age is greater than 20.How can i do this in CR.

在Field Explorer中，右键单击Database Fields，然后选择Add / Remove Database。

In the Field Explorer, Right-click on Database Fields, and select Add/Remove Database.

是。我有一个包含客户详细信息的表。对于前者，


我必须提取年龄大于20岁的客户的所有详细信息。如何在CR中执行此操作。

Yes. I have a table that contains details of Customers. For ex,

I have to pull all the details of customers whose age is greater than 20.How can i do this in CR.

这篇关于使用crystal report在SQL Server中提取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！