-
bonjour, Il suffit de faire un report avec l'assistant état, vous mettez la table vendTable comme dataSource et vous sélectionnez les champs que vous voulez voir apparaître. Pour les filtres, à l'ouverture, il y a la fenêtre de paramètres qui s'ouvre, il suffit de les champs sur lesquels on veut filtrer et les valeurs pour ces filtres et le report sera filtré en fonction. Cdlt, Thomas
-
Hi, I had the same problem, AX 2009 has some bugs when using server side batch, I got around this problem by adding code that check the file size after the file generation, if size = 1ko, I restart the process. In 99% of cases it works fine but once I saw file regeneration during 2 hours in batch history. I used the following code: System.IO.FileInfo generatedFile; ; //file processing generatedFile= new System.IO.FileInfo(strfmt('%1%2',path,filename)); length = generatedFile.get_Length();
-
I think you don't manage permissions correctly, try the following code, it works for me: Set permissionSet; ; permissionSet = new Set(Types::Class); permissionSet.add(new FileIOPermission(fileName,'w')); // 'W' is important in this case permissionSet.add(new InteropPermission(InteropKind::ClrInterop)); CodeAccessPermission::assertMultiple(permissionSet); //your processing CodeAccessPermission::revertAssert(); Let me know if it solves your problem Thomas
-
Hi, Did you try the following when untick your checkBox : this.Query().datasourceNo(1).clearRanges(); yourDatasource_ds.executeQuery() ; or yourDataSource_ds.research(true); let me know if it works for you Regards, Thomas
-
Hi, I'm using AX 2009 and I had the same problem, in the encodeString() method around line 110: tichr++; if (shift) { if (codeset == #CodesetA) rtnint = (tcchr <= 31 || tcchr > 127) ? #NotFound : tcchr - 31; // is tcchr in codeset B? else { rtnint = (tcchr < 0 || tcchr > 127) ? #NotFound : (tcchr <= 31) ? tcchr + 65 : tcchr - 31; // is tcchr in codeset a if (charVal == 32) { //rtnint = 95 <========== comment this line and add rtint = 1 like follows rtnint = 1; It solved my problem
-
Hi, I'm using AX 2009 and I have exactly the same problem, I can't run some fonctions on server, I wanted to upload csv files on FTP repository. I have tried the same code as yours but without any results, OK on client but error on server. I found a workaround, I use Powershell script ran by windows task scheduler. Some say it's an AX bug, other say that's a security restriction. Let me know if you succed in solving this problem regards, Thomas
-
Hi, You can set the showZero field property to no. regards, Thomas
-
In this case, you should set your field autodeclaration property to yes and in the executeSection() method, add the following code if(yourField.value == 0) yourField.visible(false); It should solve your lineAbove problem. Please verify solution if it solves your problem regards, Thomas
-
YourField.value is an exemple, I meant YourTable.YourField, you put your code in the executeSection() method of the the section where your field appear, don't foeget to set the autodeclaration property to yes and use the NAME of your field in the design view ,not the table field as follows: if (yourTable.YourField == 0) ==> value stored in datasource yourFieldName.visible(false); ==> this modifies the visible property of the field that displays your value in design regards, Thomas
-
Hi, I see 2 solutions : -in the printer box that open when you want to print a report, you can select print to file avec select pdf format ==> fast and simple no coding required -you can use the reportrun class to generate your report directly in pdf without preview : quickly on a button clicked() method: filename = strfmt("%1%2",reportname,".pdf"); path = "\\\\Server\\Directory""; report = new ReportRun(new Args(ReportStr(yourReport))); report.query().interactive