Hello all,
I want to set a default parameter for the Membership Renewal Notices report. I've tried various methods in Report Setup specifying a default value, order by, where , etc. but no matter what it always displays the Sort By parameter as "Level/Country/Postal Code." The Custom Reports doc says this:
Default Value: Enter a default value for the parameter. Any value can be used, but if a dropdown is used, the default value should be a valid value from the data column. After a user has run a report once, the default values will be the values that the report was last run with. The value entered here will only be used if a particular user has not run a report previously or clears the stored parameters.
It is not behavior in a "sticky" manner. If I select Alpha, run the report, come back to the report it still says "Level/Country?Postal Code." The above paragraph points to clearing the stored parameters but there isn't a Clear button on this report.
Anyone have any ideas? I tried changing the customer_no format from number to long as this was from another post with the similar issue. That didn't work either.
This is a standard report/utility that does not use the default parameters window. This means that editing report setup for this report is not actually supported, but moreover it is not very likely that you will get that special parameters window to follow the rules you're defining in Report Setup.
Since there is no clear button, the only people the default value would ever be able to populate for would be those that have never run the report before. Theoretically, what you would enter in the sort by column would be one of the description field choices from TR_GOOESOFT_DROPDOWN WHERE code = 64, since description is indicated as the data column in report setup.
What might be possible would be for you to define your own "report" in report setup, one that copies the same parameters and references the same datawindow, but uses the default parameter window. This could technically work as long as the special renewal parameter window is only being used for GUI ease of use -- if the special parameter window is necessary because only it is capable of generating the proper parameter values for this report, then this won't be successful.