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

    Formatting calculated members

    I need help formatting Crystal Reoprts 2008 Calculated members. I have column 1, column 2 in cross tab. then Calculated Member Variance and Calculated Member Percentage. I would like Column 1, 2, and variance to be formatted for currency and Percent column formatted with % symbol. Any time I...
  2. jince0212

    Crystal Reports File Export

    We are using .NET application to call crystal reports 2008. When Report Displays user has option of exporting report. Default export for report format is Crystal Reports (RPT). 1) How do I change that to have Excel (97-2003) be the default? 2) How Do I set the report.rpt name in the file...
  3. jince0212

    Sort Formula Field in Crystal by date not Alpha

    thanks that worked! one more question step 2 if this is the group formula if {@Type} = "M" then if {MV_TRANS_DELPHI_ALLOC_SUMMARY.SOURCE} = '0' then "Allocations" else totext({MV_TRANS_DELPHI_ALLOC_SUMMARY.EXP_DATE}, "MMM, yyyy") else {@Column1} how do I get allocations as first column...
  4. jince0212

    Sort Formula Field in Crystal by date not Alpha

    thanks you for your quick response - I have done step one. On step two If {@Type} = "M" then ({MV_TRANS_DELPHI_ALLOC_SUMMARY.EXP_DATE}, "MMM, yyyy") else {@Column1} I am getting an error The ) is missing error at the comma after the field. Thanks much
  5. jince0212

    Sort Formula Field in Crystal by date not Alpha

    this is the formula I am using for @column1 - column one is in Cross-tab if {@Type} = "Q" then if {MV_TRANS_DELPHI_ALLOC_SUMMARY.SOURCE} = '0' then "Allocations" else "FY"+{MV_TRANS_DELPHI_ALLOC_SUMMARY.FISCAL_YEAR} + " " +(if month({MV_TRANS_DELPHI_ALLOC_SUMMARY.EXP_DATE}) in [10, 11, 12]...

Part and Inventory Search

Back
Top