Search results for query: *

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...

Hi Naith, When I use the set location under the database drop-down, I click on set location within the pop-up screen. This gives the list of ODBC connections I can use. I double-click the required ODBC connection. The SQL user password is prompted for (which I supply) The data explorer popup...

Hi, I am using CR8.5 and all I can see are tables up to the letter J. I sure this must be already covered but the search option is not working at the moment. The database has over 12000 tables !! Is there a limit on the number of tables that can be access in the list via data explorer...

Hi, If your on CR8 or above you can use loops. If not then its going to be difficult! Hth, Geoff

Hi, If you can create a view to split the memo field into string fields then you can use a formula like local numbervar p1 := instr({view.string_part1},'[') local numbervar p2 := instr({view.string_part1},']') left({view.string_part1},p1+1) + mid({view.string_part1},p2) Hope this helps...

I obtained this from a page on the web. This Html script works fine for the report specified. What would you need to change to make it work for a different report? (Eg. generated via an ODBC link to a SQL server database? Any info would be appreciated, Geoff <html>...