Cristiano

Has file get attached using users login?
Check the access rights of server folder.

Refer below code.

void clicked()
{
SysExcelApplication application;
SysExcelWorkbooks workbooks;
SysExcelWorkbook workbook;
SysExcelWorksheets worksheets;
SysExcelWorksheet worksheet;
SysExcelCells cells;
COMVariantType t…

Cristiano said:

EDt "DocuType"

Do you mean DocuTypeId?

Cristiano said:

i click the lookup it show all the valu..but what i want is to show the particular value ..

Do you want to filter only few values? On what criteria you want the filter?

How…

The content of you method is wrong. Most importantly, you never execute the query and iterate its results.
But don't bother fixing it - you don't have to implement your own fetch logic if your intention is simply to add query ranges. That's not fetching…

If you get an error, please always tell us what the error said and on which line it occurred.

Fortunately your two bugs are obvious to me, so I can answer it even with such an insufficient description.

This is the right syntax:

while select crossCompany…

d+1 mean the date plus one day.

You can learn basics of X++ from AX documentation. In this case, you can find it on MSDN under Primitive Data Types > Dates.

If the question about filtering is answered, please make sure you mark the thread accordingly…

Great! Next time, please try to explain it  by yourself. You'll save several days by that.

Your requirement clearly requires two ranges - one for FromDate and one for ToDate. And what should be values of those ranges should be clear from your two sentences…

OK so the problem is on the report, if you use a printer or print to file that the real design, try to set fixed size not autosize for textbox, images etc..

if you use a printer, does the format is alright?

if you only need date you have two options

set displayoption propertie of control to date

or

add a dateedit control not utcdatetime

as say Martin better options is

1.-Declare two querybuildRanges on your class declaration method.
2.-On init method of your dataSource addRange "after super"

qbr = this.query().querybuildDataSource.addrange(fieldnum(yourtable, yourfield)…

On classDeclaration

QueryBuildRange    qbr;

 

int init method of yourDataSource after super

 

qbr = YourDataSourceName_ds.queryBuildDataSource().addRange(fieldnum(yourtable, yourdateField));

 

in executeQuery before super

 

qbr.value(queryRange(fromdate, todate…

What exactly does the error say?

And why are you using a container? Why don't you create a class with two date values and one enum? You'll get a compile-time type control and code that's much easier to read and maintain.

For example, you'll…

You have many options. For example, you can create a class with a date parm* method and pass it via args.parmObject(). It's a good approach because you can write the whole thing completely type-safe and you can easily pass more than one value.

Another…

You don't need any code for it. Just bind the control to the same field. You can see it everywhere in AX - many forms have a grid with a few fields, plus tabs containing details for the currently selected record.