Method Community

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"

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

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 ...

OK, I have a question about using 2 cells as the parameters for a SQL Statement. This code is not working because it is not recognizing STARTDATE and ENDDATE as parameters:       Dim STARTDATE As Date     Dim ENDDATE As Date     STARTDATE = Range("B1").Value     ENDDATE ...

I was wondering if there was an easy way to calculate the difference between 2 date fields without having to export it into excel and do it there. Thanks in advance -Josh

Paul, That makes total sense and I apoligize for assuming that the Filter Safeguard was the culprit.  I will see if the customer wants me to use the conditional statement method instead since its a more reliable way to pull the data. Thanks again for all your help.  You opened my eyes to some new ways of accomplishing my projects. Is ...

Paul, That did the trick.  However I found out that with the Method Update there is a new field called filter safeguard which I think was the culprit.  If I set it to "generate always" and change my filtering to "contains" and the value, it worked perfectly for me. Leaving it as "equal to" did not ...

Paul, I think that is exactly what I was looking for.  I will give it a try today and let you know how it works out. Thanks!

First I "Retrieve Value From Screen" and assign it a Name.  Then in the generate report action: 1) Call the report (CallReport is the name of the report) 2) Filter Report; Table in Report is Correct (CallReport).  Fields in Table is "Facility". Condition Statement is "Equal to". From "action ...

I have a question regarding a report that was running based off the value of a drop-down.  Previously the report would pull all records if the value of the drop-down was left untouched.  Now it only pulls records with a blank value for that field.  If you select a value, it returns the correct results. But I can no longer return ALL ...