Selection Criteria of Reports

rajinivm

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

garak

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

rajinivm

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

Please suggest if we do the CONTROL+F1

rajinivm

Please suggest if we do the CONTROL+F1

garak

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

rajinivm

Thanks for your helps. Its working fine.

Regards,
Rajini

garak

no problem and welcome