Method:Classic General Q&A

Re: Use Parameters with a report

Method_Adam — Wed, 31 Jul 2013 21:07:28 GMT

Hi,

I believe Chad is referring to the "Update field in table" action. You'll want to use these actions to place a value in the fields before the generate report action, then clear them again afterwards.

- Adam

Re: Use Parameters with a report

kdellaripa — Wed, 31 Jul 2013 01:14:22 GMT

How did you assign values to these report parameters from within Method? Thanks!

Re: Use Parameters with a report

Anonymous — Tue, 19 Jun 2012 18:41:27 GMT

CDS_Josh:
"Back in Method just after the Generate Report action make sure clear the fields again"

In the same vein as updating the company table before you generate the report, you'll want to make sure you clear those values from the table after the report is generated. The last step is just housekeeping.

Re: Use Parameters with a report

CDS_Josh — Tue, 19 Jun 2012 18:14:06 GMT

Worked like a charm.

But can you explain the correct way to do this?

"Back in Method just after the Generate Report action make sure clear the fields again"

Re: Use Parameters with a report

CDS_Josh — Tue, 19 Jun 2012 17:56:24 GMT

Thanks Chad.. I think I understand what you mean. I will try it out and see if I am on the same page.

We are under the assumption that the end-user will not be able to "update the custom field created above in the company table" each time they want to run teh report.

But I will see if I can get it to work that way

Re: Use Parameters with a report

Anonymous — Tue, 19 Jun 2012 17:33:29 GMT

Here's a decent work around as you cannot pass parameters from the Generate Report action.

Open a Method report and you'll notice one common table regardless of your report... the Company table.

Add a custom field to the Company table to hold the parameters you want to pass to the report.
Just prior to generating the report, update the custom field created above in the company table
Use those fields in the report as needed
Back in Method just after the Generate Report action make sure clear the fields again

This should work out nicely for what you're trying to do.

Use Parameters with a report

CDS_Josh — Tue, 19 Jun 2012 16:08:51 GMT

I have a report that is using filtering within method. However, the customer wants these filters to be printed on the reports. So my only solution was to create 2 parameters within the report and have method assign values to these parameters based on some drop-down menus within method. The parameters are PARAM_StartDate and PARAM_EndDate. I have the reports formatted correctly, but when I try to set them up in method, I cannot assign the values to the parameters from the "Generate Report" options.

Can someone point me in the right direction?