Hi,
can you give me sample code of the INIT method of the report that can
select specific design based on parameter ? I have a requirement that
there are two differen design of the report, one is detailed report
and the other is just a summary report.
Thanks,
Patrick
--- In
Hi,
I am able to find a perticular transaction from my
transfer journal i need to un reserve and succeeded
in unreserving the quantity.
Here is the code i used for un reserving :
-
InventMovement =
Hi Arijit,
I've already downloaded the sample code for the temporary table in
report. The sample work great. However my concern is how to apply it
to my own scenario. I have a report that populate the temp table from
a buildquery method of the class that is extended from runbasereport.
I can
Hi Imthiyaz Ahamed,
Pls look at this site about date conversion. You can use the format
as explained below and maybe you an just add new function to
concatenate the th or rd to make the day appear as 25th or 3rd.
the logic will be similar to this:
if the day more than 3 - you add th as in
In one of my reports I need to sort one of my field in ascending
order, I have already used the group by clause in my select query so
it is not allowing me to use the order by clause along with that. Can
anybody suggest me anyway to do it.
What do you mean with disappear?
Have you try to inquiry the Batch List form using different status?
At the top left of Basic - Inquiry - Batch List form you have a show
status combo box, have you try to inquiry the form with Ended status. The
status of a job that successfully executed
Hi Patrick,
If you plan to initialize your report from menu/menuitems, then you
should configure two almost identical menuitems, one with a
parameter configured and one without parameter or a different
parameter. These parameters are automatically send as Args-object
parameters to the
Hi,
I've used temp table to store temporary the data before it goes to the
printer. My problem is that the generation of the table takes too long
aroune 20 minutes. But when I run a stored proce, it takes only less
than few 5 minutes. Is Ax temp table really slow ? is there a better
way of
Hi Imthiyaz Ahamed,
Pls visit this site for more info on date2str.
http://www.axaptapedia.com/User_talk:Patrickchuad
on your requirement I think you just create a class that will add the
suffix to day of the month. The logic will be as follows:
if the day is greater than 5 then add st as in
I have never tried this before, but you might be able to build a query
from a query. So for example:
Query1 = Order By DataSet
Query2 = Built from Query 1, Group by the DataSet
I also thought you could Order and Group By within X++ SQL Statements...
thanks,
J. Brandon George
Senior
hi pankaj_dbc,
please post your code so that you will be helped
-subbu
Brandon George [EMAIL PROTECTED] wrote:
I have never tried this before, but you might be able to build a query
from a query. So for example:
Query1 = Order By DataSet
Query2 = Built from Query 1,
An example... some functions.
transdate KikeDate = systemdateget();
;
info(strfmt(%1 %2th, %3,mthname(mthOfyr(KikeDate)), dayofmth(KikeDate),
year(KikeDate)));
Saludos.
On 1/25/07, Imthiyaz Ahamed [EMAIL PROTECTED] wrote:
Hi Siva,
Thanks for your Reply. It is vey useful for me, But My
Hi to everybody.
I have a big problem to update InventTrans when the periods have been
closed with InventoryClosing.
This is the example, i'm running a new development call it Monetary
Correction, this development search and select on InventTrans all
transactions with ValueOpen == Yes.
This
13 matches
Mail list logo