Selection Criteria of Reports

rajinivmrajinivm Member Posts: 42
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

  • garakgarak 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!
  • rajinivmrajinivm 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.
  • rajinivmrajinivm Member Posts: 42
    Please suggest if we do the CONTROL+F1
  • rajinivmrajinivm Member Posts: 42
    Please suggest if we do the CONTROL+F1
  • garakgarak 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!
  • rajinivmrajinivm Member Posts: 42
    Thanks for your helps. Its working fine.

    Regards,
    Rajini
  • garakgarak Member Posts: 3,263
    no problem and welcome
    Do you make it right, it works too!
Sign In or Register to comment.