crystal report help needed for parameters field

Question

i am developing a windows application, I have my database in MS-Access. I want to create a crystal report which have the fields License key, Activation Date, Expiry date. I want to add parameters field in this report which will have activation date as Start date and Expiry date as End date. I have no knowledge of parameters field in crystal report. Please help me out with the coding and the steps how to add the start date and end date in the crystal report. 

Answer 1

i am developing a windows application, my database is in MS-Access. I have made a crystal report which is showing product name, activation date, expiry date and days left columns. I want to add one more formula field which will show the status like Running and Expired. If the days are left then it will show running and if the days are not left then it will show expired in that column.

I have made a formula field Days Left, which is showing the days left for the expiry, its working fine but now i want that it will also show the negative days. Like if the product gets expired then the days left field will show the negative dates and the status field will display the status as expired . The code what i have written for formula field days left is:

DateDiff ("d", {tblwarranty.warrantyExpiry} , CurrentDate )

Please help me out with the solution. Please give the code also.

Answer 2

Hi,

You might want to take a look at the tutorial about how to use parameters:
http://devlibrary.businessobjects.com/BusinessObjectsXIR2/en/en/CrystalReports_dotNET_SDK/crsdk_net_doc/doc/crsdk_net_doc/html/crtsktutorialsrdparametersdiscrete.htm

Harry

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.