显示水晶报告的最新数据 [英] Display Recent Data on crystal report

问题描述

我已经在visual studio 2010中开发了带有水晶报告的窗体，我需要显示的是我想要显示在

水晶报告中输入的唯一最新数据，目前所有表记录正在显示。请帮帮我。

i have develop the windows form with crystal report in visual studio 2010 , all i need to show is that i want display the only recent data entered on the
crystal report , at present all table records are showing . please help me out .

推荐答案

您可以按日期显示最近的数据，您可以在具有DATETIME数据类型的表CREATED_ON中添加一列。

You can show recent data by datewise you can add one column in table "CREATED_ON" having DATETIME datatype.

SELECT * FROM TABLE_NAME ORDER BY CREATED_ON DESC

或

您可以使用自动标识设置Parimary密钥并按描述顺序设置检索记录

Or
You can set Parimary key with auto identity and retrive records by desc order

SELECT * FROM TABLE_NAME ORDER BY PRIMARY_COLUMN DESC

亲爱的Nirav我尝试了第一个解决方案，但我收到一个错误在sql server中。对于第二个解决方案，我想显示最近的数据以及最近输入的第一行数据，而不是我想要显示的数据。

Dear Nirav i tried the first solution but i am receiving an error in the sql server. and for the second solution i want to show recent data and also the only first row data that is entered recentlt not also the data i want to show .

这篇关于显示水晶报告的最新数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！