How to link the No with No in the report

Navi_Learner

I've learned a lot from this forum. I have a question. We don't have the permission to write any trigger in the form. I want to print the report form directly from the form and tied the no in the form with the no in the report. My question is if I don't write a trigger, how can I enter the info in the form and then click the print button and all the information entered regarding the no is printed out. Otherwise I have to enter the no in the report. I want it exactly the same as we do the order and print the sales order form. Thanks in advance!

ROBO

make a button with the code
cont=record

Cont := Rec;
Cont.SETRECFILTER;
REPORT.RUN(REPORT::"report name",FALSE,FALSE,Cont);

Navi_Learner

I can't write any code since I have no liscence. Any way to make it work?

Savatage

FYI

I believe if you created the form, table or report you can access the code [Ranges 50000 to 50099 for example]. It's when accessing the standard navision tables & add-on's that you can't.

Savatage

So you want to pass a variable to a report or just run a report from a form without having to leave. You can do that.

Create A command Button
Change the PushAction property to RunObject
Change the RunObject property to Report "My Report"

??? Please clarify - thanks.

ara3n

He wants to automaticaly filter on the record that he is on the form. Letsay, if he is on item card, and when he clicks on print this item button, he wants the report to filter on that item, which cannot be done without coding.

Navi_Learner

No even for the 5000 range, we can't do anything. Do we have to talk to our consultant?

Savatage

Savatage wrote:

FYI

I believe if you created the form, table or report you can access the code [Ranges 50000 to 50099 for example]. It's when accessing the standard navision tables & add-on's that you can't.

You Are Correct, I tested it and form & table you cannot access code. Report & dataport you can.

Navi_Learner

I know I need to create A command Button and
change the PushAction property to RunObject and report name etc. My question is when I run the report, this report is exactly the one I enter in the form without entering any Item No before run the report. If writing the code in the Cal Code Editor is the only way, I will give it up. I don't know why we have to pay the licence for the code in the form. We've paid a lot when we set up all the system.

ara3n

I know it sucks, you have to pay another 8 K to get the next level of development granuale to access table, codeunit, and form level codes.

themave

ara3n wrote:

I know it sucks, you have to pay another 8 K to get the next level of development granuale to access table, codeunit, and form level codes.

He is right, no way around it. and it does suck. For 8k, we make our users enter the number manually, we do this same thing on several forms and once they are used to it, it is easy. I have them do a right click, copy on the no field and then press the buttom and paste the number. they are so used it is seems automatic to them. and it didn't cost 8k to do.

good luck.

I cheaper solution, is to design it just how you want it, and ask your solution center to code that last part, should not cost much.