Search results for query: *

Crystal XI SQL Server I tryiny to write a report where i ask the user for record selection based on values in the database field. The field can have several different values including nothing. In my prompt i list the values but i am having a problem of how to represent blank value - I have a...

CR XI JDE User Business Views I a trying to integrate more Crystal into our reporting environment and have run accross a situation where i need to link 2 tables. I have read that Crystals sub report feature works well when there is a many to many join between tables. here is my situation: Main...

Why won't a simple formula such as {#RunSum_Vat00}+{#RunSum_Vat04}+{#RunSum_Vat07}+{#RunSum_Vat16} not return the correct values? The running sum formulas are set to NOT reset. RJ Piekos

I have created a Dunning Letter in CR XI for our Spain office. The letter is in English and looks OK when i run it here in the US but when the Spain user runs it, the month names show up in Spanish. I am using the Crystal date format of DD MONTH, YYYY. Is there a way of not converting the MONTH...

CR XI SQL 2005 If my database date values are stored as Julian and I create a parameter to select on the date field, how do i get the dates to show in mmddyyyy format? i do have a function that i use in the report to convert julian to mmddyyyy but i need to select on dates that are in the...

I am writing a report that includes the full address of a customer in the form: {name} {addr1} {addr2} {addr3} {city} {state} {zip} In most cases the second and third address fields are blank so i want to suppress them and move the rest of the fields up. I have checked the suppress box on the...

Crystal Reports: V10 Data Source: MS Access First question: does suppressing a field simply not print it but leave the field space on the report? I have a report with 5 description fields. fields are stacked above each other in the detail section. most of the time, fields 3 thru 5 are blank. I...

I am trying to prototype row security in the stand-alone system (B8.10) but nothing works. roles don't work, user security doesn't work (users can sign on with out a password), the system user profile does not appear to work. does password security need to be required in order to make row...

I am new to Crystal (V 10) and had to jump into the Hierarchical Report feature immediately. The feature works fine except for when it comes to a record where the child field value is shared by more than one parent. It would appear that the first instance of the parent/child relationship is...