Click here to Skip to main content
15,887,083 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
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
Posted
Comments
Basmeh Awad 3-Jun-13 4:22am    
this is not a good question..what code are you writing. you have to show your code how.. people will help you
killolpatel 3-Jun-13 4:28am    
Hey i just want to do one thing
i have one from which is printing the receipt for the company and i just want to do that
i want to print the the record which is inserted last by the user in crystal report in vb.net
and i have one button for printing the report as well.

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:
SQL
SELECT LAST(CustomerName) AS FirstCustomer FROM Customers;
 
Share this answer
 
but how to use "SELECT LAST(CustomerName) AS FirstCustomer FROM Customers; in vb.net
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900