Recent content by crystalempress

We use ProClarity as our front end to display our cubes and are in the process of upgrading from 6.2 to 6.3. In this process we are also putting Analysis Services on a New Server which has SQL 2005. Our current Live Server has SQL 2005 with SP1. Our New Server has SQL 2005 with SP2...

I can get it this far where I don't error out? with MEMBER [MEASURES].[monthdiff] AS 'DateDiff ("m", [Written Date].[Fiscal].[Day], now())' select [MEASURES].[monthdiff] on columns, [Written Date].[Fiscal].[Day] on rows from sales but for each row I get back 24079

Does anyone know how to create a calculated member in a cube trying to find the datedifference between a specific date and the current date? Using sql2005

The Report Server Config is correctly setup. No report works. I've even created new reports from scratch and tried it with no success. After tinkering with just about everything I am now getting this error: Server Error in '/Reports' Application...

Running Reporting Serives on Sql 2005, Windows Server 2003. Just got Reporting Services up and runnning. Now when I run one of the reports I get the error: Server Error in '/Reports' Application. This report is based on a stored procedure. Has worked in the past, but not since we switch to...

We used to have reporting Services set up and when they installed it on to another server it has not worked since - old server or new server (well it half works. The following is what I see when I type in the //server/reportserver: ********************************************************...

Trying to create a crystal report in Visual Studio 2005 to be used in an application. Need to create a subreport in the report to group differently and sum up the values. When create the subreport using the same dataset and run it, it does not show any data. using Sql Server 2005 stored...

We are using Crystal 10 and just finished converting our Crystal Server to Windows Server 2003. Also in the process of converting all client machines to Office 2003. With Office 2003, we have noticed that when you export directly to Excel (within schedule mode on eportfolio) we are now...

Thanks Ibass! Never thought to put it in the group header above it. Didn't think that would work since the group I was working with was Group 4. I even tried creating a subgroup of 4 (4a) but that didn't work, that would be how I've done it before in the details which always worked for me...

I have a report that has 7 sections printed on it. I have each sections information on it's own detail section. I don't want to see the detail but the summed up form of it at the group level. The report is working fine and doing everything that I want it to do with all the suppress fomulas...

I am using Interbase Client (SQL) to access my data. The data is Entered in a Client base front end as a free form text. This information is then stored as a Blob on the TRAMS.GDB on the backend. I need to get these comments out of the Blob field and send the information along with other...

I have a Blob field that I need to get the information out of. The front end is a freeform text area for agents to type in remarks. I need those remarks, How do I extract them from this blob field?

Thanks donutman & esquared, that is exactly what we were looking for!

How do I extract only characters from a string which has both numeric and alphanumeric characters using SQL 8.0? ex. 'abc192k122r' to get 'abckr'

We are using CE8.5 and 75% of our reports are exported to EXCEL. There are 2 dll's out there crxf_xls.dll and u2fxls.dll. If we use the crxf_xls.dll then our 99% of our reports won't export correctly, they export into excel in Merged Cells. Everything looks good when you see it but when you...