Add Parameters to a Macro

%3CLINGO-SUB%20id%3D%22lingo-sub-2964016%22%20slang%3D%22en-US%22%3EAdd%20Parameters%20to%20a%20Macro%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2964016%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20have%20a%20macro%26nbsp%3B%3C%2FP%3E%3CP%3EI%20didnt%20design%20it%3C%2FP%3E%3CP%3EI%20run%20the%20parameters%20On%20Open%20of%20a%20report.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20modify%20(add%20another%20parameter)%20it%20but%20I%20dont%20understand%20parameters%20too%20much.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20are%203%20rows%20and%20I%20want%20to%20add%20another.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20rt%20clicked%20and%20searched%20all%20over%20and%20cant%20find%20how%20I%20do%20this.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20is%20a%20hyperlink%20%22update%20parameters%22%20but%20that%20doesnt%20do%20anything%20other%20than%20hide%20all%20of%20the%20parameters.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGrateful%20for%20the%20help.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Tony2021_0-1636930954372.jpeg%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F326985iC21C8E20640B5824%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Tony2021_0-1636930954372.jpeg%22%20alt%3D%22Tony2021_0-1636930954372.jpeg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2964016%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eaccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2970941%22%20slang%3D%22en-US%22%3ERe%3A%20Add%20Parameters%20to%20a%20Macro%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2970941%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1029845%22%20target%3D%22_blank%22%3E%40Tony2021%3C%2FA%3E%26nbsp%3BThis%20is%20hard%20to%20explain%20via%20this%20environment%2C%20so%20use%20your%20imagination%20a%20bit%20in%20looking%20for%20answers.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EApparently%20there%20is%20another%20macro%20involved.%20That%20macro%20is%20associated%20with%20the%20report%20and%20that%20is%20where%20the%20parameters%20should%20be%20defined.%20Look%20in%20the%20report%20and%20see%20what%20you%20can%20find.%20If%20you%20find%20such%20a%20macro%2C%20show%20it%20here%20and%20we'll%20see%20if%20we%20can%20pursue%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2976554%22%20slang%3D%22en-US%22%3ERe%3A%20Add%20Parameters%20to%20a%20Macro%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2976554%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F126074%22%20target%3D%22_blank%22%3E%40George%20Hepworth%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGeorge%2C%3CBR%20%2F%3EI%20see%20one%20saved%20macro%20and%20within%20the%20report%20are%20the%20parameters.%3CBR%20%2F%3EI%20see%20I%20can%20add%20an%20action%20but%20there%20are%20many%20options.%3C%2FP%3E%3CP%3EDo%20you%20know%20which%20action%20it%20would%20be%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Tony2021_0-1637172174673.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F327690i190705F3A55EBEF8%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Tony2021_0-1637172174673.png%22%20alt%3D%22Tony2021_0-1637172174673.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Frequent Contributor

Hello,

I have a macro 

I didnt design it

I run the parameters On Open of a report. 

I need to modify (add another parameter) it but I dont understand parameters too much. 

 

There are 3 rows and I want to add another. 

I have rt clicked and searched all over and cant find how I do this.  

There is a hyperlink "update parameters" but that doesnt do anything other than hide all of the parameters. 

 

Grateful for the help. 

 

Tony2021_0-1636930954372.jpeg

 

5 Replies

@Tony2021 This is hard to explain via this environment, so use your imagination a bit in looking for answers.

 

Apparently there is another macro involved. That macro is associated with the report and that is where the parameters should be defined. Look in the report and see what you can find. If you find such a macro, show it here and we'll see if we can pursue it.

 

 

 

@George Hepworth 

George,
I see one saved macro and within the report are the parameters.
I see I can add an action but there are many options.

Do you know which action it would be?

Tony2021_0-1637172174673.png

 

@Tony2021 

I had to review macros. I almost never use them and it had been a long time since I did.

Open the query that provides records to the report. It should have three parameters already, the ones shown in your screenshot. Add the fourth there. Now, when you edit the macro and click on the "update parameters" link, it should add the fourth parameter. 

Hopefully that'll do it.

Hello George,

yes, I have the query open as in screen shot above.
I have to add an ACTION it appears.
I dont know which ACTION I would choose since there are so many.
I think I need to choose an action?


@Tony2021 

 

Quoting myself, 
"Open the query that provides records to the report. It should have three parameters already, the ones shown in your screenshot. Add the fourth there."