Recent content by willpash

Hi MrDenny, Thank you for your comments, as I said I have been looking at the code over the weekend, and I thought I was going crazy!!! The problem is that I have inherited 12 stored procedures of this type, which all generate pivot tables of data for 11 subreports. This was one of the stored...

Hi All, I have inherited a stored procedure that forms the datasource for a linked subreport in MS Reporting Services 2005. I have spent the best part of the weekend optimising this to improve the execution speed. It currently is taking 195ms to execute the query of the subreport, with the...

How does one re-build the OLEDB objects in ACTDIAG? What does it do? Regards Will

Thank you Mike for your comments. However when I try the first method, via Excel, I am getting a CoCreateInstance (CLSID_IOleDbSecurityImp) Error message when I try to contect it to the Act database. What is the difference with regards to functionality between Crystal Reports and CrystalClear...

Hi groggle, I have read those pdfs and this still does not resolve the problem. Any ideas?

Hi All, I have been using ACT! 2008, for the last 6 weeks, and have struggled to create the necessary reports in ACT. I am quite proficient in Crystal Reports, but I cannot seem to get the connect right between the 2 products. I have tried both the OLEDB defining the SQL ACT 7 server, and the...

Hi All, I have just taken over an CE 9 ePortfolio Lite system run with reports using an Oracle 8 database. I am having the following problem when I am running the reports on ePortfolio Lite. When I click View report, it asks for the report parameters, and then it asks for the database userid...

Hi All, I am using Crystal Analysis 10 and I am trying to create a moving average formula with a periodicity of 12 months. CA10 does have a moving average calculated member, but it does it as a centred moving average, rather than the previous 12 months average. Anyone overcome this problem or...

We use a company based in Liverpool, but deliver majority of their training on site, throughout the UK. www.maximumimpactsolutions.co.uk

How does one make a custom outlook form the default form for the Contact Folder?

I am trying to move data contained within two access related tables into outlook. In Outlook is it possible to create a form, that shows all the phone calls, emails and appointments made with various members of a company in one form, instead of tracking all the various contact being made by an...

Mac Nice one, thanks a lot, I owe you one Will

Hi This must be real easy but.... I have a report which is a letter, I want to be able to view a record in a form and click the button I have inserted which runs the report and only run the report for the current record in the form. However it runs it for all 5000 records. Any help...

i am writing a simple purchase order report, but i don't want zeros displyed when there is no price put in. it's in 97 so there's no conditional formatting. any ideas please?