Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
davidagnew37
Starting Member
33 Posts |
 Posted - 2004-08-20 : 05:40:14
|
| I am having a lot of problems with selecting date ranges for my cubes 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. I think this may contribute to the problem? The OLAP Crystal reports wizard allows you to create parameters in setting up the cube to be displayed in Crystal and works fine BUT does not only allow you to select more than one date - whether that be a specific Day, Month, Quarter or Year. In the Cube the Date is split into a hierarchy: - ALL- Year - Quarter- Month- DayIf I create a parameter with Month (not "long" type) it specifies the Year|Qtr|Month. and 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. |
|
|
|
|
|
Cubes in Crystal rpts - Prob with Date Parameters