Search results for query: *

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

Thanks, This is my first foray into OLAP reporting and development. There is quite a bit more to it than reporting using a straight relational DB. A lot more options for how to get things done.

I am fairly new and self taught in AS. I have a design question about member properties and cube size. My company has 8,000 products and sometimes the Alias and description don't quite get it done for what the product actually is. I was thinking about adding a picture to the member properties...

I had this problem and had to manually start the Service Pack 3 instalation. Everything appears to work but the cubes won't process. I went in to the files SP3 unzipped into and executed from there to get it to work. Unzipping and running the install from the script did not work for some reason.

We have a shipping application that uses CR 8.5 to print a packing slip. We are having an itermittent problem where the packing slips take up to 30 seconds to print. This is unacceptable. If I run the SP that pulls the data in Query Analyzer it pulls the data in less that a second. What...

I have been working with RS since the product launch. We used to use CR for report design and CE for distribution over our intranet. I do agree that CR is easier to use. The formula editor is at least 100 times better than the expression builder in RS. Some one with a little DB knowledge can...