I am creating report for Purchase Requisitions that display lines detail of the selected purchase. But when I print the report, I notice that each line displayed has its header of table, So if I have three lines, there will be three header for every line. How do I fix this? I’ve checked and changed in fetch, report design, etc, but the header is still remained appear. Please help me thanks.
is it the standard report or customized one,
It would be better if you explain bit more about changes you did and attach screen shots…
Hi Krisna, it’s the customized one.
Query I made:
SELECT * FROM PurchReqTable(PurchReqTable) WHERE ((PurchReqId = N’PR-000543’)) JOIN * FROM PurchReqLine(PurchReqLine) ON PurchReqTable.RecId = PurchReqLine.PurchReqTable
Changed I did:
firstly I create method to display string, then I delete methodes and drag field to header and body of report design.
first I got only one lines, when it should be two or more lines based on the purchase. then I drag PurchReqLine as data source and joined with PurchReqTable which is the only data source before. then I made query run for PurchReqLine in fetch method.
Hi Daniel, please always mention your version of AX and the reporting framework (it’s important in AX 2009, which supports both MorphX and SSRS reports). Whether you mean a MorphX report in Axapta 3.0 or an SSRS report in AX 2012 obviously makes a difference. You can conveniently attach tags with this information.
You mentioned the fetch() method, therefore it seems it’s a MorphX report in AX 2009 or older, but you should say it explicitly.
Can you please explain what you mean by “I create method to display string” (why did you write it, what it does, how it’s related to the problem), what control do you use to display data, what you do in fetch() and so on.
Also note that I moved your question to the developer forum, because it’s about development. The technical forum is for things like installations.
Hi Martin, sorry I’m new to Dynamics AX and forum. Oke next time I fulfill my question compeletely.
What I mean ‘method to display string’ is like this one:
display str configname()
{
return strfmt (’/ %1’, configname);
}
It is to create string in report that call selected lines from form. and when I print the report, i get this result:
this is what I mean ‘header repeat for each lines’. Thanks.
Please, would you mind to tell us what version of AX you’re talking about? I still don’t see it.
So what’s the purpose of the method? Why don’t use simply use the field directly?
I use Dynamics AX 2012 R3.
the method function is to display the selected lines from form to report.
Sorry because I’m really a beginner in Dynamics AX I dont know what you mean ‘simply use the field directly’, because so far I learn this way to call data from form to report.
What fetch() method are you talking about then? MorphX reports are not supported in AX 2012 anymore and SSRS reports have no fecth() method by default.
If you’re a beginner, ensure yourself that you work closely with AX documentation. It will tell you all the basic things such as how to add a field to a report. Development Tasks for Reporting [AX 2012] on MSDN will be a good starting point.
