Search results for query: *

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...

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.

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 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...

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 an unusual problem. I just installed visual studio .Net. No when I try to create a new report and add a second table I get an error the an instruction that refernces a memory address could not be read. My co-worker also just installed visual studio .net and get the same error message...

I want to code an SP that will have a parameter which allows the user to determine the column the data is sorted by. I tried passing a varchar parameter and using this statement Order by @SortOrder and I get error 1008. "The select item identified by the order by Number 1 contains a...

Has anyone seen the new SQL Server Report Designer? It is in Beta now and is supposed to be released next year for SQL Server 2000 and be packaged with Yukon. We are currently using Crystal REports and Enterprise but this looks like it could replace both. I am just wondering if anyone has...

I am wondering if anyone knows a way to update published reports without deleting and then republishing them. We add divisions on a regular basis in my company and I am getting tired of deleting and republishing thse reports every month. I attended the CDUGNA conference in 2002 and there was a...

When runing my daily reports in Seagate info I get exchange error 80040111 and they do not post to the public folders. I cannot find any documentation on this error on microsoft or Crystals websites. The entire report appears to run it just won't export to the Public Folder.

I have installed analysis server in an attempt to learn cube building. When I try to view a cube it tells me unable to open cube until it has be processed(Unspecified error). I then process the cube which appears to work then go to open the cube and get the same error. I am unable to get past...

I am running CR ver 9.0.2 on Win2k accessing SQL 2K through an ODBC connection. I have been struggling with this error ever since I upgraded to CR 9.0. At first it was intermittant and just this week became a full blown meltdown. This was only occurring on reports that used SP calls to...

I have a cross tab report that runs for a rolling 12 month period. right now I use a frmola that coverts order date to the first of the month and then uses that as a column heading. This give me the proper order for whatever period the report is run. I have had complaims that they want a more...

I am running into a problem with CR9 and CE9. I have several reports that combine vastly different types of data and to bring this data together I use stored procedures in SQL server 2000. These procedures ran perfectly while I was using CR8.5 and CE8.5 and now I get failed to open a rowset...

I need to pull some information out of a memo field. I need to take every thing after the string "Expired Info". Does anyone know how to find the position of a string in a memo field. I tried InStr and get 0.00 every time. Yes this is in CR 9.0 so it should be able to deal with...

I am using Facsys to fax a report in CR. I need to set up a blast fax so the report when sent to FacSys is parsed out into several groups and each froup is sent to it's own fax number. Is there a way this can be done?

I am running into difficulty exporting from CE 8.5 into excel. I get a lot of extra collumns that have the cells merged with the collumns with the data. I end up with roughly twice the number of collumns I need. this makes for more work for the user when they open the report in excel. They...

How do you set up reports to trigger alerts? I have found how to read the alerts but have found no way to set them up. Any help would be greatly appreciated.

We have a shipping program we purchased that uses CR to print customizable packing lists. I am trying to add a second page to the packing slip to show backordered items. The data for this second page uses a different DSN than the first page. I have created the second page in CR but do not...

I have a stored procedure that runs in SQL Server 7.0 the SP calculates a rank for sales based on month to date then compares this year to last year. The problem is when I call the stored procedure in CR to produce a report it does not order the table properly. The SP does order the tables...