Re: [development-axapta] Re: How to Company as parameter to SSRS report?
Hi Prass Thanks for your reply. Could you Please explain in detail How do i pass curExt() value as my MenuItem Parameter I have @strCompanyId as parameter in my menuitem which i already created in my SSRS report too. I would appreciate if you guide me further on this. Pls find the attached screeen capture for more details Thanks Jaffar From: Prasetyo Budi Utomo prass...@yahoo.com To: development-axapta@yahoogroups.com Sent: Tuesday, March 10, 2009 9:10:00 PM Subject: [development-axapta] Re: How to Company as parameter to SSRS report? Hi Jaffar, In SSRS I usually create Store Procedure and define a parameter to filter dataareaid (company) then include curext() statement/command in AX to call that parameter. Prass --- In development-axapta@yahoogroups.com, Jafar sjaf...@... wrote: Hi I have created a SSRS report and called from Dynamics AX MenuItem. To create SSRS report i used SQL Server Business Intelligence Dev Studio tool. I have Company ID as one of the (Hidden) parameters in the report and used in query too (as @compayid) When I call from Dynamics AX menu, How do I pass the current Company (CompanyId) where i'm in? I would appreciate if someone help me on this. Pls let me know if you need more information. Jaffar [Non-text portions of this message have been removed] Yahoo! Groups Links [Non-text portions of this message have been removed]
Re: [development-axapta] Re: Be aware for hiring
I work for a consulting company that does AX work. This is how we view the layers in AX: If a company hires us to make modifications, we agree on some requirements. Then we code the mods to solve those requirements. Because we are held to the accuracy of those mods meeting the agreed upon requirements, we would request the company does not modify anything in that layer. Now, lets say the contract is complete and the client finds a bug. They call us and ask us to fix it. We then load the changes we made into an environment and try to reproduce it. If we cannot, then we look at their current environment, and look for code in any layer above ours. If we find it, then we would ask them to reproduce it while logged into our layer. If they cannot, then we can assume the bug is not in our code, but in the upper layer. All contractors are going to have these worries - ie., how do they certify that their code meets the requirements given to them - without having to worry about other code breaking them. Indeed, this concern is not limited to AX consulting, but all custom programming. AX simply makes it easier. That said, if a consulting company, or client company, does not fully understand the layering in AX before signing a contract, they could indeed get themselves into a legal knot. Especially companies that are not used to the layer aspects of AX, will be more likely to sign a contract that negates all the benefits of the layers. The company I work for would never intentionally lock a customer out of the other layers by having them sign away those rights in a contract. If we did, the customer might be able to go to microsoft and complain, and microsoft may investigate and decide to remove their partnership with the company. This would not negate the already signed contract, but it may be enough to force a consulting company to re-negotiate such a contract. Anyways, I hope my post is helpful in regards to informing the group about how consulting practices work in the AX community. I don't see a flame-war as helpful to the group. --- On Tue, 3/10/09, Dinkar Lalit dinkarla...@yahoo.com wrote: From: Dinkar Lalit dinkarla...@yahoo.com Subject: Re: [development-axapta] Re: Be aware for hiring To: development-axapta@yahoogroups.com Date: Tuesday, March 10, 2009, 8:10 PM You are right in general, and you know it does not work that way. I disagree. Sorry! Two friends of my are excellent programmers, but the problem is that companies are hiring to clean up their messes (1), they do not know what kind of agreements they had with some dishonest consulting companies -- even though it is legal -- (2) and once they figure out that they cannot even change the CUS or USR layer even allowed because of the modification done with VAR layer and plus the consulting companies do not like them to change it since they want to do the job which is the money source for them. Why shouldn’t they? In addition, the consulting companies regulate it. Mentioned earlier, any company tries to hire an AX person (technical or functional even architect), the person hired is at the mercy of that consulting firm who did their work. That is the bottom line… Please be aware and do the following negotiations: 1. Do not buy or believe the THREE (3) MONTHS of proportion period. It is almost a gimmick, unless you are part of the consulting firm who did installations/ mods etc and/or they know you. 2. Make sure that get your HEALTH BENEFITS and 401K when you start (at start) working for the company. This is very important because the companies for the health benefits and 401K do not like people registered and fired immediately. Beside benefit, this is your negotiation! 3. Try to contact the consulting company immediately and get to know them, if you can. Find their team lead or manager, and talk about the situation. Most likely they know you since the company hires you gets their consent (kind of). 4. Good luck and be positive. Dinkar From: tony_zeigler tony_zeigler@ yahoo.com Subject: [development- axapta] Re: Be aware for hiring To: development- axa...@yahoogrou ps.com Date: Friday, March 6, 2009, 4:49 PM Umm 1. The point of a probation period is for the employer to judge your skill level. Not every employer uses probation periods - the following methods are common techniques US companies use to weed out weak workers: A. Probation period (as noted above). Usually 3 months, but duration is up to employer. During this period the employer will be judging how well you fit in their organization. They might let you go for poor performance, or because your too loud, or even too quiet. During this period you should make an effort to get to know your co-workers, understand your job, and of course always do your best work. B. Hire from a temp agency. Some companies hire most of their permanent staff by hiring temp workers thru a temp agency, and then
[development-axapta] Ax 2009 Fixed Assets Pdf
Does any body have the pdf for Fixed Assets in AX2009. Please send the same if you have it.Regards Abhay [Non-text portions of this message have been removed]
[development-axapta] AOS doesn't Start due to SQL login Error
When i try start AOS from services it can't start. I try it for Local system account . In the Event viewer i got the followng messages... Plz any one can tell the solution for thisSQL diagnostics: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.. Connect information was: Userid = [], Database = [OBSSMD_US], Server = [OBS-DYNAMICS-DB], DSN = [], Other = [] Fatal SQL condition during login. Error message: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.Regards Abhay [Non-text portions of this message have been removed]
[development-axapta] Could not transfer file from local machine to FTP Server.
Hi,
I need to transfer files from local machine to FTP Server. The following is
the code.
WinInet ftpInet = new WinInet();
;
handle = ftpInet.internetConnect(siteDetails.FTPServer,
siteDetails.UserId ? siteDetails.UserId :
anonymous,
siteDetails.Password ?
siteDetails.Password : anonymous);
if (ftpInet.FtpPutFile(handle, 'C:\test.txt', '/test/OUT/test.txt';) == 0)
{
error(int2str(WinInet::getLastError()));
}
ftpInet.internetCloseHandle(handle);
ftpInet.FtpPutFile is always returning 0 and throwing error. I can get
files, delete file but transfering back to FTP Server is a issue.
Any help is highly appreciated.
Thanks,
Rahul
Connect with friends all over the world. Get Yahoo! India Messenger at
http://in.messenger.yahoo.com/?wm=n/
[Non-text portions of this message have been removed]
[development-axapta] Client:Unexpected target(1)
Hi guys, its almost two days Im fighing against this error without understandig what does it mean ! When I try to print a report, directly to a printer, it returned me this error. I changed all the propreties of the report, but nothing.. Does someone know about this error and how you can solve it? bye for now.
[development-axapta] unable to create activity in Process
Hi All, Here I am facing an strange problem and looking forward help for you all, I am doing development on Ax 2009 sp1 with PSA enviornment in CRM module Here we have a form Lead Details form while we create a lead we need attach some qualifying process This qualifying process will list down under the activity tab in lower pan of same form. If I want to create a new activity in same form(Lead Details form) it is creating the new activity but the same activity is not getting any parent link id(Lead ID ) in Parent link table. So when we refrsh the activity form in lead details the newly created activity will not list thr(where as activity exisits in smmActivity form) anybody has any idea in this regard.. infect when i create a actiivty in attached Qualifying process in any lead it creates activity with parent link only pls help me out in this matter Regards Abhishek Mehta, [Non-text portions of this message have been removed]
[development-axapta] How to read from flat file?
Hi there, I am not having much exp. in Ax developement. Hence my question may be very basic. We are getting Item Details in a flat file periodically. How it can be read and updated in Ax via codeing? Thanks in Advance, Logu
[development-axapta] put numeric value in the report
Hi All, I am new in report design ax. I want to put numeric value at one of our column in the report but i don't know how. I already tried to put field integer / real but i don't know how to put the initial value=1. any easy solution for this? please advise. thank you. regards ape [Non-text portions of this message have been removed]
[development-axapta] Top margin changes by itself
Hi everyone Just spent most of the day with a strange problem regarding the top margin property on a design section of a report. The situation is: Client PC has no windows printers installed Using this client set the top margin to 4.2mm in an AX4.0 SP2 report Install a pritner on this client PC Log back into AX and when look at the property it is now 6.27mm and cannot be changed to be less (this change happens without any edit of the report object!!!) I am guessing that somehow AX tries to be smart and says the minimum top margin is 6.27mm Is this some kind of hard coded size? Or does AX AOT reports somehow check the default windows printer?!!! Look forward to hearing from you Thanks James [Non-text portions of this message have been removed]
[development-axapta] Run multiple reports from class
I'm trying to run several reports form a class extending runBaseReport.
This way I can use temptables (tmpAccountSum) as a datasource for all reports.
The report which have to be run depends on the itemid choosen by the user in a
dialog.
The problem is no matter what I do lastValueElementName always ends up with the
default: return reportstr(FIKPRDRRHDELUXE)
Code:
public identifiername lastValueElementName()
{
switch (ItemId)
{
case MW-RHDDELUXE :
return reportstr(FIKPRDRHDDELUXE);
break;
case MW-RRHDELUXE :
return reportstr(FIKPRDRRHDELUXE);
break;
case MW-CLASSIC :
return reportstr(FIKPRDCLASSIC);
break;
case MW-SOLIDE :
return reportstr(FIKPRDSOLIDE);
break;
case MW-HOR24X12 :
return reportstr(FIKPRHOR24X12);
break;
case MW-IZ43X19:
return reportstr(FIKPRDIZ43X19);
break;
case MW-SCHUIFHOR :
return reportstr(FIKPRDSCHUIFHOR);
break;
case MW-VZHOR17X17 :
return reportstr(FIKPRDVZ17X17);
break;
default :
return reportstr(FIKPRDRRHDELUXE);
}
}
public Object dialog(Object _dialog)
{
DialogRunbase dlg = super(_dialog);
//this.sendInfo(funcname());
dlgItemId = dlg.addFieldValue(typeid(ItemId),itemId);
return dlg;
}
/*
This method is used to receive the values from the dialog.
It is called if the user clicks OK in the dialog.
*/
public boolean getFromDialog()
{
boolean ret;
;
ret = super();
if (ret)
{
// this.sendInfo(funcname());
itemId = dlgItemId.value();
}
return true;
}
static void main(Args args)
{
FIKPBARapportGenerator FIKPBARG;
;
FIKPBARG = new FIKPBARapportGenerator();
if (FIKPBARG.prompt())
FIKPBARG.run();
}
It looks like ReportName in the next method is always set to the
lastValueElementName's switch default: return reportstr(FIKPRDRRHDELUXE)
In other words lastValueElementName is queried, itemid = empty because the
dialog didn't fire yeet and makeReportRun uses the default / useless
FIKPRDRRHDELUXE
public void makeReportRun(ReportName reportName = this.lastValueElementName())
{
Report report;
;
if (! reportRun || reportRun.name() != reportName)
{
if (sysArgs)
{
sysArgs.name(reportName);
}
else
{
sysArgs = new SysArgs(reportName);
}
sysArgs.caller(this);
// The report run can not be created with SysArgs therefore create
// a new Args object. The SysArgs data are copied into the Args object.
reportRun = classfactory.reportRunClass(SysArgs::copyArgs(sysArgs,
new Args()));
}
report = reportRun.report();
report.interactive(false);
queryNextUniqueId = report.query().getNextUniqueId();
treeQueryVersion= report.query().version();
}
Only after makereportrun the dialog fires, itemid is set but this always points
FIKPBARG.run() to the wrong report.
Thanks in advance,
Michael
[development-axapta] Re: Client:Unexpected target(1)
http://palleagermark.blogspot.com/2007/11/clientunexpected-target1.html Consider the fetch code read from top to bottom. During fetch you print docuRef first, then change the target of the report, e.g. from printer to screen, but docuRef cannot find out how to change target after it has been printed, hence the error. Solution - change target before you print docuRef Hopes this helps, Steffen --- In development-axapta@yahoogroups.com, daniele.selvi daniele.se...@... wrote: Hi guys, its almost two days Im fighing against this error without understandig what does it mean ! When I try to print a report, directly to a printer, it returned me this error. I changed all the propreties of the report, but nothing.. Does someone know about this error and how you can solve it? bye for now.
SV: [development-axapta] How to read from flat file?
the easiest way is using TextBuffer class. An other way is using one of the IO classes, such as io, asciiio, textio, commaio Eksamples is easy to find in the standard code. Fra: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] På vegne af sivlogu Sendt: 15. marts 2009 11:00 Til: development-axapta@yahoogroups.com Emne: [development-axapta] How to read from flat file? Hi there, I am not having much exp. in Ax developement. Hence my question may be very basic. We are getting Item Details in a flat file periodically. How it can be read and updated in Ax via codeing? Thanks in Advance, Logu [Non-text portions of this message have been removed]
[development-axapta] Form refresh displays random record
When i press F5 in PurchReqTable details form, the current record is gone and first record is displayed in that form. Are there any steps to be followed to make F5 work on a form? Thanks in advance, Jag
[development-axapta] Re: AOS doesn't Start due to SQL login Error
You can't use a local account when Sql is on a different server. See here for more on the topic: http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?dg=microsoft.public.axapta.programmingtid=a1ce9574-d58a-4e67-9e16-6c66df5ea081cat=lang=encr=USsloc=p=1 --- In development-axapta@yahoogroups.com, Abhay ab...@... wrote: When i try start AOS from services it can't start. I try it for Local system account . In the Event viewer i got the followng messages... Plz any one can tell the solution for thisSQL diagnostics: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.. Connect information was: Userid = [], Database = [OBSSMD_US], Server = [OBS-DYNAMICS-DB], DSN = [], Other = [] Fatal SQL condition during login. Error message: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.Regards Abhay [Non-text portions of this message have been removed]
[development-axapta] Re: How to read from flat file?
This is probably what you are looking for: How to import data in csv into a Form http://dynamicsuser.net/forums/t/23393.aspx --- In development-axapta@yahoogroups.com, sivlogu sivl...@... wrote: Hi there, I am not having much exp. in Ax developement. Hence my question may be very basic. We are getting Item Details in a flat file periodically. How it can be read and updated in Ax via codeing? Thanks in Advance, Logu [Non-text portions of this message have been removed]
