Recent content by rmarcus

Thanks Combo and SkipVought for your help. Ungrouping has done the job. Cheers, Ralph

I am summarizing by document and want the date (ddmmyyyy)for each document. In my data table there is a column with the date. I do not have a column with the quarter and year. The pivot is creating this. Regards Ralph

I have a file which has a date (dd/mm/yyyy)against a document reference. When I create a pivot table with the document number and date column it automatically adds "Quarter" and "Year" although the data table does not have columns headed "Quarter" and "Year". The pivot table shows the column...

In some cases a user (Outlook 2010) sending a meeting request finds that the recipient only receives the request as an e mail with only the subject showing. No meeting details or accept buttons appear. This generally happens when the request is sent to a German address. When sending to a...

The Enterprise edition includes content scanning for spam but with Exchange 5.5 the gateway will only look at the subject line and not into the body of the e mail. Has anyone found a work around to scan the body for spam ? Regards Ralph

Thanks for you help and prompt responses. My problem is solved !!

Sorry, here is the formula .. If ({crItemTRX.UOFM} = "BOX OF 2") then {crItemTRX.QTY}*2 else If ({crItemTRX.UOFM} = "BOX OF 5") then {crItemTRX.QTY}*5 else If ({crItemTRX.UOFM} = "BOX OF 3") then {crItemTRX.QTY}*3 else If ({crItemTRX.UOFM} = "BX OF 10")...

I have a formula which has a number of If then conditions. If a particular condition exist, I want the report to print a blank space. Can I do this in V7 ? I have tried using "" but it says a number is required. Thanks Ralph

Check your ISP POP3 detail is correct in your Outlook. If the ISP upgraded they may have changed their POP3 name.

I finally sent Crystal a message and they e-mailed me an updated viewer which fixed the problem. Regards Ralph

I have a pivot table which sums the QTY and VALUE in the data field. Is there any way I can get it to show the sum in columns instead of two rows ? Ralph

You should be able to seperate the names by using the 'Text to Column' option under the Data menu. Ralph

I am using CR7 and have a table which details sales info by Doc ref. Each record shows Stock No, units sold, sales value and cost value. Is there a way I can sumarize to show in one line the Stock No, Units Sold, Sales Value and Cost Value for Month to Date and Year to Date without having to...

We use Seagate Crystal Smart Viewer with IE5 to view and print reports. The page setup is set for A4. Any ideas ? Ralph

Any report in Landscape prints a blank page after every printed page. (HP Laserjets) If I set it to Portrait, it prints two pages with print only. I have tried changing margins with no success. The same report printed from C7 report designer prints correctly. When printing to a Lexmark it prints...