如何使用水晶报告获取特定数据 [英] how to get specific data using crystal report

问题描述

嗨SQL和Crystal Expert，



我是这个水晶报道的新手，对如何实现这个问题有一些疑问...



在SQL中我可以创建一个语句，我可以使用WHERE命令



SQL

表

名字姓氏年龄性别记录

Noel Serrano 12 M 224 ????

Noel Serrano 15 M 224 ???? br />
Noel Serrano 14 M 224 ????

等等...假设我有很多



在SQL中如果我想显示年龄= 12的记录很容易

SELECT * from TABLE其中age = 12



那么我会下线

Noel Serrano 12 M伦敦



但是如何在水晶报告中做到这一点？我想使用过滤器age = 12然后我将在noel年龄为12岁的行上显示特定的记录。



非常感谢很多..

Zir

Hi SQL and Crystal Expert,

I am new to this crystal reporting and have some question on how to implement this...

In SQL I can create an statement where I can use a "WHERE command"

SQL
Table
Name Surname Age Sex Recordd
Noel Serrano 12 M 224????
Noel Serrano 15 M 224????
Noel Serrano 14 M 224????
and so on... assuming i have lots

In SQL if I wanted to show the record where age = 12 is easy
SELECT * from TABLE where age =12

then I will get the line
Noel Serrano 12 M London

but how to do this in crystal report? I want to use the filter "age = 12" then I will show the specific "recordd" on the report from the line where noel is age 12.

Thank very much..
Zir

推荐答案

您可以在报表中使用数据库专家定义sql命令，也可以执行所有SQL内容代码隐藏并使用其数据源将结果传递给您的报告。

You can either define a sql command in your report with the database expert or do all your SQL stuff in codebehind and pass the result to your report with its datasource.

这篇关于如何使用水晶报告获取特定数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！