Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. MegOBytes

    How to treat null values in static parameter

    Thanks for your reply. This solution seems to be holding up- with trim. I was using "in {?parm}" most grateful Meg Thanks Meg
  2. MegOBytes

    How to treat null values in static parameter

    Thanks, The databse is MS SQL SERVER 2005 ERP System: JD Edwards Table: F4111 I used query analyzer to query the field in question: Select * from testdta.f4111 where ILDCTO = '' It returned all of the records with blank values. Changing the '' to ' ' (space betwwen the ') returned the same...
  3. MegOBytes

    How to treat null values in static parameter

    thanks for your input. i think i need to treat the blank value as a null because the record (inventory transaction) may or may not have a order type, so blank is a valid value. 2 issues arise. 1. the code produced an error message stating the "this array must be subscripted" . I have tried...
  4. MegOBytes

    How to treat null values in static parameter

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

    General question Concerning SubReports

    TurkBear: Thanks for the info. I have tried that scenario but it will fail when i encounter situation 'C' listed in my initial post. in that situation i get 4 lines (should only be 2): apdoc123 (line 1) = gldoc123 for line 1 apdoc123 (line 1) = gldoc123 for line 2 apdoc123 (line 2) = gldoc123...
  6. MegOBytes

    General question Concerning SubReports

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

    Adding running sum formulas

    other info: each running sum formula has an evaluate criteria that is specific to the run sum formula - as an example: {F4211.SDLITM} = "VAT00" (for the #RunSum_Vat00 formula) this criteria seems to work for the Vat tax that actually had data RJ Piekos
  8. MegOBytes

    Adding running sum formulas

    its returning null for the those sums because there were no VAT (taxes) for the report period. i understand your formula but i was wondering if there was a way to put if isnull({#RunSum_Vat00}) then 0 somewhere in the running sum dialogue box so that it at least returns a zero. RJ Piekos
  9. MegOBytes

    Adding running sum formulas

    Yes, they appear to be working. Only 1 running sum has an actual sum (#RunSum_Vat16), the other three return nothing as in not even a zero (which i formatted for). RJ Piekos
  10. MegOBytes

    Adding running sum formulas

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

    Spanish date names in an English Document

    thank you for the suggestion. the 2 dates that are affected by this are not database dates, they are 2 system dates: CurrentDate and DataDate i think i'll go with the if...then or maybe the select case RJ Piekos
  12. MegOBytes

    Spanish date names in an English Document

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

    Parameters and Julian Dates

    Thank you dgillz, that worked great. RJ Piekos
  14. MegOBytes

    Parameters and Julian Dates

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

    suppress fields not working

    Thanks for the suggestions. I am on version 11.5.9.1076 One other thing that i did not mention - the fields that i want to suppress are in the Group Header (#1a) section. I didn't know if that made a difference. I assume that when you say that i should insert a new section you are referring to...
  16. MegOBytes

    suppress fields not working

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

    Suppressing output

    Thank you, the text box approach worked just fine. RP Rick Piekos Massachusetts
  18. MegOBytes

    Suppressing output

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

    Stand-alone DEMO Security Problems

    thank you, i have posted there as well. RP Rick Piekos Massachusetts
  20. MegOBytes

    Stand-alone DEMO Security Problems

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

Part and Inventory Search

Back
Top