davidagnew37
Technical User
I am having a lot of problems with selecting date ranges (or event just two dates) for my cube in Crystal reports (v.9) using date parameters.
I have a Date column (data type as datetime) in my orginal database table. When this data is drawn into the cube - the data type of the Date column/dimension is converted into a string. (which may contribute to the problem?)
The OLAP Crystal reports wizard allows me to create the parameters I want for the cube in Crystal. These parameters which I have set up in the Wizard work fine BUT do not allow me to select/allow "Multiple Values" ....i.e.more than one date - whether that be a specific Day, Month, Quarter or Year. (as in the Cube the Date is split into a hierarchy:
- ALL
- Year
- Quarter
- Month
- Day)
Ideally I would like to select a range of dates from two parameters, but to get multple dates would be just a as good for the time being - which I still cant get to work.
If I create a parameter with Month (not "long" type) it specifies the Year|Qtr|Month. and when I select this from the parameters it brings the correct data into the cube. BUT cant select two months for example.
I know after you have exited the wizard you can go into the "select expert" or "select formulas" and then edit the formulas to select multiple values .......BUT even after selecting multiple months for example - the cube only returns the figures for one of the months I selected.
any ideas would be most welcome.
I have a Date column (data type as datetime) in my orginal database table. When this data is drawn into the cube - the data type of the Date column/dimension is converted into a string. (which may contribute to the problem?)
The OLAP Crystal reports wizard allows me to create the parameters I want for the cube in Crystal. These parameters which I have set up in the Wizard work fine BUT do not allow me to select/allow "Multiple Values" ....i.e.more than one date - whether that be a specific Day, Month, Quarter or Year. (as in the Cube the Date is split into a hierarchy:
- ALL
- Year
- Quarter
- Month
- Day)
Ideally I would like to select a range of dates from two parameters, but to get multple dates would be just a as good for the time being - which I still cant get to work.
If I create a parameter with Month (not "long" type) it specifies the Year|Qtr|Month. and when I select this from the parameters it brings the correct data into the cube. BUT cant select two months for example.
I know after you have exited the wizard you can go into the "select expert" or "select formulas" and then edit the formulas to select multiple values .......BUT even after selecting multiple months for example - the cube only returns the figures for one of the months I selected.
any ideas would be most welcome.
