Search results for query: *

Hi, Using Crystal X Report is grouped 3 levels I have a subreport in the details section that passes a variable to the main report. In group 3, I have a formula that calls this variable. When I show the details - the value in group 3 is correct. When I hide or surpress, the value is 0 Why?

I'm trying to create a start and end date so that I can have a better idea of history. When I run this query: SELECT [Item Number], [Item Date], [% OFF MARKED PRICE] FROM item master file history] where [item number] like '86%9355' And [% off marked price] is not null order by...

Can anyone tell me the benefits of using a stored proc vs a table vs a view. What are the benefits of using one over the other and what are the drawbacks of using one over the other?

When the fact table has a primary key on 4 columns would this slow processing down? What is the most 'efficient' object type to process from ie table or view? I have a cube that comes from a partitioned view and it processes in approx 30 minutes with 42 million rows of sales data. When I...

I've looked and looked....How do I create a calculated member of % change based on any dimension? I have a sales cube that has the following dimensions: Product Quarter Period Year Location The measure is 'Sales'. I would like to apply the % change to any of the above dimensions based on any...

We currently use Crystal Enterprise 10. All of our reporting is hooked to Microsoft SQL server. Everything runs fine with the exception of users logging onto Crystal and running reports before overnight jobs are finished (we span a couple of time zones) Any suggestions on how to block user...

I have an excel file, where I query several tables, and have macros set up that automagically refresh these queries. I'm using Office XP - the machine that I want these queries to work on is Office 2003. I've created the DSN, and when I create the query (workbook) off of the 2003 machine, the...

I have a report that requires a user input parameter of an exchange rate. The subreport needs to use this exchange Rate. Is there any way to push a user input parameter to a subreport? Any suggestions would be welcome.

I have page headers that are made with date formulas. There are 3 groups, and the formulas are 'accumulated' in the details section. Problem is that the page headers only appear correctly on the second page of a 2 page report. The only header that works on the first page is the one for the...

Here was my origional post: We have an SQL 2000 Server. We run a job everynight at 2:00 AM. On Monday, Wednesday, Friday and Sunday 2 steps start at 2:10, and finish in approximatly 1 hour. On Tuesday, Thursday and Saturday these 2 steps take 3 hours to finish. We don't know why. There are...

Here's the situation: We have an SQL 2000 Server. We run a job everynight at 2:00 AM. On Monday, Wednesday, Friday and Sunday 2 steps start at 2:10, and finish in approximatly 1 hour. On Tuesday, Thursday and Saturday these 2 steps take 3 hours to finish. We don't know why. There are no...

Might be a simple solution, but I haven't found it yet.......when using a DTS package to copy a view from one server to another, the view will only copy to a table. Is it possible to copy a view to another view, or do I have to run the view scripts individually? Any help would be appreciated!

Does anyone know what this error message means? Our database keeps kicking into Suspect mode with severity 21. We use SQL Server 2000, running on Windows 2000. The error message that appears is 'Operating system error 997 (Overlapped I/O operation is in progress.) on device...