thanks for your suggestion.
However as you can see, I specify a period. This would mean that I would have to manually create a variant each month. So this isn't the solution I was looking for.
I fear that what I'm going for isn't achievable via the report connector and I might have to write an ABAP program.
I think you can solve it by using the 'Select Options' button in the Report connector. I tried the following script and it worked:
CUSTOM CONNECT TO "Provider=QvSAPReportConnector.dll;ASHOST=99.88.777.66;SYSNR=06;CLIENT=800;XUserId=bZVNHUJOHLSB;XPassword=xxx;";
Load [Field0_] AS 'Field name',
[Field1_] AS 'Field cont.',
[Field2_] AS 'Description';
Select SAPREPORT (REPORT (RPCLSTB2), ROWS_PER_RECORD (1), FIELD_AUTO_COLUMNS (6),
(SELNAME LIST1, KIND P, SIGN I, OPTION EQ, LOW ),
(SELNAME LIST4, KIND P, SIGN I, OPTION EQ, LOW X),
(SELNAME SELCLTYP, KIND S, SIGN I, OPTION EQ, LOW 1),
(SELNAME SELPABRJ, KIND S, SIGN I, OPTION EQ, LOW $(zyear)),
(SELNAME SELPERIO, KIND S, SIGN I, OPTION EQ, LOW $(zperiod))
//Store * from [RPCLSTB2] into RPCLSTB2_OPTIONS.QVD;
//Drop Table [RPCLSTB2];
You have to calculate the variables in the script (like zperiod) you want to use, at each execution time.