Search results for query: *

Hi all - help please I built a report that prints customer invoices. It worked fine. Multiple pages per customer etc etc. Then the goalposts moved. The client wanted to have his terms and conditions printed onto the back of each page. There are no natural groupings that identify new page. A...

Hi all I am struggling here without manuals. I want to write a simple SQL statement like SELECT customerid, customertype, orderid, ordertotal, iif(customertype="A",.1,.2) as discountrate, ordertotal * discountrate as discounttotal FROM salesorder etc etc Thanks for your...

I added two different cross-tabs to the header. In CR9 there is an option called 'Relative Positions' in the Section Expert. This maintains the distance between the objects. This does what I think you want. The option doesn't exist in CR8

I added two different cross-tabs to the header. In CR9 there is an option called 'Relative Positions' in the Section Expert. This maintains the distance between the objects. This does what I think you want. The option doesn't exist in CR8

Using a formula I calculated the working hours between two events. This takes into account working days and hours of work. I can post it here if people want (its quite a long formula) or you can contact me george.allard@crystal-technical-services.co.uk Cheers George Allard Crystal Reports...

I have a report with many sub-reports (these only start on page 3). The report is called from an application and behaves quite normally. You can load it, preview it and print it. However, the export is causing problems. From The ActiveX viewer (which is called by the application) I export the...

Hi I developed a report printing in A4 portrait. Run from Developer the report previews and prints correctly to a couple of printers. The same report using ActiveX will preview correctly (this is important) but when it prints it uses US Letter in portrait. The main symptom is that I get a...

Thanks Jason Not what I am after. This is difficult to explain: I had a successful installation of Outlook 2000 with messages. The messages were stored in D:\MAIL on my hard drive. I was forced to re-install Outlook. I can find no way of linking my original messages with my set up of Outlook...

Mark Thanks - you are quite right - I can import from Outlook into Express BUT I have no messages in Outlook. Once I re-installed Outlook I lost the 'attachment' to the messages on the disk. I can see the message files on the disk but I can't attach them to Outlook so I can't read them and I...

Help please I had Outlook installed and for about 12 months received and sent e-mail. I then had to reformat and re-install Outlook. How do I link all my existing mail messages to the new installation? I know where the files storing the messages are. Alternatively Can I import Outlook...

Hi You're not dense. I use the SQL editor to VIEW the SQL statement. I always build my selection through the Select Expert. This way I get the syntax correct, I have drop down menus, field lists etc I can't think of an occasion when I have needed to use the SQL editor to build a SQL statement...

Craig: I found the info thru the Seagate (now crystaldecisions) knowledgebase. There are only 4 files with a very clear readme.txt If you can't find it e-mail me and I will send you the files George George Allard Crystal Reports Consultant and Trainer georgea.cts@dial.pipex.com

I am trying to calculate business hours between two date/time fields. I downloaded the Seagate UFL cruflwdays.dll - this allowed the std computation. It even had provision for holidays. BUT - I have two sets of working hours in a week. Mon-Fri are 09:00 - 18:00 Sat is 10:00 - 13:00 The only...