Skip to Content
0
Former Member
Jan 14, 2011 at 04:43 PM

Unable to span years in entering dates

34 Views

Environment: Win XP SP3 / Crystal XI R2 SP6 / SAP Integration Kit SP1

I've created a query in Bex using the variable for date entry 0I_DAYS which has no problem entering from and to dates that are within 2010, or 2011, or even dates that go from December 2010 to January 2011.

However when I key the same dates into my Crystal report which uses the same query, only dates within 2010 or 2011 are accepted. Any date range that goes from one year to the next results in "The value is not valid" (such as 12/01/2010 to 01/14/2011).

I even created another in case the problem was with the SAP supplied variable, but it reacts the same way.

Is this a bug in the integration kit? Is there a fix in a later SP?

EDIT: It let me put in the dates as 01/14/2011 to 12/01/2010 creating the following (see DAT_RANG):

SELECT {[Measures].[4JBPXWFSNWU5J920AUX6RVT6C], [Measures].[4JBPXWV5PU1KKI4WMJ1VBZQLW]} ON COLUMNS, NON EMPTY CROSSJOIN(EXCEPT([ZSDFR_I02___F182].MEMBERS, {[ZSDFR_I02___F182].[All]}), CROSSJOIN(EXCEPT([ZSDFR_I02___F139].MEMBERS, {[ZSDFR_I02___F139].[All]}), CROSSJOIN(EXCEPT([ZSDFR_I02___F125].MEMBERS, {[ZSDFR_I02___F125].[All]}), CROSSJOIN(EXCEPT([ZSDFR_I02___F138].MEMBERS, {[ZSDFR_I02___F138].[All]}), CROSSJOIN(EXCEPT([ZSDFR_I02___F1].MEMBERS, {[ZSDFR_I02___F1].[All]}), CROSSJOIN(EXCEPT([ZSDFR_I02___F2].MEMBERS, {[ZSDFR_I02___F2].[All]}), EXCEPT([ZSDFR_I02___F50].MEMBERS, {[ZSDFR_I02___F50].[All]}))))))) DIMENSION PROPERTIES [ZSDFR_I02___F125].[2ZSDFR_I02___F125], [ZSDFR_I02___F125].[5ZSDFR_I02___F125], [ZSDFR_I02___F138].[2ZSDFR_I02___F138], [ZSDFR_I02___F139].[2ZSDFR_I02___F139], [ZSDFR_I02___F182].[2ZSDFR_I02___F182], [ZSDFR_I02___F1].[2ZSDFR_I02___F1], [ZSDFR_I02___F2].[2ZSDFR_I02___F2], [ZSDFR_I02___F50].[20COUNTRY] ON ROWS FROM [ZSDFR_M02/ZSD_ORDFILLRAT_I164981_BWERNER] SAP VARIABLES [0S_MAT] INCLUDING "536220", [DAT_RANG] INCLUDING "01/14/2011" : "12/01/2010"

Edited by: Bernard Werner on Jan 14, 2011 7:23 PM