Running reports and parameters

poverocanepoverocane Member Posts: 32
edited 2004-10-18 in Navision Attain
Hi all and thanks in advance for your help...
I have a problem passing parameters and datas between a form and a report...
I have inserted this code:
...
REPORT.RUN([report no.],TRUE,FALSE,Rec);
...
in the Purchase Invoice form, in the OnPush event of a Command Button trigger.
Then i've created a report that has the Purchase Header table as the DataItem. Also the SourceTable property of the Purchase Invoice form is set to Purchase Header.
My problem is that, when i call the report, the report doesn't show the Document Type and the Number values in the initial window (Request Form window, it could be...)...

My question is: what is the problem?
Why form and report don't match datas?

I hope beign clear...

Thanks a lot..
poverocane
Fantasy is more important than knowledge.
A. Einstein

Comments

  • PolarPolar Member Posts: 32
    instead of
    ...
    REPORT.RUN([report no.],TRUE,FALSE,Rec);
    ...

    try to do this

    //PurchHeader record Purchase Header
    ...
    PurchHeader.SETRANGE("No.","No."); 
    REPORT.RUN([report no.],TRUE,FALSE,PurchHeader); 
    ... 
    

    read more about Rec and xRec , on form it can be an empty record.
    keep it simple
  • DraqosDraqos Member Posts: 36
    Polar wrote:
    instead of
    ...
    REPORT.RUN([report no.],TRUE,FALSE,Rec);
    ...

    try to do this

    //PurchHeader record Purchase Header
    ...
    PurchHeader.SETRANGE("No.","No."); 
    REPORT.RUN([report no.],TRUE,FALSE,PurchHeader); 
    ... 
    

    read more about Rec and xRec , on form it can be an empty record.

    When you run the report with
    REPORT.RUN(..,..,..,rec), the request forms shows all filters applied to Rec.
    As you don't have any filters set on Rec variable, it will not fill in the required filter fields.
    "Simplicity is the ultimate sophistication."
    Leonardo DaVinci
  • csimoneauxcsimoneaux Member Posts: 168
    Try to add a GET or FIND command after your SETRANGE.
Sign In or Register to comment.