Open Report on the basis of selected record

Finance and Operations/AX Developer Forum
1

Hi All,

Can any1 help me to find the solution for this:

I have a form in which there is a report menuitem button and when I press this button to open report then what i want report should contain data regarding only selected record in form.

Regards,

Ankit…!

2

hi,

Hope this helps you.

http://parimalajyothijp.blogspot.in/2012/01/if-report-attached-to-form-how-can.html

3

Hi Jyothi,

Thanks for reply…!

I follow same steps, but sitll it is not working…!

do i need to write some more methods, in report or form.

4

Hi Ankit_M ,

In u hav to assigned ur table like this right

tableObj = element.args().record();

After that u have to send ur database in fetch method like

select datasourcetablename (Copy as it is from ur report datasource node) where datasourcetablename .Primaryfield == tableObj .PrimaryField;

{

element.send(datasourcetablename);

}

5

Hi Ankit_M ,

U hav assigned ur form’s table like this right

tableObj = element.args().record();

After that u have to send ur database in fetch method like

select datasourcetablename (Copy as it is from ur report datasource node) where datasourcetablename .Primaryfield == tableObj .PrimaryField;

{

element.send(datasourcetablename);

}

6

Hi Jyothi,

Thanks, I know you are tring so hard to explain me, but still I am so far…

Can you please explain me step by step from starting…

will be thankfull…!

7

All methods are present in the Override Methods of the Report!!

Hi,

public class ReportRun extends ObjectRun
{
Common cur; //Common is the name of table
}

public boolean fetch()
{
QueryBuildDataSource qbs;
QueryRun qr;

qr = new QueryRun(element);

cur = element.args().record();
element.send(cur);

return true;

}

8

hi guys, i am a newer here and hope to have a good time in the near future… karla

collateral loans

9

Hi to all,

I am also have a same doubt in SSRS Report.

Please help me.

Thanks in Advance