Recent content by ema15

I have Crystal Analysis report published on the web with Crystal Enterprise. I can see the report on the web but if I am just trying to scroll the bar down to see the rest of the page the report gets refreshed. Does anybody knows how I can avoid refreshing the report?

I am building a cube using MS Analysis Services from MS SQL Server. I have a table with fields: SalesmanID, CustomerID, ProductID, DeliveryDate and SalesQuantity. And I am using this table directly as a fact table. My question is how I can create Time dimension? Can I just create a view from the...

Found the problem. I installed the MS Analysis Server after installing MS Office XP which overwrited some dll's. I installed Service Pack 1 for SQL Server 2000 from microsoft site and it fixed the problem.

Hi guys! I just started building OLAP cubes and not sure if I am doing right. I have a table in MS SQL Server 2000 containing SalesmanID, CustomerID, ProductID and DeliveryDate by day. I need to creat a cube with dimensions:[Salesman],[Customer],[Product],[DeliveryDate] and SalesQuantity as a...

Hi Terry, I used exact same formula and it did work, you saved my day!!! :) Thank YOU VERY MUCH!!!

Hello, I am trying to create a view in MS SQL Server 2000 with "DeliveryDate" field which data type is an Integer Float in this format: "YYYYMMDD". Does anyone know how I can Convert this field to a Date data type?

I am using Crystal Analysis 8 Pro. Created cubes with Analysis Services. When I am trying to create new app on "Crystal OLAP Connection Browser" I can see the servername but when I try to load the cubes I got an error message : "MyServer:ParseDisplayName failed". Have anybody...

I am building cubes using Microsoft Analysis Services and can process the cube but not able to retrive cube's data. I am getting error message:"Unable to display the cube untill it has been processed (Unspecified error)". But it did proccessed sucesfully. I have SQL Server 2000 and...

I am using Crystal Analysis as a reporting tool and Microsoft Analysis services to create OLAP cubes. Is there a way of distributing the crystal analysis reports with cubes to customers without them purchasing MS SQL Server? Do they have to have MS SQL Server if they just want to use my cubes to...

Hi Scott, first create a formula using Crystal additional function: StringToCode39 ({File.BarCodeField}) and change the font to Code39-Digits. A special font as well as Crystal add-on is required for printing Code39 Bar Codes. This has to be purchased from Azalea software. Crystal includes a...

Hi All, Is there a way of creating groups if the data kept in multiple fields: For the Code1 - Field1, Field2, Field3...Field200 Code2 - Field1, Field2,..........Field200 I need to group by the value in Field1,Field2,Field3..Field200. I'll appreciate any help...