Selection Criteria of Reports

rajinivm
rajinivm Member Posts: 42
edited 2009-06-30 in NAV/Navision Classic Client
Dear All,

System will load the all the record from particular table into form list
It is looks like

Document Number Marked
P-DC/SC-09/000 Yes
P-DC/SC-09/001 No
P-DC/SC-09/002 Yes
P-DC/SC-09/003 Yes

User can select the record in form and click to print button. The report should be fired

How can we design the logic for printing this report in NAV?

In SQL, this is what I need

SELECT * FROM TABLE WHERE COLUMN1 IN ('P-DC/SC-09/000','P-DC/SC-09/002',P-DC/SC-09/003' )

Thanks,
Rajini

Comments

  • garak
    garak Member Posts: 3,263
    you wish to print only the marked recs?
    If yes how these recs are marked? Per Ctrl+F1, "Blue" or is there a field where a marked flag is set?

    Regards
    Do you make it right, it works too!
  • rajinivm
    rajinivm Member Posts: 42
    There will be a check box in each row, user can go and mark that line.
    after that, what ever records have been marked, it should be printed.
  • rajinivm
    rajinivm Member Posts: 42
    Please suggest if we do the CONTROL+F1
  • rajinivm
    rajinivm Member Posts: 42
    Please suggest if we do the CONTROL+F1
  • garak
    garak Member Posts: 3,263
    rajinivm wrote:
    There will be a check box in each row, user can go and mark that line.
    after that, what ever records have been marked, it should be printed.


    What is, if a other user opens the form and set his flags ;-) or are the datas temporary?
    How to use Ctrl+F1 (marked?)

    Behind your "Print" Button you do following:

    setrange(YourFlagField,true);
    REport.run(REportID,Rec);
    setrange(YourFlagField);

    with the Ctrl+F1 Option u need only the marked so:
    markedonly(true);
    Report.run(ReportId,Rec);
    markedonly(false);

    Also read the Application DEsigners Guide (search the forum and the downloadsection), to learn more about NAV programming.

    Regards
    Do you make it right, it works too!
  • rajinivm
    rajinivm Member Posts: 42
    Thanks for your helps. Its working fine.

    Regards,
    Rajini
  • garak
    garak Member Posts: 3,263
    no problem and welcome
    Do you make it right, it works too!

Categories