hi,
I am facing a problem in x++(ax 4.0) where I have to select given date range from data source query range of the report,
like user have to select fromDate and toDate using option it will be like 01/09/2011…30/09/2011.
Here I want to select date 01/09/2011 to use in code to get opening and closing balance.
kindly give some solution.
thanks in advance…
hi Sanjay,
You can create a dialog box…
Add two field (transdate) in dialog…fromdate , todate
initialize the two fields value , dialog reference in class declaration…
give the input taken from getfrom dialog method…
Now in fetch method, in your select query, use the input value from the fied that you have created in your dialog box…
thanks EnriqueKevin06,
For your quick reply but here i want to take from date directly from the range, if it possible it will be very useful to use in select query, because client is using that report from 2008.
Hi Sanjay,
I am not able to understand correctly…You want to use it through select query, that means you want to hot code it or how do you like to get the input…Please explain the scenario correctly… It is not possible to take the date directly from the query…so only we use dialog to get the value…