Page New Report Added

Lamba · 2012-02-03

Hi Experts,

I have 2009 R2 installed on my system, I have created a new report(In 50000 series).
That runs via Posted Sales invoices in Rtc, i have added that report in the page action.
So when i Run Posted Sales invoices Page i can see the name of the report in the actions.

The issue is that when i Run the Report for a particular No. it is not updated in the request form
(The Report is not created in Rtc, so it opens request form).

](*,)

mohana_cse06 · 2012-02-03

You mean the Posted Sales Invocie No is not showing in request form?

How did you call the report?

Did you check the base report how it is called?

Lamba · 2012-02-03

Hi Mohana,

I have cross checked the code written behind one of the action is:

SalesInvHeader.RESET;
SalesInvHeader.SETRANGE("No.","No.");
REPORT.RUNMODAL(50063,TRUE,TRUE,SalesInvHeader);

i used the same code with the report id i require.
i restarted the finsql,Still no output.

deV.ch · 2012-02-03

Have you tried using RUN instead of RUNMODAL? Runmodal does not work for classic reports called from RTC, so the runmodal should be treated as a normal run, but maybe this logic messes something up with the record you apply.

mohana_cse06 · 2012-02-03

Lamba wrote:

Hi Mohana,

I have cross checked the code written behind one of the action is:

SalesInvHeader.RESET;
SalesInvHeader.SETRANGE("No.","No.");
REPORT.RUNMODAL(50063,TRUE,TRUE,SalesInvHeader);

i used the same code with the report id i require.
i restarted the finsql,Still no output.

Code looks ok
but what do you mean by no output?

What exactly is your question?

not able to see output or not able to see No. in Report filter?

Lamba · 2012-02-03

Mohana

I am not able to see no. in Report filter.

Lamba · 2012-02-03

Dev,

I have tried Run in Place of Runmodal..
Still i can't see the No. in report filter

Lamba · 2012-02-03

Here is the exact view..

mohana_cse06 · 2012-02-03

Lamba wrote:

Mohana

I am not able to see no. in Report filter.

I am able to see No. field in Report filters with your code..

can you a screenshot?

Lamba · 2012-02-03

Mohana

the screenshot is added above.

I am saying the no. field is not getting updated, with the no., for which the Posted sales invoice is getting printed.

Actually i have created a report named Debit note, that prints when any No. from Posted sales Invoice is selected.
So as the no. is selected then from actions-> Print Debit note is selected. The print window gets open, which should contain
the no. which was selected previously.

mohana_cse06 · 2012-02-03

I am sure its working fine with base report..

So you have some problem with customized report..

how many dataitems you have in report and are you showing the first dataitem ReqFilterFields only (if you have multiple Sales Invoice Header dataitems)

Lamba · 2012-02-03

Mohana

PFA, i thing is that when we select any posted sales invoice no. and then for that no. the page opens.

On that page u can select the Actions-> Print->Print Invoice(Or any other option).

The no. gets automatically updated in it. ](*,)

mohana_cse06 · 2012-02-03

Even I created a new report (ttt) with Sales Invoice Header and ran

mihail_kolev · 2012-02-03

make sure that the RunObject property of the action is NOT set, otherwise your code will not be executed

mohana_cse06 · 2012-02-03

mihail_kolev wrote:

make sure that the RunObject property of the action is NOT set, otherwise your code will not be executed

ohh..yes

I can replicate the issue now #-o

Lamba · 2012-02-03

Ya got it...

To make the code work the Runobject must be Blank.

The exact code is this:

SalesInvHeader.RESET;
SalesInvHeader.SETRANGE("No.","No.");
REPORT.RUNMODAL(Reprot ID,TRUE,TRUE,SalesInvHeader);

Heartly Thanks for your time

Howdy, Stranger!

Quick Links

Categories

Page New Report Added

Answers