Search results for query: *

I have some 700+ results from a market research i'm trying to gather into a single Excel document. Theres some manual input/tasks required for each so theres no 'easy' fix i'm sure, but what I want to do is have the bulk copied over automatically. What, in practice, i'm hoping to do is [in my...

Thanks for both the responses. I didn't phrase my first post properly, but still got another function I can have a play with.

Thanks for that, although I'm, getting some strange results. Which would suggest I’m using it wrong. For the sake of getting manageable data I want to display the month I choose in my parameter field and the previous month. The following is my selection expert (My start date is 01/05/2002): -...

I need a report to give me all the info where the record date is within 6 months. I have a Start Date parameter field where the user will enter the start date i.e 01/04/03 I now need crystal to subtract 6 months from that. so Effectivly the only data CR extracts is betwwen 01/04/03 and...

Thanks very much, sounds simple enough but I'm still managing to go wrong somewhere! I've created my group (on REFKEY (CustomerKey), then when I go to the Group selection criteria and type Maximum({ADDR.EFFDATE},{ADDR.REFKEY}) when I check the formula I get an error 'the result of selection...

Our database has an address table (ADDR), within this table are a few fields a few of which are - ADDRTEXT, ADDRTYPE, EFFDATE and REFKEY. ADDRTEXT is the address text ADDRTYPE is a code '0' for customers perminant address, '1' for temporary address, '2' for site address etc... EFFDATE is the...

The {#Exam count per cat} running total is just a simple procedure count. I use it to ascertain the number of "A","B","C", etc.. Procedures. The report also groups by the procedure type (A,B,C, etc...), this running total is reset on the change of group.

Sorry, here it is : if GroupName ({REFEXAM.KCAT}) = "A" then {#Exam count per cat} * 1 else if GroupName ({REFEXAM.KCAT}) = "B" then {#Exam count per cat} * 2.5 else if GroupName ({REFEXAM.KCAT}) = "C" then {#Exam count per cat} * 6 else if GroupName...

How would I go about finding the sum of a formula field? I have my formula field displayed in the group footer#2 I now need a sum of this formula field displayed as a total in group footer#1. The formula I'm using is : Sum ({@Fomula Field}) then when I check this formula I get the following...

I have a report that needs to show the differences between two users. The problem I have is that the users can either have there own access rights or inherit them from a 'role' (all stored within the same table) How do I say in crystal speak 'If USER.ROLE is null then display USER.ACCESS...

Thanks, the web site didn't load though.. Not sure if this breaches the advertising rules that govern this site. Dgillz is also a very useful member here too.

Is it possible to change the orientation of groups? Ie instead of the default top to bottom have groups side by side (in a kind of landscape setting?) Cheers