我不会在我的水晶报告中显示许多记录，我怎么才能显示当前记录？ [英] i wont to show many record in my crystal report, how i can show current record only?

问题描述

我不会在我的水晶报告中显示许多记录，我怎么才能显示当前记录???



当我点击显示报告时它可以显示我所有记录...我只需要看一条记录

i wont to show many record in my crystal report, how i can show current record only???

when i click show report it can show me all record...i need to see only one record

推荐答案

如果您只想显示输入的最后一条记录，您只需修改 SQL查询使用最后（） [ ^ ]功能并获取最后一个值输入的独特记录。



例如：

If you want to display only last record which is entered, you can simply modify your SQL query by using LAST()[^] function and get the distinct record in which last value has entered.

for e.g:

SELECT LAST(CustomerName) AS FirstCustomer FROM Customers;

但如何使用SELECT LAST（CustomerName） ）AS来自客户的FirstCustomer;在vb.net中

but how to use "SELECT LAST(CustomerName) AS FirstCustomer FROM Customers; in vb.net

这篇关于我不会在我的水晶报告中显示许多记录，我怎么才能显示当前记录？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！