Recent content by FoxG

Hi, can someone give me an example using the parameter option to apply a record selection criteria to the query. I think it is something like &RSELECT='{fieldname}=value' Cheers, Geoff

CRCP Crystal Reports Certified Professional All-In-One Exam Guide (All-in-One) by Annette Harper Says its available soon from amazon.com currently at $40 Does anyone know anything about this new book, or when this is due to be released. In theory, this would work out cheaper than the three...

Hi mdwyer, Our firewall blocks this link.... Geoff

Hi, Does anyone know how to access the other user details that apply to a CE User ID/Name (ie. as defined in the CE user setup). What I could do with is a command/function that could access the CMS database to return the corresponding Fullname and/or Email details for either the current...

What does SE stand for?? I never used this term. CE stands for Crystal Enterprise (which I really didn't think would be necessary to spell out in full! Regards, Geoff

Hi, Does anyone know how to access the other user details that apply to a CE User ID/Name (ie. as defined in the CE user setup). What I could do with is a command/function that could access the CMS database to return the corresponding Fullname and/or Email details for either the current...

Hi Tony, I ended up doing the changes manually. However the help guide for version 10 states that this can now be done easily. Geoff

I have created a business view using the CE10 Business View Manager. Why am I unable to see the business view from CR10 when I attempt to select a data source from within the Crystal Enterprise CRM repository? Any help appreciated. Thanks, Geoff

Hi, Multiple 'if' lines is achieved using () eg. if a := 0 then (s := "Zero value"; if b := 0 then (a := 1; b := 2; c := 3) else (a := 3; c := 4) ) else (s := "Non-zero value"; b := 99 ) IF all you are trying to achieve is...

Hi FVTrainer, This is what I had already thought, but I cannot get the new replace command to be recognised within the ODBC connection. When you click on Ok after coping the SQL statement, I still can't see what I should do next!? Cheers, Geoff

Hi, I have a report using an oledb connection to an Oracle database. The report uses a command to determine the fields required from a specific table. I want to re-connect the report to the database via an ODBC connection that I have set up. When I try to set the source location it does not...

Exactly what I had in mind. Simple but effective!! Geoff

Hi, Just out of interest... have you used the save data with report option ? This will stop parameters from being requested. Geoff

Hi, If you only have one group, why are you grouping the report? You can achieve the same order using sorting. Can you not just suppress the text field if page_number = 1 Geoff

Thanks Rosemary... I will check the registry settings out to see what mine say. It a 3rd party product where each daily report generates it's own table to report from. Hence the number of tables increases by at least 10 every day. At present, these are being held indefinately. At some...