Hi. I'm trying to do something similar in SIMS with commandreporter. I'm trying to return Behaviour data for the current date, whatever date the report is run on so that running it today will return behaviour data from today's date, running the same report tomorrow will return behaviour data from tomorrow's date. I've got as far as getting the list of parameters using /PARAMDEF, similar to your list at the top of this thread, but my Parameter id seems different. Pasting from my paramdef file, I get:
whereas you seem to be getting a unique identifier for each parameter:
I've looked around many commandreporter threads and I've never seen a Parameter id called EffectiveDate, they've all been what look like proper IDs, which I'm not getting and, as someone mentioned elsewhere here, "the Parameter ID value changes when the report is imported in to a different database, so that needs to be reflected in your scripts if you share them with anybody else, otherwise the filter is ignored and the report ran as though you ticked the "Accept All" option."
I think this is what is happening to me but I'm not being given the ID.
