Hey there,
I am building a report with all my items and itemids.
At the moment its showing me a mega list but I want to add another column in my report where it continues with the list before going to the next page. That way the page amount of the list will reduce
Situation now:
item id - item name | end page
Wanted :
item id - item name item id - item name | end page
Can I do this within AX?
Thanks in Advance.
Hey,
This functionality is really hard (at least for me),
I tried to do all tricks I can, but it look really hard, and I think may it is not applicable.
Actually I think about, what happen if you adust the paper setting when you print, but I didn’t do it.
the solution I’m sure about are two and both are external reporting,
A- Use crystal report it has much much more options, how to publish it is onther story.
here how to create the crystal report with multi-columns
<
Instead of having your data print straight down the page, you can set up multiple columns and have the data flow from column to column.
On the Report menu, click Section Expert.
Tip: 
Another way to do this is to click the Section Expert button on the Expert Tools toolbar.
In the Section Expert, highlight Details, and then select Format with Multiple Columns.
A Layout tab is added to the Section Expert.
Click the Layout tab and set the Width you want your column to be.
Keep in mind the width of your paper when deciding your column width. For example, if you have three fields in your Details section, and they take up four inches of space, limit the width of the column to under four and a half inches so that all the field information can be seen.
Set the Horizontal and/or Vertical gap you want to maintain between each record in your column.
In the Printing Direction area, choose a direction.
If the report you’re formatting contains grouping, select Format Groups with multiple column.
Click OK.
When you preview the report, you’ll see that the field headers appear only for the first column. To have field headers for the second column, insert a text object.
this the result
BEFORE:
1-
2-
3-
4-
AFTER:
1-
2-
B- you create webpage using ASP.Net and using .NET Business Connector
and I prefer the first way, just feeling.
I hope this can help you.
I think you can’t do it using Axapta.
Any how you can use crystel Report and publish it any way you like.
This how to do it in Crystal Report
<
This is the Result:
Before:
After:
I hope this can help.
Anybody?
I did post long answer with images,
but I don’t know why it didn’t published.
Well any how, I will give you the summery.
I spend long time trying to do it using the Dynamics Ax, but unfourtuanitly it look not applicable here.
So I suggest to use crystal report, it can do it, put in mindthat publish reports is another story.
Here how that:
<
Instead of having your data print straight down the page, you can set up multiple columns and have the data flow from column to column.
On the Report menu, click Section Expert.
Tip: Another way to do this is to click the Section Expert button on the Expert Tools toolbar.
In the Section Expert, highlight Details, and then select Format with Multiple Columns.
A Layout tab is added to the Section Expert.
Click the Layout tab and set the Width you want your column to be.
Keep in mind the width of your paper when deciding your column width. For example, if you have three fields in your Details section, and they take up four inches of space, limit the width of the column to under four and a half inches so that all the field information can be seen.
Set the Horizontal and/or Vertical gap you want to maintain between each record in your column.
In the Printing Direction area, choose a direction.
If the report you’re formatting contains grouping, select Format Groups with multiple column.
Click OK.
When you preview the report, you’ll see that the field headers appear only for the first column. To have field headers for the second column, insert a text object.
Sorry for the latency, I thought that it was posted already.
hope this will help you.
This is the results
Before
After
Before:
Settings:
After:
That’s it.
Thanks for the CR solution but I cant use it and I have to do it within Dynamics AX. Are you sure there is no way to do this within AX.
Have anybody found a solution yet for this problem?
There is a solution to the problem but it’s a dirty one. I used it to display 2 columns in inventory location barcodes report.
First of all, you have to modify fetch(). While going through the loop, you have to fetch 2 records per each loop count. In the loop, you handle the first record and then check if the next record is available. If so - handle it as well. If not - stop the loop. Second - you have to have a programmable section with fields being handled by display methods instead of having a regular section connected to a datasource. Each column has to be displayed by different display methods that return value of different (typically global) variables. You set those variables while going through the loop in fetch. If the fetch loop stops at the first (left) column and can’t fetch the record for the second column, you have to hide the fields at the right. I perfectly know how dirty and not-correct-with-the-best-practises it is, but it works quite well. It requires some time to create a report that way, but it’s the result that counts. Here is how the fetch method looks like when I used it for barcode printing - all should be intuitional to proccess to your needs. Hope that helps:
while (qr.next())
{
currentWMSLocation = qr.get(tableNum(WMSLocation));
leftInventLocationId = currentWMSLocation.inventLocationId;
leftAisleId = currentWMSLocation.aisleId;
leftRack = currentWMSLocation.rack;
leftLevelId = currentWMSLocation.level;
leftCheckText = currentWMSLocation.checkText;
leftBarcodeEAN128 = BarcodeEAN128::construct();
leftBarcodeEAN128.string(true, leftCheckText, BarcodeContentType::WMSLocation);
leftBarcode = leftBarcodeEAN128;
leftBarcode.encode();
showLeftBarcode.font(‘BC C128 Narrow’);
showLeftBarcode.fontSize(92);
isRightSectionVisible = qr.next();
if (isRightSectionVisible)
{
currentWMSLocation = qr.get(tableNum(WMSLocation));
rightInventLocationId = currentWMSLocation.inventLocationId;
rightAisleId = currentWMSLocation.aisleId;
rightRack = currentWMSLocation.rack;
rightLevelId = currentWMSLocation.level;
rightCheckText = currentWMSLocation.checkText;
rightBarcodeEAN128 = BarcodeEAN128::construct();
rightBarcodeEAN128.string(true, rightCheckText, BarcodeContentType::WMSLocation);
rightBarcode = rightBarcodeEAN128;
rightBarcode.encode();
showRightBarcode.font(‘BC C128 Narrow’);
showRightBarcode.fontSize(92);
}
element.setRightSectionVisibility(isRightSectionVisible);
element.execute(1);
}
ret = true;
return ret;
Hope that helps in some way. Regards.