Recent content by JohnEck

Thanks, The post got me thinking it was crashing on the second step and not the first. This was the case. I needed to install software to unzip the file. It works now.

I have a DTS package that FTPs a file then unizps and loads the data. When I execute it from the designer it works. When I try to schedule it it crashes. Here is the error Executed as user: condor\sqlservice. ...art: DTSStep_DTSFTPTask_1 DTSRun OnStart: DTSStep_DTSDynamicPropertiesTask_1...

Chelseateach does have good points about mulitselect and range parameters but he forgets fully dynamic parameters available is RS. I used CR for 3 years and every year I pepper Crystal with requests for fully dynamic parameters and the response was always that they had other priorities but it...

I didn't particularly like crystals OLAP tool. I thought it offered very little power or flexibility. I di find an add-in for excel cal XLCubed that is very useful if you are developing your cubes in AS. It is very low cost also. Some licenses as low as $150. That is a stripped down version...

I wrote the comparison piece on Ken Hammady's web site refenced in the thread mentioned above. Here is a little background. We used CR/CE for report development and distribution for over two years. I like CR and still use it occaisionally for a quick ad hoc report. If you are planning on...

I have been hoping for an RS forum here but no such luck Here is the link to the MS forum. I have gotten a lot of good info from there. http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?dg=microsoft.public.sqlserver.reportingsvcs There is no date picker. Maybe...

Trying setting up the parameter in RS to allow nulls. If you do that and set the label to all and value to null then you can select all and it will not filter on that field.

If you are running SQL Server I highly reccomend converting to Reporting Services. It could save you a ton on maintenance costs. While I didn't have 250 reports to cenvert it was well over one hundred and had a fairly easy time converting reports. If you are dealing with a changing...

A quick and dirty solution is another table in this form Debit Factor Y 1 N -1 Join this to the transaction table by the Debit field and multiply the factor by the Transaction Amount.

I am working on joining cubes. When I attempt it tells me I need Enterprise Edition of Analysis service. I know the Server is running SQL Server 2000 Enterprise Edition but apparently not AS Enterprise Edition. Does anyone know of a way to fix this.

Thanks it sounds like what i am doing is just about the best I can use.

cjlarue I did a big conversion. We had close to 200 reports in CR distributed over CE. Because of the cost of CE licensing we had a nightmare with people sharing named licenses. This caused all kinds of problems. We switched over to RS about 3 weeks after the release of RS. It took a...

I am trying to build a fiscal time dimension for my cube right now what I use is a standard dimension linked to the date filed that gives me columns for year, quarter, month, week. I would like to set this up as a time dimension to take advantage of MDX functions available for time dimensions...

I believe that when AS sets up a shifted time dimention the year is determined by the end of the fiscal year. If your fiscal year start in Feb isn't that fiscal year 2005?

This is a Service Pack issue. You need to install SQL Server SP3